Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Greetings! I am using VISTA and Excel 2007. In sheet B I have hyperlinks to
certain cells in sheet A. That is, when I insert a hyperlink in sheet B, in "Insert Hyperlink," "Place in This Document," I type in the cell reference, say A2332. I have about one 80 hyperlinks in sheet B that if clicked, take me to various places in sheet A. A problem arises when I insert (or delete) a row (or rows) in sheet A, which puts all the hyperlinks in sheet B off by one or more rows. Is there anyway to update the hyperlinks in sheet B? I can do it manually, but it will take forever, especially if I insert or delete rows in sheet A occasionally. I do not know how to program, but it would be nice to have some way to update these hyperlinks. Do any of the experts have any suggestions? I'm stumped. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks & IF and INDEX Question | Excel Discussion (Misc queries) | |||
Web Query Updating Question | Excel Discussion (Misc queries) | |||
Updating Hyperlinks with VBA | Excel Discussion (Misc queries) | |||
Question Hyperlinks Help! | Excel Discussion (Misc queries) | |||
Question about hyperlinks in Excel | Excel Discussion (Misc queries) |