You could possibly use the VLOOKUP function to retrieve your data using column() as argument


So supposing your old data is in range A1:G100 in the new range in B1 enter
=VLOOKUP(A1,wkbk_name_and_sheet!$A$1:$G$100,column (),false) and drag right and down. Adapt to your layout if needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I'm sorry, I had the story all wrong. This is the scenario.
I have 2 separate workbooks of data. The "new" one has 1000 rows of data. The "old" one has 750 rows of data. They both have the same exact columns. I need to look at the data in column "C" which is a unique part number. I have to find which 250 records have been added to the “new” and add them to the “old.” So, 250 records will be added to the "old" one and 750 records remain.
Your help is greatly appreciated, Karen