Home |
Search |
Today's Posts |
#1
|
|||
|
|||
retaining data after source cells move
I am trying to figure out how to keep the data in one cell from changing,
when it is a computation of other cells that may move. For instance, if I have a cell in column A that is =D3+D4 and then I do a sort on column D and the data that used to be in D3 and D4 moves to D6 and D7, how do I get my equation in the first cell to follow the data in the source cells and now read =D6+D7? Thank you. |
#2
|
|||
|
|||
=INDIRECT("D3")+INDIRECT("D4")
Regards, Peo Sjoblom "Allyson" wrote: I am trying to figure out how to keep the data in one cell from changing, when it is a computation of other cells that may move. For instance, if I have a cell in column A that is =D3+D4 and then I do a sort on column D and the data that used to be in D3 and D4 moves to D6 and D7, how do I get my equation in the first cell to follow the data in the source cells and now read =D6+D7? Thank you. |
#3
|
|||
|
|||
Thanks, but that didn't really solve my problem. The indirect just directs
the data to those sources, which now lives at D6 and D7. There is either no data or the wrong data in D3 and D4 now, and the cell in column A is picking that up. Is there a "FOLLOW" function or something like that? I'm looking at Help and not getting too far. Thanks for the help, though! "Peo Sjoblom" wrote: =INDIRECT("D3")+INDIRECT("D4") Regards, Peo Sjoblom "Allyson" wrote: I am trying to figure out how to keep the data in one cell from changing, when it is a computation of other cells that may move. For instance, if I have a cell in column A that is =D3+D4 and then I do a sort on column D and the data that used to be in D3 and D4 moves to D6 and D7, how do I get my equation in the first cell to follow the data in the source cells and now read =D6+D7? Thank you. |
#4
|
|||
|
|||
Sorry I misunderstood, no there is no way of having the formula following
the movement of cell contents, how could there be? -- Regards, Peo Sjoblom (No private emails please) "Allyson" wrote in message ... Thanks, but that didn't really solve my problem. The indirect just directs the data to those sources, which now lives at D6 and D7. There is either no data or the wrong data in D3 and D4 now, and the cell in column A is picking that up. Is there a "FOLLOW" function or something like that? I'm looking at Help and not getting too far. Thanks for the help, though! "Peo Sjoblom" wrote: =INDIRECT("D3")+INDIRECT("D4") Regards, Peo Sjoblom "Allyson" wrote: I am trying to figure out how to keep the data in one cell from changing, when it is a computation of other cells that may move. For instance, if I have a cell in column A that is =D3+D4 and then I do a sort on column D and the data that used to be in D3 and D4 moves to D6 and D7, how do I get my equation in the first cell to follow the data in the source cells and now read =D6+D7? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I move cells after data input without using enter or tab | Excel Discussion (Misc queries) | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Formulas in source data | Charts and Charting in Excel | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |