dropdown to show only part of data sheet

  • Thread starter Thread starter Durai
  • Start date Start date
D

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
 
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
 
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.
 
Back
Top