Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation
Hi,
I have date like this Column A Column B Jun-2007 30 days Aug-2007 31 days Feb-2008 29 days I used data validation for Column A If I choose Jun-2007 in the column B I need only June date like 01-jun-07, 02-jun-07 .....................30-jun-07 Similarly for others. I don't want to create separate date list for jun,jul..... And then use =indirect function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
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) |