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?