View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default Reference a cell for a formula

Is there a way to have a formula that references a cell as part of the
formula. For example, I have the following formula in many cells...

'G:\B\BUDGET\2008 Variance\Jul08\[Jul Variances.xls]010 New York'!
$L32/1000. Is there a way to have the word "Jul" in a cell (A2) and
have +A2 as part of the formula. This is so that each month, I just
change A2 to the next month and all of my formulas change easily.

Thanks