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: 2,069
Default dependency changes after row insert

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?
 
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
insert row / insert column command buttons fairgreen Excel Worksheet Functions 1 October 29th 07 02:41 PM
how to build Dependency Trees in Excel [email protected] Excel Discussion (Misc queries) 3 January 8th 07 08:07 AM
Drop down dependency stuff Pasty Excel Worksheet Functions 2 November 13th 06 10:13 AM
Need to output the dependency tree for formulas Adhiza Excel Discussion (Misc queries) 0 October 13th 06 04:51 PM
Insert Next? Or insert a variable number of records...how? Tom MacKay Excel Discussion (Misc queries) 0 April 20th 06 10:44 PM


All times are GMT +1. The time now is 02:12 AM.

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"