Hi Guys,
Could you assist me with the below please,
I want to just copy rows A:F when column A contains the word SSN. at the moment it copys the entire row, cannot figure this one out.
Private Sub Workbook_Open2()
Dim i, LastRow
LastRow = Sheets("Sheet1").Range("A" &...