I am a financial analyst in a large corporation. I have a pivot table that shows each Sales Agent all the deals made by the sales agent, total amount of the deal and the commission to be paid to the sales agent.

Sales Agent 1
Deal 1 $400 $50
...
Deal n $200 $15
Sales Agen n
Deal 1 $2000 $100
...
Deal n $150 $15
etc...

I need a code that will select each name (Sales Agent 1), refesh the pivot table, save the report as PDF and email it to the correct sales agent.

I just do not know how to make it make the macro go the next sales agent name.

I can do the macro just by recoding the whole process, but there are 200 sales agents and it is not practical.

Also, I would like to have a macro that would do the same but instead of sending a pdf, it would create a new tab with the Sales Agent Name.

Help Please!!