simple formula, excel/VBA

[Newbie]

I have a simple excel spreadsheet with numbers in cells
B3, C3,D3 & E3. When I input a new number in cell B3, I
would like the original number in cell B3 to move to cell
C3, likewise D3 will take on the value of C3 and E3 will
take on value of D3 etc. I am not sure if this can be
programed with excel or VBA? If anyone has a formula to
do this I would appreciate your assistance.

 

[Frank Kabel]

Hi
this could only be done using an event procedure (e.g.
using the worksheet_change event).
But before usinmg this you may consider using a different
approach without using such event procedures. You may
explain your goal behind this

 

[Jerry W. Lewis]

Worksheet functions have no memory. You could write a VBA macro tied to
a worksheet change event to do this.

Jerry

 

[Guest]

Seems to me your goal may allow for easier transitions.
Can you use a separate cell for the variable entry or do
you need it there..?