Merge Excel Docs
 

I need to merge two excel docs. Both have the exact same colomns of
data. But I updated some of the cells in the new document. I need to
merge those new cells into the apropriate rows and leave all other data

unchanged in the old document.

Unfortunatly, there really is no reference in the old or new document
that points to the specific row with the cells that needs to be
updated.

I could specify the rows by number in each doc if need be.

Not same number of rows/columns. Not limited to rows or columns -
random.

Volume is small, rows x columns is 761x9 in the old doc. 37x9 in the
new doc.

Here is an example of what I did to help us both better understand the
issue that needs help.

Let's say I'd a worksheet with 100 rows and 10 columns. Lets say the
columns are respectivly for last name, first name, street, etc.... and
each row is a diferent contact.

In each row, some of the data was incorect. Wether it be the name,
street, or whatever. Some of the rows had incorect data in random
cells.

I took, for example sake, 25 random rows, with incorect data somewhere,

and put them into a new excel doc. THey were not consecutive rows. I
then gave it to someone to update whatever they found to be incorect in

whatever cell.

I now need to merge the new data back into the old document in it's
correct row.

Thanks,

Sam