merging worksheets question

  • Thread starter Thread starter bb
  • Start date Start date
B

bb

I have Excel2000, WindowsXP. I am new to Excel but have managed to get a
worksheet with names, addresses, rsvp's sum (bride's list). Now I have
received the worksheet by email from the groom's mother with her list except
in slightly different format. My question is how do I merge these two
worksheets so that in the end I'll have the entire wedding list alphabetical
by last name? I'm afraid to start trying it by myself for fear I'll lose
the whole worksheet. If this isn't clear, please advise. Will appreciate
any and all help in this matter.
Barbara
 
Barbara

That would depend upon how "slightly different" the format is.

Can you give examples of the layout in your worksheet and the layout in the
one sent by your Mother-in-law-to-be?

As an aside.....if you make copies of the orignal worksbooks and play with
those, you will never fear "losing" the worksheet(s).

Gord Dibben Excel MVP
 
Gord, thanks for your reply. My worksheet has First Name, Last Name,
address, city, state, zip, rsvp. The worksheet emailed to me to merge with
mine is Prefix, first name, middle name, last name, suffix, address, city,
state, zip, number of people.
 
Barbara

Do the two lists have any common data? Do the names on your book appear in
hers and vice versa? What, if anything, is duplicated?

You will first have to decide which information from each is to be kept as a
Master list and which of the two formats you want to keep.

The two currently have some common fields(columns) which could be amalgamated
just by copy/paste from Book1 to Book2 in the same columns. Duplicates can be
tagged and deleted. Additions would have to be made manually, I assume.

i.e. do you want middle names for all? Do you want Prefixes for all?

The uncommon fields can be copy/pasted into their own new columns.

Without seeing the two books and lists, it is difficult to say what should be
done. You would be the best judge of that.

If you wanted to send them to me(not the news group) to look at, I would be
willing to take a shot at it.

Make the obvious alterations to my email address if sending along.

Gord
 
Gord, none of the list is duplicated. I'll be glad to send along, but don't
seem to see your address. Do I just hit reply?
 
Make the obvious alterations to my email address if sending along.

LOL!

I believe Gord's address is


gorddibbATshawDOTca

replace AT with @ and DOT with .
 
Back
Top