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