Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maintain cell reference after value is moved
Hi,
see your other post "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maintain cell reference after value is moved
try this:
=SUM(INDIRECT("D4:D100")) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintain cell reference after value is moved | Excel Worksheet Functions | |||
Move cell and maintain reference | Excel Worksheet Functions | |||
Lock cell reference in formula, even when moved with click & drag | Excel Worksheet Functions | |||
Maintain proper links when Excel cells are moved | Excel Discussion (Misc queries) | |||
Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions |