Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep linked cell attached to it's source cell?
In the same workbook, i have a cell that references another worksheet cell
which gets re-sorted on occasion. When the source is re-sorted, the destination cell does not follow that cell. Changing the wildcards doesn't seem to have any effect. What am i missing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep linked cell attached to it's source cell?
Select the relevant range of cells before you sort.
-- David Biddulph "Dyefrog" wrote in message ... In the same workbook, i have a cell that references another worksheet cell which gets re-sorted on occasion. When the source is re-sorted, the destination cell does not follow that cell. Changing the wildcards doesn't seem to have any effect. What am i missing? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep linked cell attached to it's source cell?
I do that using the data-sort-by column (J) grabbing about 10 rows. The
problem is that the cell addresses are now in a different row than they were when the original link was established. The data in cell J5, which is referenced in a different worksheet moves to J8 for instance. This results in the new data in J5 being entered where i now want the data in J8. Is this making any sense? Somehow i would like the data in J5 which is referenced in a different worksheet to remain in the same cell in that different worksheet regardless of which row it moves to as a result of the sorting function. "David Biddulph" wrote: Select the relevant range of cells before you sort. -- David Biddulph "Dyefrog" wrote in message ... In the same workbook, i have a cell that references another worksheet cell which gets re-sorted on occasion. When the source is re-sorted, the destination cell does not follow that cell. Changing the wildcards doesn't seem to have any effect. What am i missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to get cell input message be attached to cell | Excel Discussion (Misc queries) | |||
Excel should allow clicking on a linked cell to jump to source | Excel Worksheet Functions | |||
PivTbl source: Can be linked cell? formula? | Excel Discussion (Misc queries) | |||
Updating the source of a linked cell | Links and Linking in Excel | |||
Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions |