How do i edit links automatically?
If you put "JAN", "FEB" .... "DEC" in C1:C12 then you can use the following
in B1:
=INDIRECT(C1&"!A1")
and then you can copy that through to B12.
Sam
"Jaba" wrote:
Hi. Is there a way to replace embedded addresses? Example, cell A1 contains
the following formula =+JAN!A1; where JAN is the sheet name and A1 is the
cell address in sheet JAN. I want to copy the formula into cell A2 but change
the sheet from JAN to FEB to refer to sheet FEB, cell A1. INstead of using
"find - replace" or editing the formula, is there a way to link the "JAN"
portion only to a cell where i can input the month and the link will follow?
I hope this is not confusing...thanks.
|