Maintain cell reference after value is moved
How can you keep a reference to another cell from changing even if the other
cell's contents are moved? The objective is to maintain a column of running summations, such as a projected bank balance, that refer to anticipated credits or debits in another column, even as those entries are moved about. For example, cell G100 has the formula =SUM(D$4:D100), which works only until the value in D100 is moved, say to D150, whereupon the formula in G100 is automatically changed to =SUM(D$4:D150). I can copy and paste the value to D150 and then just delete the old value in D100, but this is cumbersome when lots of figures are being moved around to effect an optimal result in column G. I would rather move the values. Can this be done in Excel? Thanks, Tim |
Maintain cell reference after value is moved
Hi,
use =SUM($D$4:$D$100) "tsfleet" wrote: How can you keep a reference to another cell from changing even if the other cell's contents are moved? The objective is to maintain a column of running summations, such as a projected bank balance, that refer to anticipated credits or debits in another column, even as those entries are moved about. For example, cell G100 has the formula =SUM(D$4:D100), which works only until the value in D100 is moved, say to D150, whereupon the formula in G100 is automatically changed to =SUM(D$4:D150). I can copy and paste the value to D150 and then just delete the old value in D100, but this is cumbersome when lots of figures are being moved around to effect an optimal result in column G. I would rather move the values. Can this be done in Excel? Thanks, Tim |
All times are GMT +1. The time now is 06:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com