Re Post #19
The attached uses similar code to my last post, when you open your form and click on Monthly Sales a module test_grouping is called.
This module deletes a table then cycles through the records and adds the records to the table as per your requirement. You maybe able to use this tables to populate your worksheet or modify the code for your excel code.