At work we keep a monthly sheet running. Part of this is to keep a tally of cash in the safe (Amount in 50's 20's 10's ect). When adding or taking cash to this, often enough it's just use a calculator or work it out in your head and replace the old value with the new value.
What i want to do is to be able to add 2 cells to the left of the amount (for each item) One being a plus amount and one being a minus amount. But when an amount is entered it gets added, then disappears. (not really well explained so i'll try again, cell b5 has the amount of £20 we have eg £300, i want to be able to have c5 to add an amount and d5 to subtract. But when you enter the value b5 changes, and c5 and d5 return to blank)
The other question is, how do you get excel to move to a different cell when enter is pressed rather than the one below it?
Thanks in advance
Lego
What i want to do is to be able to add 2 cells to the left of the amount (for each item) One being a plus amount and one being a minus amount. But when an amount is entered it gets added, then disappears. (not really well explained so i'll try again, cell b5 has the amount of £20 we have eg £300, i want to be able to have c5 to add an amount and d5 to subtract. But when you enter the value b5 changes, and c5 and d5 return to blank)
The other question is, how do you get excel to move to a different cell when enter is pressed rather than the one below it?
Thanks in advance
Lego