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