Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Part 2 of Show zero values only when data is..... | Excel Discussion (Misc queries) | |||
Why would Show All not be active in Filter part of Data menu? | Excel Worksheet Functions | |||
show only the required part of the sheet | New Users to Excel | |||
adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |