I need help for a VBA code to remove duplicate from one sheet to another sheet.
My 1st sheet contains the “raw” data starting from row “A8:B65000” (2 column). The sheet name is “Data”
On the 2nd sheet, the unique data will be copied starting at row “A12:B” (up to the last row) The sheet name is “Unique”.
How it works:
Data sheet – On this sheet the data is keyed every day.
Unique sheet – When I click on this sheet, only the unique data from the DATA sheet will be copied into this sheet, meaning all the data from DATA sheet minus the duplicate)
Thank you all.