| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create List from a Table
Example
On another Sheet: A B BEM 06T19 BFN 09S09 BEM 03R02 KIM 96R01 Now on another sheet I want a table that if I select BEM from a drop down (B2), it will show me 06T19 and 03R02 in cells B5 and B6 respectively. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create List from a Table
Use a macro tied to your down down to do datafilterautofilterfilter on your selection -- Don Guillett Microsoft MVP Excel SalesAid Software "Sunnyskies" wrote in message ... Example On another Sheet: A B BEM 06T19 BFN 09S09 BEM 03R02 KIM 96R01 Now on another sheet I want a table that if I select BEM from a drop down (B2), it will show me 06T19 and 03R02 in cells B5 and B6 respectively. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create List from a Table
Afternoon Don,
Trying to stay away from Macros. Is there not a formula that will produce the same result? "Don Guillett" wrote: Use a macro tied to your down down to do datafilterautofilterfilter on your selection -- Don Guillett Microsoft MVP Excel SalesAid Software "Sunnyskies" wrote in message ... Example On another Sheet: A B BEM 06T19 BFN 09S09 BEM 03R02 KIM 96R01 Now on another sheet I want a table that if I select BEM from a drop down (B2), it will show me 06T19 and 03R02 in cells B5 and B6 respectively. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create list based on data table | Excel Discussion (Misc queries) | |||
| How-to create a list from a summary table? (Office 2007) | Excel Worksheet Functions | |||
| Use existing table to populate a drop down list & create a new tab | Excel Discussion (Misc queries) | |||
| How to create list and count from a table? | New Users to Excel | |||
| How to create a data list from a pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
