Generate pdf for each pivot report filter with name

[mhaziq]

Dear all

I need help. I have a pivot table which generates customer statements. I have 125 customers.
what I do every month is I manually select each customer in report and save file as pdf and name it whatever name is in report filter (obviously the customer i selected)
Now I know this can be easily done through macro (VB) if only I knew any programing
Now I turn to you guys for help in creating this VB macro so my life could be easier.

Plz plz plz help me out.

P. S. I am using office 365

Regards
Mohammed Haziq