Re: Merging two excel sheets and deleting duplicate data
You could do it easily by using Excel, rather than depending on a macro?
If you are looking this as a repetitive task, then a macro would be better.
Just push the data in sheet 2 into a collection
and then get the sheet1 data check unique or not and then update the collection to be pushed to the next worksheet.