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 AJ
Number of rows will change
I need to look in column H for any duplicates and wherever I find one I need to move one 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.