dropdown to show only part of data sheet
 

I like to use a dropdown button to see data related to a row name.
Example
name item# amount
x ac 100
x ab 200
v aa 300
v ax 150
x ac 800
c bd 200
x cd 150
how can i use a dropdowm button inorder to see the details for name "x' only.
Any help Please

dropdown to show only part of data sheet
 

DataFilterAutofilter

Or drag the Autofilter Icon to a Toolbar

Click on it click on column A arrow and select "x" from dropdown.

A single button would require VBA.


Gord Dibben MS Excel MVP

On Mon, 30 Nov 2009 13:59:03 -0800, Durai
wrote:

I like to use a dropdown button to see data related to a row name.
Example
name item# amount
x ac 100
x ab 200
v aa 300
v ax 150
x ac 800
c bd 200
x cd 150
how can i use a dropdowm button inorder to see the details for name "x' only.
Any help Please

dropdown to show only part of data sheet
 

1) Click on row 1 where your titles are
2) Select DATA FILTER AUTOFILTER to activate the autofilter
3) Now use the drop down in the "name" column to select "x"

You should be looking at a filtered list. The rest is hidden.

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Durai" wrote:

I like to use a dropdown button to see data related to a row name.
Example
name item# amount
x ac 100
x ab 200
v aa 300
v ax 150
x ac 800
c bd 200
x cd 150
how can i use a dropdowm button inorder to see the details for name "x' only.
Any help Please