How do i edit links automatically?
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.
|