The attached Excel code works great as designed.
But now, I will like to amend the code a bit such that the code will do the following after user types in the Begin and End Dates.
(1). User types in the Begin and End dates
(2). Code takes data and chunk it up by group of each Customer name
(3). Using the existing Excel template, place the data in one sheet truncated (per current code design)
based on the grouping of Customername described above. That is, each group of customer will
have each workbook of a single worksheet.
(4). When the code is done, each customer will have it's own file based on records in each group.
Current design:
In the current design.
(a). User must select a customer name from the combo then
(b). type in the Begin and End dates
(c). The code will create an excel file based on the selected customer name.
The difference between my new request and the current design is that user will no longer select a customer name from the combo. the code will loop to create excel file for each customer found in the query. I hope this is clearer.
I tried modifying the code as I understood it but it did not create excel files as expected. Please find attached my modified Excel code
Start Free Trial
