| 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. |
| 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 | |||
Threaded Mode
