My sheet contains data in Columns(A:D)
I am trying to match C2 with C3, C4, C5, C6....C? and copy the entire row and its match to another worksheet in the same row.
Looping through each value in "C" and copying any matches to the next empty row
My sheet will be sorted by Column C and Column A (the date oldest to newest)
For example:
If C2 = C3 then
Copy (A2:D2) to Sheet("Copy").Range(A2:D2) AND Copy (A3:D3) to Sheet("Copy").Range(E2:H2)
if C2 = C4 then
Copy (A2:D2) to Sheet("Copy").Range ?? AND Copy (A4:D4) to Sheet(Copy") [To the next empty row in the sheet]
I have attached a sample workbook.
TEST COPY DT.xlsx
Any assistance appreciated.
Thanks.
Bookmarks