title: Creating Loop to Hide Rows if Rows are Hidden on another Worksheet
body: <p>I am new to VBA and have created a macro that will take a value from a cell in worksheet 1 and match it to worksheet 2. If the row is hidden on worksheet 1 it hides the row on worksheet 2. I need to know how to loop it through all rows on worksheet 1 and 2. Then I need it to continue to match worksheet 1 to worksheets 3, 4 &amp; 5. I have looked but can't seem to find anything close in the various forums.</p>
  <p>This is what I have that works. I can post the various things I've tried but none work past the first row.</p>
  <pre><code>Sub HideRows
  
  If ActiveSheet.Range(&quot;A10&quot;) = Worksheets(&quot;Sheet2&quot;).Range(&quot;B5&quot;) And _
  ActiveSheet.Range(&quot;A10&quot;).EntireRow.Hidden = True Then
  Worksheets(&quot;Sheet2&quot;).Rows(5).EntireRow.Hidden = True
  
  End Sub
  </code></pre>
  <p>I apologize, this is the first time I have ever posted so I am very unfamiliar with how to phrase things or what I should post.</p>
  <p>Let me try again:</p>
  <p>I have a Master sheet. It has text data in column A on rows 10:185. If any of those rows DO NOT have numeric data in columns B thru T I have written a macro that hides those rows. Rows 10:185 are broken up by category on 5 other worksheets. I want to be able to hide the same rows in the other worksheets that are hidden on the Master sheet. I hope this makes things clearer.</p>