Hi everyone,

I have a workbook with multiple sheets. In the Intro sheet range M6 is a formula driven value. What I'm trying to do is have a macro which will search through each worksheet in the workbook in row 9, find a matching value to the one in the Intro sheet range M6. When the value is found, it will then copy the FORMULAS (not values) from range("B10:B100") in worksheet Formulas into the found worksheet starting at row 9, offset(3,0) so the paste would start on row 12. Below is the code I currently have. I'm not getting any errors, but its also not finding any values:

Dim ws As Worksheet
Dim mRng As Range

     
      For Each ws In ActiveWorkbook.Worksheets
        For Each cell In Range("9:9")
            If cell.Value = Worksheets("Intro").Range("M6").Value Then
                cell.Offset(3, 0).Value = Worksheets("Formulas").Range("B10:B100").Formula
            End If
        Next cell
      Next ws
Any ideas?

Thanks!!