Forum Discussion
Invoices to cashflow
Hi. I have a list of invoices and a cashflow spreadsheet. I know where I want the invoice values to appear in the spreadsheet because I know roughly when they will be paid. The main sheet has weeks for columns and the rows represent customers making the oayments. So I can calcuate for example that there is a £5000 invoice that needs to be added to the cell in column 15 row 20. At present I do this manually but is there any way using VBA or otherwise that you can think of doing this automatically? Thanks !
Maybe like in the attached where you can enter the week, customer and amount in cells C20:C22. Then you can click the button in cell E20 to start the macro.
- Yes. Exactly like that. Thank-you. I am just at the level to be able to read the code in the macro. Perfect that's saved me hours.
I’m glad my suggestion is helpful.
