Hi

I have two worksheets in the same workbook, contact names, addresses
etc. However I know there are duplicates between the two worksheets.
Ideally what I am looking for is that I can consolidate the worksheets
and remove duplicate entires.

I have tried the unique Advanced Filter and that didnt work and I am so
struggling being a newbie to Excel, and here I am 1 day on and no
further forward.

Can someone please help me out here

Many thanks

Julie