| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation help
I am using Data Validation in cell A1 to choose 1 of 30 items and then I
would like to use validation again in Cell A2 but the list of information in the pull down for A2 is dependent on what was selected in A1(30 different lists). How do I make the A2 validation list dependent on what was selected in A1? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation help
See Debra Dalgleish's website for instructions on using Dependent Lists:
http://www.contextures.com/xlDataVal02.html Is that something you can work with? *********** Regards, Ron XL2002, WinXP "jimF" wrote: I am using Data Validation in cell A1 to choose 1 of 30 items and then I would like to use validation again in Cell A2 but the list of information in the pull down for A2 is dependent on what was selected in A1(30 different lists). How do I make the A2 validation list dependent on what was selected in A1? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation | Excel Worksheet Functions | |||
| Macro question | Excel Worksheet Functions | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
