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!
|