Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use existing table to populate a drop down list & create a new tab
OK, here's a simple version of what I'm trying to do. I have this table set
up on a worksheet: Name: #: Color: Andy 1 red Aaron 2 blue Allison 1 green Anthony 2 violet Abdul 2 azul I want to create a drop down cell that lets me pick one of the values in the # column. Then, once I pick that, I want a table created below this drop down cell that is populated with the names and associated colors from the above table. So, in this example, my drop down cell would have the options 1 & 2 in it. And if I pick 1, then a table would be created like this: Andy red Allison green I know enough to do this piecewise, but my attempts to get this to work automatically isn't getting anywhere. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use existing table to populate a drop down list & create a new tab
How about an alternative?
You could select your range and then do data|filter|autofilter. Then you can use the dropdown to show the values you want. Etitan wrote: OK, here's a simple version of what I'm trying to do. I have this table set up on a worksheet: Name: #: Color: Andy 1 red Aaron 2 blue Allison 1 green Anthony 2 violet Abdul 2 azul I want to create a drop down cell that lets me pick one of the values in the # column. Then, once I pick that, I want a table created below this drop down cell that is populated with the names and associated colors from the above table. So, in this example, my drop down cell would have the options 1 & 2 in it. And if I pick 1, then a table would be created like this: Andy red Allison green I know enough to do this piecewise, but my attempts to get this to work automatically isn't getting anywhere. Any help would be greatly appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
How do i add a new entry to an existing drop-down list in Excel? | Excel Worksheet Functions | |||
Populate a column of data with a formula using a drop down list | Excel Discussion (Misc queries) | |||
Using a drop-down list along with an auto-populate drop-down | Excel Discussion (Misc queries) | |||
Populate Drop Down List | Excel Worksheet Functions |