I have a simple spread sheet when I list all my income and all my outgoings and balance at the bottom.
What I would like to do is add a macro so I could right click on one cell enter the amount I wish to take out, transfer it to another cell and have the balances updated automatically.
In cell (A1) I have bank credit of £200
I want to pay a gas bill(A2) of £36
Click on the bank account enter the £36 then click on the Gas Bill click again and the money is transferred leaving totals of £164 in the bank account and 36 in the gas bill account.