Update Spreadsheets
 

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.

Update Spreadsheets
 

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=534035