dropdown to show only part of data sheet

[Durai]

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

 

[Gord Dibben]

Data>Filter>Autofilter

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

 

[JBeaucaire]

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.