Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a collection of worksheets that I set up, where entries for one sheet
are updated from another worksheet. In order to ensure that I can re-track data entries and amounts, I have placed hyperlinks to an off-print section of each worksheet so that I can quickly page from one spot of a worksheet to another. By entering an exact cell referencing, when I page to a sheet using the link, the resulant sheet has the targeted cell outlined. So far, so good, and things are working well. However: I'm wondering what happens when one inserts a row anywhere in a sheet, if that disrupts the hyperlinking. I.e., is there anthing that a person needs to do to ensure that the linkage reflects correct cell addressing? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi John
So you are concerned that say a link that points to A1 will still point to A1 even after a row has been inserted above he existing row1 - and you would prefer that the link now points at 2? I would create your links differently - just use a straightforward formula such as: =A1 instead of creating a hyperlink. If (in xl2003 and below) you go ToolsOptionsEdit tab and uncheck "Edit directly in cell" and then click OK, now back in the sheet, double-clicking on this formula cell will take you directly to the referenced cell. If a row is inserted, the formula will automatically be updated and so will take you to A2 etc. Hope this helps! Richard On 14 Jan, 09:19, John wrote: I have a collection of worksheets that I set up, where entries for one sheet are updated from another worksheet. In order to ensure that I can re-track data entries and amounts, I have placed hyperlinks to an off-print section of each worksheet so that I can quickly page from one spot of a worksheet to another. By entering an exact cell referencing, when I page to a sheet using the link, the resulant sheet has the targeted cell outlined. So far, so good, and things are working well. However: I'm wondering what happens when one inserts a row anywhere in a sheet, if that disrupts the hyperlinking. I.e., is there anthing that a person needs to do to ensure that the linkage reflects correct cell addressing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
how to build Dependency Trees in Excel | Excel Discussion (Misc queries) | |||
Drop down dependency stuff | Excel Worksheet Functions | |||
Need to output the dependency tree for formulas | Excel Discussion (Misc queries) | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) |