Hello!

I am just getting started in VBA, and am trying to figure out something that seems simple, but that I keep tripping on. In the same macro, I would like to be able to do the following two things for an entire worksheet

Worksheet 1
A B C D
Red Blue Green Orange


Worksheet 2

Cell A5 = Red
Cell A6 = Pink
Cell A7 = Orange


I need to show columns in Worksheet 1, where the values of cells A1, B1, C1 and D1 are equal to the values in CellA5, Cell A6, CellA7 of worksheet 2. So in the above example, the macro would hide Column B, Column C and Show Column A and Column D.

Separately, I would love to be able to do a similar thing with rows.

A
North
South
East
West
Southwest
Northwest

I want to hide rows with the value "Northwest" and "Southwest", and show the rest.

Thank you so much for your help!