Cell reference
 

=+'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.

Cell reference
 

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

Cell reference
 

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!