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