Two Worksheets similar data

[Muddypaws]

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

 

[Guest]

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/dealing_with_duplicate_records_in_microsoft_excel.htm

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

 

[Muddypaws]

Dog, cat and horse - LOL

Thanks I will give this a try, I have been sat at my PC for ages and
nearly at crying point.

Cheers

 

[Guest]

I tested out both of those methods they mention in the link and they both
work quite well. (muddy hooves?)

 

[Muddypaws]

I failed miserably but will have a go with it at home whenre its quiet
and I dont get disturbed

Ta