One of the problems with sorting through the new rows and old rows is,
row 15 in the new book could be row 65 in the old book.

I gota admit, I'm not really sure what you mean - you are definitly
more advanced than me.

I guess what your saying is sort the old workbook so the rows in
question are numbered 1-37 equaling the new workbooks row 1-37

Then run a macro with:

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


ThisworkbookWorksheets("Sheet1").rows(oldrow)=Work books("Newbook").Workshee*ts("Sheet1").rows(newrow )

Next i


???

thakns for the help.

Sam