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

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

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

Create List from a Table
 

Why stay away from macros?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sunnyskies" wrote in message
...
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