Two Worksheets similar data
 

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

Two Worksheets similar data
 

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

Two Worksheets similar data
 

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

tim m wrote:
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

Two Worksheets similar data
 

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

"Muddypaws" wrote:

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

tim m wrote:
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

Two Worksheets similar data
 

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

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

"Muddypaws" wrote:

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

tim m wrote:
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