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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
pivot table- macro to create multiple reports?
- Thread starter abrown
- Start date
Excel Facts
What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Similar threads
- Replies
- 4
- Views
- 174
- Question
- Replies
- 1
- Views
- 464
- Replies
- 3
- Views
- 196
- Replies
- 2
- Views
- 192
- Question
- Replies
- 1
- Views
- 329
