#1
|
|||
|
|||
Pivot table auto print. For multiple values.
Hello. I am looking to the experts for some help. I have a pivot table that I have made into a call sheet for my sales team. It has all the names, numbers, and data side by side almost like a table. It currently shows all sales and the rep name next to each customer name.
What I would like to do is find a macro that will select each rep in the value filter and print an individual call sheet. Currently I have to select the filter>rep and press print for each one. Thank you in advance. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto Refresh Pivot Table on Timer | bremen22 | Excel | 2 | 10-01-2013 01:00 AM |
Pivot Table:delete zero values when using calculated objects | Serge 007 | Excel | 1 | 06-05-2013 11:47 AM |
Pivot Tables - Values divided by Subtotal | Loretti | Excel | 0 | 11-12-2012 02:15 PM |
How to auto add up the sum of monetary values? | mikehende | Excel | 6 | 10-13-2012 12:40 AM |
add values from different variables with pivot table | andrei | Excel | 2 | 01-19-2012 08:45 AM |