I want to compare the data from 2 worksheets. first worksheet is my original data and second worksheet is my outcome data. while compare the outcome data against orginal data. If the information exist in the original data and outcome data then is fine, but if the outcome data duplicate the data(which means appearing twice). Then it shall the copy and paste to one of the data another worksheet (name: duplicate record).
Attached the sample excel file and the outcome. It will be great if anyone could assist in the marco. Thanks
Bookmarks