Hi all,

I'm using Excel 2010. I have 2 worksheets (each in a separate workbook) that need to be merged into one. Both worksheets have the same format. However, the merging process need to eliminate duplicate entries if it finds that the same entry exist in both worksheets.

My problem is that the merging process need to consider an entry as duplicate only if the values in two of that entry's cells match those of the other worksheet. In fact I wont mind if the duplicate entries can be highlighted in one of the worksheets and I can then manually delete those rows (hopefully there won't be a lot of duplicates!) Or, it would be better if the worksheet could be copied onto another worksheet and the duplicate entries deleted there...thus, my master copy of the worksheet remains intact.

Should I seek VBA help here or is there a plain formula that can do this for me?