Hi,

I have a problem with Excel 2003 which neither myself nor anyone in my office can solve. I hope you can help!

Essentially, I have two spread sheets which come from different sources in the office, which I would like to merge together into the same sheet.

One spreadsheet contains the columns 'Staff Name', 'Address' and Phone Number
the Other contains 'Staff Name', 'Address' and 'Date of Birth'

Some 'Staff Names' are common in each spread sheet and some are unique to each.

Some 'Address' columns are conflicting for the common 'Staff Names' entries.

I need an end solution where:
1, Staff Names from both spreadsheets have been merged into a single spreadsheet, but with only one instance of each (ie, no duplications).
2, Information has taken from the 'Address', 'Phone Number' and 'Date of Birth' fields and placed in the same row as the corresponding staff Names.
3, Where conflicting information occurs in the 'Address' field, I would like to have the capacity to choose which entry to use.

EXAMPLE

SHEET1
Staff Name=James, Address=Sydney, Phone=1111,
Staff Name=Sue, Address=NewYork, Phone=2222,
Staff Name=John, Address=London, Phone=3333,

SHEET2
Staff Name=James, Address=Deli, DoB=010160,
Staff Name=Steve, Address=Paris, DoB=010170
Staff Name=Joe, Address=Munich, DoB=010180,

SHEET3 - end result
Staff Name=James, Address=Sydney <OR> Deli, Phone=1111, DoB=010160
Staff Name=Sue, Address=NewYork, Phone=2222,DoB=<BLANK>
Staff Name=John, Address=London, Phone=3333,DoB=<BLANK>
Staff Name=Steve, Address=Paris, Phone=<BLANK>, DoB=010170
Staff Name=Joe, Address=Munic, Phone=<BLANK>, DoB=010180,

I hope this is clear enough and of enough interest for you to help me!

Thanks,

Nay.