Copy duplicate rows to new sheet
Posted on 2014-03-25
Could an expert provide me with VBA to move duplicates please.
I have a spreadsheet that has a header row in row 1
columns go from A to T
Number of rows will change
I need to look in column H for any duplicates and wherever I find one I need to move all of the items [complete row] to a new worksheet. [Named Duplicates] I also need the header row from Sheet1 copied onto the sheet named Duplicates.
So, if in Cell H3 I find abcdef and abcdef is also in H4 I need to move both rows to the sheet named duplicates
if in Cell H3 I find abcdef and abcdef is also in H4 and H5 and H6 I need to move all rows to the sheet named duplicates