Macro which picks out dates and the data relating to them

Hi,

I was wondering if someone could help me, I am new to Excel Macros.

At the moment all our work is logged by codes eg. A1Misc, B5Change, N9Important. As well as the codes, we enter the date in the column next to the code along with another Column to show the amount.

I need a Macro to look at the date column and only take dates which have Sept then go to the column next to it and pick up the codes individually and sum up all the amounts for the codes.

I have attached an example which shows from A13 downwards what I need the macro to show when finished.

As I mentioned I am very new to Macros, so if there is any details I have missed out please let me know and I will try to give as much information.

Thanks in advance for any help you can give.

You don't need a macro, use a PivotTable.

The dates column is grouped by Months.

If you learn to use PivotTables you will find them extremely useful. This might help

http://www.excel-it.com/pivot_tables.htm