Update Spreadsheets

J

JorgeAE

I would like to update a spreadsheet as follows:
I have a master spreadsheet in which I use different codes to each
record. The second spreadsheet is modified with additional records or
some records deleted. Both spreadsheets have each record with the same
unique id number. The task I want to perform is to automatically update
the master spreadsheet.
 
J

John James

Hi JorgeAE,

When you refer to different spreadsheets I hope you mean different
worksheets in the same file (workbook). This is relatively
straight-forward. If you want to lookup values in a different workbook
based on codes, this is possible using the indirect and vlookup
functions IF both files are open. However I'd recommend avoiding this
if at all possible and combining the files into one workbook.

Here's how to do the lookup across different worksheets:

http://contextures.com/xlFunctions02.html
 
Top