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.