shifting values

[ChinaBoat]

I have 100+ rows each with 6 cells (A-F) A & B contain variables which
may or may not change daily and C-F have values produced as follows:
C=A*B, D equals what was previously in C, E=what was in D, F=what was
in E, what was previously in F doesn't matter.

Can a formula be written to shift the values from one cell to the next
or does this have to be done manually everytime a variable changes?

Thanks for your help.

CB

 

[swatsp0p]

If I understand your situation, here's what you are trying to do:

When either A or B (or both) are about to change, copy the value in E
to F, D to E, and C to D then calculate a new C based on the new values
in A &/or B.

If this is correct, you could create a macro to copy C:E and paste them
in D:F; then enter your new A B values.

Would this work for you?

 

[ChinaBoat]

Well, duh...

Sometimes one forgets to kiss and starts looking for an "elegant
solution - thanks much for the answer and reality check <grin