Notwithstand the subject title, I admit I don't know how to achieve what I need.
Which is, the club has a budget of £500, when I make a purchase of stationary for £30, I would like to see the running total now read £470. I've looked at the download section and I have Excel. I just don't know where to start. Any ideas please?
If you send me your email address - via yellow envelope - I can send you some modules for beginners on Excel. I wrote these a souple of years ago and should be still current and give you the gist of Excel.
If you have Excel it is very easy. In its very simplest form. Open Excel into a new spreadsheet.
Label Column A1 as Purchases Label Column B1 as Balance.
In Cell B2 enter 500 (you should really format all the cells from A2 and B" downwards to show Currency or Accounting where you will get the option to have the £ sign and the number of decimal places added automatically) You can foprmat cells by highlighting them then right mouse click and select Format Cells...
In cell A3 enter the amount you have spent 30 and in cell b3 enter b2-a3. The result will be the difference between the two cells and this will automatically be shown in A3 when you move to a new cell or click enter
You can continue to do this for each successive purchase each time changing the difference cell to be B2 minus the appropriate a cell.
There are a lot of ways to make this table more useful and of course more complicated, but as you use Excel you will discover these. Help really is helpful