Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Trying to create dynamic validation List (s)
After referring to one cell I need the data list to populate. If the reference cell changes the data list changes. Example: - Reference cell = A1 Columns D2, E2 and F2 have data populated Columns have headings, One, Two and Three If in cell A1 I input One, the List (DV) is from D2 to "list" end. If in cell A1 if I input Two, the List (DV) is from E2 to "list" end If in cell A1 if I input Three, the List (DV) is from F2 to "list" end Help greatly appreciated! -- Crunchies |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation Lists | Excel Discussion (Misc queries) | |||
Dynamic Data Validation | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |