Sam,
I think we might have to resort your your semi-automated method
of supplying the row numbers. Construct a list of old (original) numbers and
the new ... say in columns A and B in one of the documents and then we can
loop through this list and replace.

Code in your "old" workbook ("Thisworkbook") could be along these lines:

For i=1 to 37
oldrow=worksheets("Sheet2").Range("a" & i)
newrow=worksheets("Sheet2").Range("B" & i)

ThisworkbookWorksheets("Sheet1").rows(oldrow)=Work books("Newbook").Worksheets("Sheet1").rows(newrow)
Next i

HTH

" wrote:

Hi Toppers, Thanks for the info!

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