The INDIRECT function can be used to generate the formulas. However, in
theory, the INDIRECT function can only retrieve values from an open
workbook. I once downloaded an add-in from somewhere that had an
updated INDIRECT function that claimed to be able to retrieve data from
open and closed workbooks, but I don't remember where I got it from.
HTH
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=378062