60614_Excel
Board Regular
- Joined
- Jan 5, 2003
- Messages
- 55
Hi, I am working on some sales data which I need grouped by Sales Rep Name. I have a pivot table with it grouped by Name with the data being number of accounts, but now I want to take each reps data and split it into their own worksheet eg: pivot table contains Smith- 4 , Thompson- 10, Ward-20 etc. and I want to make a sheet for each of these people with their respective account responsibilities.
I know you can double click on the data totals number in the pivot table to break it into a new sheet but I have 40 reps, is there an easy way to split all of these into different sheets without clicking on each total 40 times and then also change the name of the tab to reflect the rep name from the pivot table?
thanks!
I know you can double click on the data totals number in the pivot table to break it into a new sheet but I have 40 reps, is there an easy way to split all of these into different sheets without clicking on each total 40 times and then also change the name of the tab to reflect the rep name from the pivot table?
thanks!