| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List source must be on same worksheet?
This is such a terrible limitation... isn't there any way around it? I
have a list that could be used on many worksheets, and if I have to copy/paste link it to all of those pages, it'll be a maint headache. I'm using the list(s) for Data/Validation lookups. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List source must be on same worksheet?
Hi
try the following: - create a defined name for your list (goto 'Insert - Name - Define') - use this name as data source within the data validation dialog also have a look at http://www.contextures.com/xlDataVal05.html -- Regards Frank Kabel Frankfurt, Germany "kiln" schrieb im Newsbeitrag om... This is such a terrible limitation... isn't there any way around it? I have a list that could be used on many worksheets, and if I have to copy/paste link it to all of those pages, it'll be a maint headache. I'm using the list(s) for Data/Validation lookups. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using one source list for two depends drop-down list | Excel Discussion (Misc queries) | |||
| Drop Down List - Source from another workbook | Excel Discussion (Misc queries) | |||
| Auto populate from list/source | Excel Worksheet Functions | |||
| Updating Source List | Excel Discussion (Misc queries) | |||
| Combobox list source | Excel Programming | |||
Hybrid Mode
