If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a list from another sheet or workbook
How can i create a list (from Data Validation) based on data in another
sheet or work book? |
#2
|
|||
|
|||
Creating a list from another sheet or workbook
Create a named range of data in another sheet and refer the named range in
the list source... -- Jacob (MVP - Excel) "walrus" wrote: How can i create a list (from Data Validation) based on data in another sheet or work book? |
#3
|
|||
|
|||
Creating a list from another sheet or workbook
How do i put reference of the named range in the source? the name is "_GL".
"Jacob Skaria" wrote: Create a named range of data in another sheet and refer the named range in the list source... -- Jacob (MVP - Excel) "walrus" wrote: How can i create a list (from Data Validation) based on data in another sheet or work book? |
#4
|
|||
|
|||
Creating a list from another sheet or workbook
I got it.
Thanks..... "walrus" wrote: How do i put reference of the named range in the source? the name is "_GL". "Jacob Skaria" wrote: Create a named range of data in another sheet and refer the named range in the list source... -- Jacob (MVP - Excel) "walrus" wrote: How can i create a list (from Data Validation) based on data in another sheet or work book? |
#5
|
|||
|
|||
Creating a list from another sheet or workbook
Did you try
=_gl -- Jacob (MVP - Excel) "walrus" wrote: How do i put reference of the named range in the source? the name is "_GL". "Jacob Skaria" wrote: Create a named range of data in another sheet and refer the named range in the list source... -- Jacob (MVP - Excel) "walrus" wrote: How can i create a list (from Data Validation) based on data in another sheet or work book? |
#6
|
|||
|
|||
Creating a list from another sheet or workbook
Yes...
One more thing...the list is alphabetical and 600 items long so if i have to go to somewhere in the middle or the end, i have to scroll all the way there...any option to maybe auto-complete the text i am typing or go to at the point where the type alphabets start or something else? thanks.. "Jacob Skaria" wrote: Did you try =_gl -- Jacob (MVP - Excel) "walrus" wrote: How do i put reference of the named range in the source? the name is "_GL". "Jacob Skaria" wrote: Create a named range of data in another sheet and refer the named range in the list source... -- Jacob (MVP - Excel) "walrus" wrote: How can i create a list (from Data Validation) based on data in another sheet or work book? |
#7
|
|||
|
|||
Creating a list from another sheet or workbook
Hi
take a look at http://www.contextures.com/DataValHeadings.zip -- Regards Roger Govier walrus wrote: Yes... One more thing...the list is alphabetical and 600 items long so if i have to go to somewhere in the middle or the end, i have to scroll all the way there...any option to maybe auto-complete the text i am typing or go to at the point where the type alphabets start or something else? thanks.. "Jacob Skaria" wrote: Did you try =_gl -- Jacob (MVP - Excel) "walrus" wrote: How do i put reference of the named range in the source? the name is "_GL". "Jacob Skaria" wrote: Create a named range of data in another sheet and refer the named range in the list source... -- Jacob (MVP - Excel) "walrus" wrote: How can i create a list (from Data Validation) based on data in another sheet or work book? |
Thread Tools | |
Display Modes | |
|
|