On 10 Apr, 16:12, Dave Peterson wrote:
The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed.
Laurent Longre has an addin (morefunc.xll) at:http://xcell05.free.fr/
That includes =indirect.ext() that may help you.
Ola2B wrote:
=+'Q:\directorate_sc\Forecasting Model\Monitoring Templates\Community
Care\2006-07\2XAA_Comm_Services\2XCA_Cultural_Services\a2\b2 \[b2
february Monitoring Summary.xls]KBJH'!$J$10. How do I replace the last
statement i.e. "KBJH" with cell reference i.e. $a$2 so that it changes
once the cell is changed.
Ola.
--
Dave Peterson
Thanks!