Hot Topics

excel 2010 transfer money atround

  Terry Brown 20:43 12 Aug 2014
Locked

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. E.G. 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.

How would I write one please.

Thanks for looking.

  lotvic 22:31 12 Aug 2014

This is a Duplicate, see other Thread for responses click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Huawei Mate Xs could’ve been the first great big-screen foldable

Creatives in China won't find this flag on Adobe, Getty or Shutterstock

The best games on Apple Arcade

Microsoft Surface Duo confirmé : date de sortie, prix et fiche technique