Freezing output in cell??

[greenbean]

I hope this is the apropriate place for this question.

I am trying to make a workbook that will utilize an input sheet that
will use the inputs to calculate in other sheets. (easy).

These other sheets will have multiple periods that I will need to
calulate, thus each period will have the same formula and draw from the
same inputs. Is there a way to freeze the outputs that are calculated in
a cell so that I can then change the inputs and have that cell not
change but the next one will.
Example:

Inputs Outputs 1st 2nd
3rd
A=1 A+B 3 3
3
B=2

I want to be able to have each of these periods on the same sheet so I
can refer back to the prior period for comparison and so I will need to
somehow freeze the cell so that it will show the out put that was
originally calculated, but not change when I enter new inputs for the
next periods?
Example:

New Inputs Outputs 1st 2nd
3rd
A=2 A+B 3 4
4
B=2

The first period's outputs are frozen and stay the same because they
will not be affected by the changing of my inputs. Can this be done??
Thanks

 

[Bernie Deitrick]

greenbean,

You could use a macro to loop through your values, and in every loop after
the calculation is finished, copy and store the desired values into a data
table.

If that sounds like something you could live with, then if you need help
with the macro, post back.

HTH,
Bernie
MS Excel MVP