ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Cell (https://www.excelbanter.com/excel-discussion-misc-queries/225642-excel-cell.html)

John

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.].

Luke M

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