I have two tables of data, one small with about ten rows of data and the
other thousdands of rows long. I want to lookup the records in the smaller
table in the larger table and where there is a match, replace the record in
the larger table with the one from the smaller table. I would need to select
a record from the small table, go over to the sheet with the larger table and
do a lookup of that record, paste when there is a match and return to the
small table for the next record.

Any pointers? Thanks.