Hi there, I hope someone can help.
I have a spreadsheet where on worksheet 1: I document all events invoices in Excel. This includes the date the invoice is submitted for payment, the date the event takes place on, the cost centre it relates to, the P&L Ledger code, the supplier and the cost.
On worksheet 2: I have a calendar from Jan to Dec in individual columns. I need to be able to be able plot the events that are listed in worksheet 1 over the entire year under the respective month (based on the date the event takes place).
Can this be done by formula?
WORKSHEET 1:
<tbody>
</tbody>
WORKSHEET 2:
<tbody>
</tbody>
Thanks in advance.
I have a spreadsheet where on worksheet 1: I document all events invoices in Excel. This includes the date the invoice is submitted for payment, the date the event takes place on, the cost centre it relates to, the P&L Ledger code, the supplier and the cost.
On worksheet 2: I have a calendar from Jan to Dec in individual columns. I need to be able to be able plot the events that are listed in worksheet 1 over the entire year under the respective month (based on the date the event takes place).
Can this be done by formula?
WORKSHEET 1:
INV DATE | EVENT DATE | COST CENTRE | GL CODE | EVENT | COST |
5 May | 1 Sep | 1000 | 1234 | Spring Fayre | £1000 |
1 June | 14 Dec | 2000 | 1234 | Christmas event | £2000 |
1 Aug | 15 Sep | 1000 | 1234 | Summer event | £1500 |
<tbody>
</tbody>
WORKSHEET 2:
COST CENTRE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |
1000 | 1 Sep Spring Fayre 15 Sep Summer event | |||||||||||
2000 | 14 Dec Christmas event |
<tbody>
</tbody>
Thanks in advance.