![]() |
Excel Cell
Is there some way to save the contents of a cell so that when you recalculate
with new data you do not loose the previous data from the last calculation. [eg. 1st calculation in A1 = 100, (Store the 100 if possible) 2nd calculation A1 = 50, 3Rd calculation in cell B1 add Stored data 100 and new data in cell A1.]. |
Excel Cell
You'd have to use VBA, and have a variable store the value.
If you need multiple values, why not write multiple formulas? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "John" wrote: Is there some way to save the contents of a cell so that when you recalculate with new data you do not loose the previous data from the last calculation. [eg. 1st calculation in A1 = 100, (Store the 100 if possible) 2nd calculation A1 = 50, 3Rd calculation in cell B1 add Stored data 100 and new data in cell A1.]. |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com