View Single Post
  #3   Report Post  
Stuart Farr
 
Posts: n/a
Default


Yes, if you open the files concerned, then go to the cell you want to
populate and type "=", then click on the source file and the cell you
want to link to and then preee <Enter. Take out the absolute signage
if applicable and copy the cell down the column.

Close the files. Open one of the source files and change a number. Save
and close the file. Then open the file with the formulas you earlier
established and click on Edit Links. You can then select Update values
to pull in the numbers.

Hope this helps


--
Stuart Farr
------------------------------------------------------------------------
Stuart Farr's Profile: http://www.excelforum.com/member.php...nfo&userid=478
View this thread: http://www.excelforum.com/showthread...hreadid=382625