Cell reference

[Ola2B]

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

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.

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

 

[Ola2B]

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.

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

Thanks!