| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
variable in data validation
I want to create a data validation where I can specify the month in one
column and in the next column, look up the dates for that month. To further explain, I have 12 named ranges, January-December (on a seprate worksheet). Can I set cell A1 to January and the data validation in B1 will lookup the dates for January. Change A1 to February and then it will lookup dates for February? -- Mike O. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help for multiple & variable validation function | Excel Worksheet Functions | |||
| data validation: variable drop down | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Variable validation-password protect sheet | Excel Worksheet Functions | |||
Threaded Mode
