| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a list of information from another sheet | Excel Worksheet Functions | |||
| sending workbook/sheet to recipient list | Excel Discussion (Misc queries) | |||
| Creating Sheet Tabs from a list | Excel Discussion (Misc queries) | |||
| Creating a List From Worksheets in a WorkBook | Excel Worksheet Functions | |||
| Creating seperate sheet lists from larger list | Excel Discussion (Misc queries) | |||
Hybrid Mode
