title: VBA to compare multiple column values then replace in multiple worksheets
body: <p>I need to compare values in columns E &amp; F of a workbook that has over 400 sheets, if E &amp; F are equal, replace column F with new text.
  I am quite new to excel and i have tried many different methods from google.</p>
  
  <p>the below (from google) works ok for 1 sheet, but i need it to do all sheets.</p>
  
  <pre><code>Sub findcomparereplace()
  Dim wsh As Worksheet, i As Long, lngEndRowInv As Long
  Set wsh = ActiveSheet
  
  i = 2
  lngEndRowInv = wsh.Range("E" &amp; wsh.Rows.Count).End(xlUp).Row
  While i &lt;= lngEndRowInv
  If Cells(i, "E") Like "*myvalue1*" And Cells(i, "F") Like "*myvalue1*" 
  Then
  Cells(i, "F").Value = "myvalue2"
  End If
  i = i + 1
  Wend
  End Sub
  </code></pre>