14th January 2012, 01:45 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
|
|
Not sure about a formula but here is a macro that will do it
Code:
Sub Calculate()
Sheets("Sheet1").Range("B3").Value = Sheets("Sheet1").Range("B2").Value
End Sub
Sub Reset()
Sheets("Sheet1").Range("B1").Value = 0
Sheets("Sheet1").Range("B3").Value = 0
Sheets("Sheet1").Range("B3").Value = Sheets("Sheet1").Range("B2").Value
End Sub
I have included a sheet so you can see how it works, i also included a reset code.
There is some code in cell B2 formatted to white so it is invisible. |