simple formula, excel/VBA

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.

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 :-)

-----Original Message-----
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.
.

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

Jerry

Newbie wrote:

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.

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..?
-----Original Message-----
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.
.