I have a range of cells E1:E100 with, just values. I would like to put a number in the corresponding cell G, hit ENTER, and have this number subtracted from the cell in column E, and display the result. I then would like the cell in column G to go blank so it can have another entry at a future date.
Likewise I would like to put a number in the corresponding cell F, hit enter and have this number added to the cell in column E, and display the result. I then would like the cell in column F to go blank so it can have another entry at a future date.
Example: E1 contains the number 10. I type in the number 3 in cell G1 and hit ENTER. E1 should change to number 7 and cell G1 should now be blank. If i typed the number 4 in cell F1 instead and hit ENTER, E1 would have changed to number 14 and cell F1 should now be blank.
I thought this code should do that but it does not seem to work:
Thanks in advance for any help.
Bookmarks