Update data from an external Excel spreadsheet
 

I am new to Excel and helping someone else with their Excel problems.

I did a copy/paste of information from a source spreadsheet to the
destination spreadsheet. The data does not automatically update
when it is changed in the source spreadsheet. I have automatic
setup in both spreadsheets. Is there a macro I need to install
to make it automatically update the destination spreadsheet?


The second problem is he wants to enter a value or select from a drop
down list and have certain cells in the destination spreadsheet
be updated from the source spreadsheet.

Thanks a lot for your help and advice.


--
marg
------------------------------------------------------------------------
marg's Profile: http://www.excelforum.com/member.php...o&userid=36437
View this thread: http://www.excelforum.com/showthread...hreadid=562449