Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combobox/data validation
I have a combobox that I need to pick up a list which is determined by
another combobox. i.e combobox1 is criteria A, I then need all the data in another sheet that one column matches this criteria to be available in combobox2. I have too many records to manually sort and is not practical to have to create lists manually. What I need is some way of picking out all of criteria A automatically. Would this be better achieved using data validation and pivot tables and if so, how?! Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combobox/data validation
One of these two links may provide a solution for you:
http://www.contextures.com/xlDataVal02.html or http://www.contextures.com/xlDataVal13.html "KneeDown2Up" wrote: I have a combobox that I need to pick up a list which is determined by another combobox. i.e combobox1 is criteria A, I then need all the data in another sheet that one column matches this criteria to be available in combobox2. I have too many records to manually sort and is not practical to have to create lists manually. What I need is some way of picking out all of criteria A automatically. Would this be better achieved using data validation and pivot tables and if so, how?! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation | Excel Worksheet Functions | |||
Data validation with hyperlinks | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |