Kelly******** wrote:
Can someone write me a couple of line of code?
3 cells to add 4th cell contains total
In cell c5 if a number from 1 to say 50 is entered then that number has a
value. The value being for instance 1 would be 50, 2 would be 49, 3 would be
48 and so on. The cell on the sheet will display 1, 2, 3 still.
If cell c5 has a number key into it then cell d5 will automatically get a 2
filled into it.
cell e5 might be manually entered as a 1.
Then cell f5 will total the cells, remember cell c5 might display a 1 but in
the total it is 50
So if c5=1 d5=2 e5=1 f5=the total 53
I will want to duplicate this several times across the sheet and down the
columns.
h5. i5. j5. k5 m5, n5, o5, p5 and so on


Enter into F5: =51-C5+D5+E5 and copy down.

Allan Rogg