Merging Two Worksheets

[Stella]

I have two worksheets with similiar data, ie. name, address, city, state, zip
code, phone numbers.

I need to merge these two files. I would like to have duplicates deleted
and have similiar and new data identified in some way.

Is this possible? I am a beginner user with Excel and am not familiar with
programing, etc.

So responses should be kept fairly simple.

 

[Meebers]

Can you copy both sheets onto a new one, sort them by Last name? look at the
duplicates and choose the data you want, combine some data, and delete the
others. This keeps both originals in place until you decide if this working
copy will be your final product.

 

[Stella]

I would have over 3000 data sets to look through. I was hoping there was an
easier method.

I have employee information from last year that I want to compare with this
year. With employees leaving and coming in, it makes the process a very time
consuming one.

 

[Meebers]

Don't know what version of Excel you are using, but you might also look at
advanced filtering and select unique. This will look at your entire data
set, filter out unique records, "it will hide duplicates". I would use the
same proceedure of combining both sets of data, run the filter on them and
see what you get. It might take a little practice since you said you were a
beginner. My company uses their badges to purchase meals with in our
cafeteria, I have thousands of transactions to deal with, I use the unique
advanced filtering to get only one incident of a badge number so that I can
use that to cross reference to name. This data is given to payroll.

 

[Otto Moehrbach]

Stella
Maybe I can help you with this. You say that you want "duplicates"
deleted. What constitutes a "duplicate"? You say that you have name,
address, city, state, zip code, phone numbers. If the names are the same,
is that a "duplicate" or must some other parts of the data also be the same
before you would say they are "duplicates"? What parts?
You say "and have similar and new data identified in some way." What
constitutes "similar"? What constitutes "new"? And how do you want these
"identified"? I would probably use programming for this and VBA (the
programming language) is extremely dumb and I would have to explain
everything to it, and I couldn't explain everything to it unless you
explained everything to me first. HTH Otto

 

[NoodNutt]

G'day Stella

Have just the thing that will help with your problem

Visit Ron DeBruin's Website

http://www.rondebruin.nl

Or follow this link page, entitled

(Merge cells from all or some worksheets into one Master sheet)

http://www.rondebruin.nl/copy2.htm

Take your time and read the instructions thoroughly.

HTH
Mark.

 

[NoodNutt]

Just to follow up my previous post Stella

For what you are trying to achieve, there is no real simple answer.

The simplest way without going down the track of using VB coding is to
manually check each one.

Might be time to step up to the plate and have a crack at it, you will
always get better after each failed attempt.

There is always someone here in the NG's that will try and help you should
it get all yoo hard.

Good luck
Mark.