|
| 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
May 14th, 2010, 06:51 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
May 14th, 2010, 07:39 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 14th, 2010, 07:47 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 14th, 2010, 07:52 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 14th, 2010, 07:53 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 14th, 2010, 08:48 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 14th, 2010, 09:31 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
