Formula Help

  • Thread starter Thread starter Ray R
  • Start date Start date
R

Ray R

I am trying to create a spreadsheet which will when
changing a formula within a cell remember the previous
data held within the original cell and copy this
information into another cell, and also to carry out a
running total for these figures in another cell.
 
Hi
this would require VBA (using event procedures). Can't be done with
formulas alone. Is this a feasible option for you?
 
You'll need to use VBA to do this. I'm rather sketchy on the details of
what you're looking for - you want to save formulae? on any cell?
particular cells? What do you mean by "changing a formula"? Where should
the "another cell" be - same sheet? different sheet? different workbook?

What happens if the formula is "changed" again - is the data from the
first save overwritten or are both changed?
 
Apologies for not making this clearer. I want to enter a
formula into e.g B3 for one weeks information, then when I
want to add another weeks information, the previous weeks
information would feed into cell C3 and then cell D3 would
be a cumulative figure for the year. I am not up to speed
with VBA is there a particular method which would be
better to use.
 
Hi
I would re-design the spreadsheet to avoid using VBA for this. why not
use B3 for the first week and C3 for the next week.
 
Back
Top