Drop Down Filter, Unhide Rows

[Rich9016]

Hi guys, I need help please. I'm trying to set up an excel chart wher
if I select an item from a dropdown autofilter, certain rows wil
unhide while others will remain hidden. Or even easier, certain row
will just appear for certain selections and not others.

For example: I have "wine" as my title with a dropdown box, both in A5
A7-A47 are various wines to select. If I select "ace wine", I wan
rows 52-75 to appear while the other rows remain hidden. Currently
have data between rows 52 and 200, but that can expand. Is there an
way I can do this? Am I going about this all wrong, is there an
easier way to do this?

Hopefully I'm explaining this right. Any help would of course b
greatly appreciated.

Thank you all in advance!

Ric

 

[Dave Peterson]

It kind of sounds like you have a column that contains a key. But that key is
only on the first row of the group.

If that's true, you could fill the other rows with the same key using techniques
at Debra Dalgleish's site:

http://www.contextures.com/xlDataEntry02.html

Then you could use Format|Conditional Formatting to make it look like those
cells are blank:

Select your range (A2:A999 say)
format|conditional formatting
choose "Cell Value is" "Equal to" =A1
(that's the cell above the activecell in your selection)
(remove any $ signs that excel may have added (if you pointed at that cell)

Then format it so the font color matches the fill color (white on white?).

 

[Dave Peterson]

And then you can filter on that column (everything but the real conclusion in
that other post!)

 

[Rich9016]

that worked! my only problem is that i need rows to actually hide an
unhide because there's a chart connected to them. so i can't jus
change the format.

any way i can have rows unhide and hide depending on what i select fro
the drop down filter

 

[Rich9016]

bum

 

[Dave Peterson]

When you filter on that column, don't some rows get hidden?