Thread: Cell reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ola2B Ola2B is offline
external usenet poster
 
Posts: 32
Default 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.