| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable in data validation
Refer the below link on dependant lists
http://www.contextures.com/xlDataVal02.html -- If this post helps click Yes --------------- Jacob Skaria "Mike.ONeal" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable in data validation
Take a look at Dynamic Validation (sounds like you've got the setup ready
already!) http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mike.ONeal" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable in data validation
Jacob,
Thank you very much. This did the trick. -- Mike O. "Jacob Skaria" wrote: Refer the below link on dependant lists http://www.contextures.com/xlDataVal02.html -- If this post helps click Yes --------------- Jacob Skaria "Mike.ONeal" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
variable in data validation
Thanks for the help. This did the trick!
-- Mike O. "Luke M" wrote: Take a look at Dynamic Validation (sounds like you've got the setup ready already!) http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mike.ONeal" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
