| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.]. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.]. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel:Swap cell contents-including cell groups-betwen 2 locations | Excel Discussion (Misc queries) | |||
| Update Excel cell in formula not refreshing answer cell | Excel Discussion (Misc queries) | |||
| How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
| copy excel cell to cell in word table using excel macro | Excel Discussion (Misc queries) | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
Linear Mode
