Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Links | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
VBA to edit links | Excel Discussion (Misc queries) | |||
edit links | Excel Worksheet Functions |