LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 2
Default Getting links to follow inserted rows

Hello-
I have a slightly complicated problem, so I'll try to make it as
simple as possible for anyone who wants to help (which I would greatly
appreciate).

I have a large range of data that needs to be entered into a worksheet
and then reordered in a second worksheet. The second worksheet is
nothing but links that put the data from the first worksheet into the
correct order.

My problem is this: whenever I insert a row into the first worksheet,
the numbers from the second worksheet don't change. I would like to
have a permanent link, for example, to cell A1 in Sheet 1, but when I
move that cell to D12, the link in Sheet 2 suddenly refers to D12.

Can the links be made to refer to a location, rather than a datum?
Thanks!
 
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
unwanted links come when new rows are inserted Twishlist Links and Linking in Excel 8 October 27th 07 01:27 AM
Unwanted links come with new rows inserted Twishlist Excel Discussion (Misc queries) 0 October 22nd 07 02:18 PM
LINKS TO FOLLOW FROM ONE SHEET (=SHEET2!C3) TO ANOTHER ?? John Excel Discussion (Misc queries) 1 June 21st 07 01:50 PM
Links Don't follow with copy [email protected] Excel Discussion (Misc queries) 1 September 22nd 06 10:37 PM
Inserting rows and having the formula follow workofiction New Users to Excel 1 June 21st 05 04:14 PM


All times are GMT +1. The time now is 04:43 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"