I have two sheets on Excel and I need help for a VBA code to copy the data from the DATA sheet to the DEDUP sheet, removed duplicate and sorted. Macro is triggered when DEDUP sheet is activated.
Sheet 1 named “DATA” and it has the data starting from column F8, (F7 is the heading)
Sheet 2 names “DEDUP”, in this sheet the dedup and sorted data will be copied starting at N12, (N11 is the heading)
I need help guys. Thanks a lot in advance.
Bookmarks