Update Spreadsheets

[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.


--
JorgeAE

[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. An alternative is using macros to perform the lookup, in which case the source file can be closed. However I'd recommend avoiding the complexities 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