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
|