looping and subtotals to AutoFilter macro

[tony0710]

Firstly thanks to Ron for his macro - it helped me alot!!

Ron's macro: http://www.rondebruin.nl/copy5.htm

Using: "Create a new sheet for one unique value(AutoFilter)" - has helped me alot.

I now need to to modify the above macro to include:

1. Loop - so that I can autofilter all the months of the year into separate new sheets.

2. Totals - of each column to be calculated in each sheet.

So is this possible? I want to run the macro above and obtain 12 new sheets that would be named as the months of the year, and each sheet to have the totals of the cell content of each column calculated.

I am a complete newbie to this all, so any help will be much appreciated.

Tony

My code - modified version to my needs:

Please Login or Register  to view this content.

[royUK]

Why not use a PivotTable? Pivottables IMO are much more professional looking & efficient for reporting, also it saves unnecessary shets of data to wade through.

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

[tony0710]

Thanks Roy, in a way I do agree with you - but for my accountants needs, I need to do it this way AND then organise a pivot table later.

So it would be great if someone could come up with a solution for my original post.

BTW thanks for the link - it's helped me to understand pivot tables more