Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unwanted links come when new rows are inserted | Links and Linking in Excel | |||
Unwanted links come with new rows inserted | Excel Discussion (Misc queries) | |||
LINKS TO FOLLOW FROM ONE SHEET (=SHEET2!C3) TO ANOTHER ?? | Excel Discussion (Misc queries) | |||
Links Don't follow with copy | Excel Discussion (Misc queries) | |||
Inserting rows and having the formula follow | New Users to Excel |