I want to try and produce a single list of items in a range where the cell in column A is not empty.
So far I have the following;
LastRow = Sheet2.Cells(Rows.Count, "A").End(xlUp).RowFor Each Cell In Sheet2.Range("A12:A" & LastRow)
If Cell.Value <> "" Then
FaultyList = "Site: " & Cell.Value &...