I’m an Excel numpty, so don’t know if this is possible
I have a spreadsheet and one one sheet are all my invoices and payments with dates against them in a separate column. I also have a balance sheet on a different sheet with a rolling date down the left hand column, then various columns for costs/payments/vat etc.
What I want to achieve is, when the date in a column on the invoicing sheet matches the corresponding date on the balance sheet, a particular cell on the balance sheet is populated by the payment amount on the invoicing sheet. Bear in mind that the invoice sheet doesn’t have a rolling date column – just the date that I manually input, so the cells won’t be in a constant place.
Cheers