I've spent all day editing a large sheets (21000 rows, each being a customer
record), and have found that I've lost the data in one column.
I still have the original, unedited workbook, so do have the missing data
available, but as the editing included deletion of many rows, the row
numbers no longer match, so I can't just copy and paste the column.
What I want to do therefore is:
take the content of two cells from a row in workbook "A", and use that to
find the corresponding row in workbook "B". Then, having found the correct
row, take the contents of one cell in that found row, and insert it into a
given cell back in the original row in workbook "A".
Then repeat for the remaining 20999 rows in workbook "A"!
Is that possible?
Thanks,
Mark
Bookmarks