I started with one sheet (using Excel 2003) but took a copy home (on a flash
drive)to work on and added data (both numbers and "X" 's) - using Excel 2007.
I saved the work done at home so Excel 2003 could "read" it. Then, I did
some work on the copy my computer at work (BIG mistake!!)

So, the problem is: I have some data on my flash drive copy which is not on
the work computer sheet, and vice versa. I want to merge the 2 copies - so I
cannot replace either one because data will be lost.

Options??? Way to do this? (It seems like it will be easier to "Compare
and Merge" in 2003, correct? No way to do this with Excel 2007?

Hi,
look into CPearson web, look for Compare

http://www.cpearson.com/excel/download.htm

"Excelnewbie" wrote:

I started with one sheet (using Excel 2003) but took a copy home (on a flash
drive)to work on and added data (both numbers and "X" 's) - using Excel 2007.
I saved the work done at home so Excel 2003 could "read" it. Then, I did
some work on the copy my computer at work (BIG mistake!!)

So, the problem is: I have some data on my flash drive copy which is not on
the work computer sheet, and vice versa. I want to merge the 2 copies - so I
cannot replace either one because data will be lost.

Options??? Way to do this? (It seems like it will be easier to "Compare
and Merge" in 2003, correct? No way to do this with Excel 2007?