Sum each autofilter criteria and export to a new spreadsheet

[Hjahren]

Hi

Anyone who has a code on this?

I want to sum all the entries on each autofilter-criteria and export to a new spreadsheet in the same workbook.

Cheers.

[Hjahren]

Wrote into wrong thread but not able to delete message, so I wrote this text