Merging two Excel Sheets

[scottatwittenberg]

I have 2 excel sheets..

both were the same copy a few weeks ago..

2 different people have been editing both copies of this file since then.

"spread sheet 1" has a few less rows than "spread sheet 2"
"ss2" has dates entered into a few of the columns which are blank cells in "ss1"

when i google ways to merge excel sheets, i get 3rd party programs.. the only one i found that uses only what comes with excel is an explanation of how to share a workbook that tracks the changes in multiple copies and then can merge them back later..

this wasn't done a few weeks ago of course..

so who here has any ideas of what i can do?

thanks

scott

 

[hity645]

I suppose copy and paste is outta the question?

I did a quick scan through of my excel 2003 book and under the Data menu thers an Import External Data menu, then theres the Import Data option.
Try that and make sure you have backups. If not theres a whole slew of instructions on "collaborating" a workbook that I can retype for ya.