View Single Post
  #1  
Old July 14th, 2009, 09:51 PM posted to microsoft.public.excel.links
[email protected]
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!