Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing named Validation list to Dynamic list.
I've set up a worksheet where row 2 contains column titles and data
validation. Below this is are the data entry cells with validation lists based on column title. The validation lists are named ranges on another sheet called Tables. I get proper drop downs. Some of the lists are queries and I want them to be dynamic lists. When I change a name reference to "=OFFSET(Tables!$B$2,0,0,COUNTA(Tables!$B:$B)-1,1)" I no longer get the drop down. When I try to GoTo the named range it doesn't show on the GoTo list. Formulas like "=CountA(Media)" work correctly. Any help would be appreciated. Glen -- Glen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic named list includes blank cell at bottom | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
List Box with dynamic list - Help | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |