I have a pivot table with Salesperson as the Page Header. There are 10 salespeople. I want to create a macro that will create a seperate workbook for each salesperson and then copy-paste special-values to make it a static report. In the end I want to have 10 files one per salesperson. Is this possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
pivot table- macro to create multiple reports?
- Thread starter abrown
- Start date
Similar threads
- Question
