I have a large sales data report containing several groups of customers. I would like to automatically generate individual usagereports (separate files so not by tab) for each group every month and save themon a shared drive. I would like to alsohave each report automatically be customized with different headers (based oncustomers request); however, I could evade this if it is not possible.
Here is an example of my sales data. The group name column is what I would like touse to generate the reports. Is there amacro or method to do this? I know that Ican achieve this process by creating a pivot table, and then splitting out thedata by group into different tabs, but I would like to customize each report (ifpossible) and produce individual reports to save it in different folders.
|Customer ID||Item ID||Document Date ID||Accounting Year DESC||Calendar Month DESC||Calendar Year ID||Qty Sold||Price Paid Each||Sales||Group Name|
|209103997||075704259||8/12/2019||Fiscal 2020||August 2019||2019||1||$ 36.00||$ 36.00||ABC|
|209103998||UN5758511||8/12/2019||Fiscal 2020||August 2019||2019||0||$ 1.52||$ 1.52||DEF|
|209103999||UN5758529||8/12/2019||Fiscal 2020||August 2019||2019||0||$ 1.76||$ 1.76||GHI|
|209104289||075704259||8/12/2019||Fiscal 2020||August 2019||2019||1||$ 36.00||$ 36.00||JKL|