If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
Display Modes | |
|
|