Show Columns Matching Cell

[Kingprawn]

I have found a few related answers but could not modify the code to work for my application.

I need to check cells F2:AR2 against D2 for a match and hide all columns not matching. Then also hide any values in F8:AR8 >1.

[rylo]

Hi

How about

Please Login or Register  to view this content.

rylo

[Kingprawn]

This results in hiding the entire range. The match is looking for day of week, (Mon, Tue, Wed...) in F2:AR2. Does it matter if the day of week in the range is from a formula?

[rylo]

Hi

How about an example file showing the before and after situations and explaining why things are hidden and why they are left visble.

rylo

[Kingprawn]

Thank you for taking a look rylo;

I attached a sheet with the data values. I am looking for a way to quickly allow others to compare the data for the same day of the week over the course of a date range. This format is dictated to me so I am trying to maximize what I have.

I will place a drop down in D2 for the day of week selection. Will need a Show All option too...

[rylo]

Hi

So what about the requirement for row 8 >1 to be hidden? Given this file, the only one that would remain visible would be AJ if you select Friday.


rylo

[Kingprawn]

Hi

So what about the requirement for row 8 >1 to be hidden? Given this file, the only one that would remain visible would be AJ if you select Friday.


rylo

That was my typo, it should have been <1. That fixes that issue. I think I can handle it from there. Thanks again!

[Kingprawn]

I broke it when I tried to add the Worksheet_Change

Please Login or Register  to view this content.

[rylo]

Hi

Try this

Please Login or Register  to view this content.

I've also changed the final cell selection to be E1 instead of F1 as column F may be hidden at some stage.

rylo

[Kingprawn]

Perfect, it seems so simple when I see it. Need to commit to learning the language. Thank you kindly again.