Is there any way to use a variable in a formula? I have
two workbooks that I need to add together each month.
Rather than go in and use find replace each month to
change the formula I would like the formula to
automatically do it. Example - two workbooks WB1 and
WB2, formula for this month = +A1+'[WB2.xls]A1. Next
month WB2 will be WB3, so I need a formula in WB1 that
will be "+A1+'[WB3.xls]A1" . In WB1 cell A2 I have the
corresponding month so in month 3 it would be 3 etc. So
the formula that I am trying to create is "=A1+(WB
&"A2".xls]A1". Obviously it does not work.

Any ideas would be very much appreciated.