how to combine multiple versions of single spreadsheet?

[Lee]

Well, the doomsday scenario has happened - two colleagues working on the
same spreadsheet fail to communicate. Each has updated a project tracking
sheet at the same time so we now have two new versions. Is there a way of
Excel combining the latest data out of each sheet?

To clarify:

Person X opens spreadsheet version A to update and creates version B
Person Y opens spreadsheet version A to update and creates version C

There is a lot of work entailed in updating the sheets but luckily persons X
and Y have their own projects so they do not update the same information.

Is there a way to combine B and C into a master version D containing all
updated information?

Thanks

Lee

 

[Lee]

Well, the doomsday scenario has happened - two colleagues working on the
same spreadsheet fail to communicate. Each has updated a project tracking
sheet at the same time so we now have two new versions. Is there a way of
Excel combining the latest data out of each sheet?

To clarify:

Person X opens spreadsheet version A to update and creates version B
Person Y opens spreadsheet version A to update and creates version C

There is a lot of work entailed in updating the sheets but luckily persons
X and Y have their own projects so they do not update the same
information.

Is there a way to combine B and C into a master version D containing all
updated information?

Thanks

Lee

This is for Excel 2003 by the way.