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 |