Comparing AND Combining Worksheets

[Guest]

Hi,

I am not SUPER proficient at Excel, and I could really use some help.

I have to create a Christmas card list. I am going to export eight contact
lists from our eight employees Outlook into eight different Excel sheets.

Is there a program/a way to then combine AND compare these sheets? I.e., I
want a comprehensive list of contacts, but without all the duplicates.

Any advice/help would be greatly appreciated!

 

[Dave Peterson]

After you create the 8 different worksheets (all the same column layout,
right?), you can just create a 9th sheet and copy all the data from each sheet
into that 9th sheet.

It won't be too bad to do this manually. Just select the range, edit|copy and
go to the bottom of the ever growing list and edit|paste.

Then you'll have a giant list consisting of all 8 contact lists.

Then your trouble will start.

Is "Charles Jones" the same as "Chuck Jones" the same as "Charlie Jones" the
same as "C. X. Jones"?

You can sort by some key field (email address or last name???) and try to
eliminate duplicates.

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

 

[Guest]

Thanks - I was already sort of doing that, but praying there was something
easier! I will check out the link.