Hide unspecified rows in another worksheet based on a cell value

[Ego14]

Hello

I want to hide rows using VBA with this scenario:

In Worksheet 1, Cell A1 = Apple & Cell B1 = No ---> Then in Worksheet 2, All rows containing Apple in Column A will be hidden
In Worksheet 1, Cell A2 = Banana & Cell B2 = No ---> Then in Worksheet 2, All rows containing Banana in Column A will be hidden

If the value of cells B1 and B2 are Yes in Worksheet 1, then the rows should not be hidden. The range of the rows is unspecified and can change from one day to another.

I've searched everywhere in this forum but haven't seen yet a similar scenario. Many thanks in advance for any help!

[stnkynts]

Please Login or Register  to view this content.

[walruseggman]

Another approach. Again, change the sheet names in the code to match your actual sheet names.

Please Login or Register  to view this content.

[Ego14]

Hi stnkynts

I tried using your code, but I'm afraid I'm not sure how to use the "Dim i As Long", so the code wasn't running properly. Thank you so much for the help though!

[Ego14]

Another approach. Again, change the sheet names in the code to match your actual sheet names.

Please Login or Register  to view this content.

Hi walruseggman,

Thank you so much for the code!

Not only did it work perfectly, I was able to make several iterations and tweaks to be able to use it based on how I needed it (the apple and bananas were just the simplified version of my scenario)