Hi,
Sheet 1, starting with Row 14 thru Row 44, if A = yes then the same row on sheet 2 should be visible
Right now I do this through the worksheet change event and I gave each cell a name. I go through a very long process and I check the contents of each cell on change
If Sheet1.A14 = "yes", sheet2 row 14 = visible otherwise not visible (so there are 29 separate if statements). (I gave the rows on sheet 2 names as well that are similar to the names in sheet 1)

Is there a simpler/better way to write this without going through each named cell? Some sort of loop I can do in the change event?

Thank you!