ksmith
03-13-2019, 08:41 AM
Thanks in advance for the help..!
The smaller spreadsheet has around 8,000 records and the larger spreadsheet has around 20,000 records. The larger spreadsheet have the correct (updated) cost and the smaller spreadsheet have the out-of-date costs.
What I have been doing is to import both of these spreadsheets into Access and then export them back to a spreadsheet after I've ran an Update Query.
I was looking for a way to do this in Excel without using Access.
Thanks,
KSmith
The smaller spreadsheet has around 8,000 records and the larger spreadsheet has around 20,000 records. The larger spreadsheet have the correct (updated) cost and the smaller spreadsheet have the out-of-date costs.
What I have been doing is to import both of these spreadsheets into Access and then export them back to a spreadsheet after I've ran an Update Query.
I was looking for a way to do this in Excel without using Access.
Thanks,
KSmith