Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Named list issue
Good Afternoon All,
I was wondering if you could help me. I have 2 drop down lists where if I choose Option A in list 1 it automatically updates list 2 and vice-versa. (I found an excel sheet one this discussion group with really helped me figure this out) The numbers list users the following source data:- =OFFSET(Data!$D$2,0,0,COUNTA(Data!$D:$D)-1,1) At the moment this chooses from the list and goes from D2 to D149, however my list contains over 170 names. Can any one help me alter the formula to include the other lists. Many thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Issue? | Excel Discussion (Misc queries) | |||
Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |