Have look at this and see if it is of help. If you are going to want to
consolidate into one sheet then your 1st step would be to copy all of the
data on your 2nd sheet to the bottom of your 1st sheet (if they have the same
row/column format.)

http://www.officearticles.com/excel/...ft_excel. htm

(ps like the name, you must be a dog owner. :O) )

"Muddypaws" wrote:

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