LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Hyperlinking to another worksheet in existing file

Help !! I am putting in hyperlinks in worksheet "A" to go to particular
cells in worksheet "b". The probelm is, in worksheet "b" I will be
continually editing which causes the destination cells (those being
hyperlinked to) to get all out of whack. For instance, if I have a hyperlink
in worksheet "A" to reference cell "C15" in worksheet B and then I insert a
row in worksheet B before row 15, it messes up my hyperlink. I am then
hyperlinked to the newly inserted row/cell. Is there a way to set the
hyperlink so that it adjusts as rows are added in my worksheet "B"?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinking from Outlook 2003 to an excel Worksheet fidgitthedigit Excel Discussion (Misc queries) 0 May 4th 06 07:13 PM
Importing text file, only option to edit existing file smokey99 Excel Discussion (Misc queries) 8 April 26th 06 09:08 PM
hyperlinking worksheet info to the footer sadie_m_lady Excel Discussion (Misc queries) 0 February 15th 06 05:51 PM
hyperlinking from excel to a point within a MP3 file AussieAVguy Excel Discussion (Misc queries) 2 February 9th 06 04:36 AM
Can't open a png file when hyperlinking through Excel. How to do? Chris A Excel Worksheet Functions 0 January 19th 06 10:06 AM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"