Hi all
Just need a bit of a pointer with this loop i'm building. For the first instance of "Yes" i want to just use sheets.select (i.e drop whatever sheet(s) are selected), but then use sheets.select false, for the rest.
For j = 5 To 9
If Sheets("ReportList").Cells(I + 2, j).Value = "Yes"...