Formula for expenses

[belpal01]

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:

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.