Hi, I have an Excel Spreadsheet that has the following columns
Part No - Quantity Rejected - Date Rejected - Supplier
1234 1 01/01/2012 Joes Hardware
2345 3 12/02/2012 Freds Spares
1378 5 19/03/2012 Rocky Spares


I want to write a function that will return a figure into another worksheet that has a column for each month and i want it to give the quantity Rejected by Supplier and by Month

Supplier JAN - FEB- MAR - APR
Joes Hardware 1
Freds Spares 3
Rocky Spares 5

Can anybody tell me if this is possible and give me some idea as to how to write the formula.. I am quite a newbie to Excel functions.

Sorry but the 1 should be under Jan, 3 under Feb and the 5 under Mar.

Regards
Thermalman