Hello, i have written the following which i hoped would extract the relevant rows for me, however it currently returns no results.
Sub Test()
For Each Cell In Sheets("submission report").Range("bd:bm")
If Cell.Value = Sheets("instructions").Range("a8") Then
matchRow = Cell.Row...