Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
In Excel 2007... Is there any way I can use a column in a Named Table as my data validation list without specifying the range. For example I have a table named MyTest of ID/Name. I want to display the Name column as my data validation list. Any time I try using my source as =MyTest[Id] in the DataValidation List Source I get an error. I want to find a way to do this without specifying the given range within my table because my tables might use different start range cells. Thanks, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data validation list from table | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
How to copy data validation utilizing a list to the entire column | Excel Worksheet Functions |