spectraflame
Well-known Member
- Joined
- Dec 18, 2002
- Messages
- 829
- Office Version
- 365
- Platform
- Windows
I have a column (D) with a manually keyed in number. I would like to input either a positive or negative number in column E and then automatically add or subtract the E value to the D value and clear the contents of E.
If D contains the value of 100 and I key in 25 in column E, the value in column D would change to 125 and column E would then be blank.
I feel that a worksheet change function would do this, but I have no idea where to begin.
Matthew
If D contains the value of 100 and I key in 25 in column E, the value in column D would change to 125 and column E would then be blank.
I feel that a worksheet change function would do this, but I have no idea where to begin.
Matthew