So i need to Loop a range, well say A3:CZ2000. Header row is 2. If the loops finds "xyz" it copies the header cell in that column.
Example:
T17 contains "xyz", T2 is copied and pasted to another worksheet along with a few other cells from that row
Next loop
BC24 contains "xyz", BC2 is copied and pasted to another worksheet along with a few other cells from that row
RowCnt = 3
For Each cell In Worksheets("Sheet 1").Range("A3:CZ2000").Cells
If Abs(cell.Value) = "xyz" Then Worksheets("Sheet 1").Range(varCol & 2).Copy
Worksheets("Sheet 2").Range("D10").PasteSpecial Operation:=xlPasteSpecialOperationAdd
Worksheets .... 'copy a few other cells on that row
Worksheets .... 'Paste that info to Sheet 2
Next
Im at a loss for how to bring all this together
Bookmarks