Hello All,

I have huge data of vendors on monthly basis in ms excel. I need to create vendor expense report from that data.

Right now I am creating pivot table for whole data and pulling (filter in pivot) each business vendor details and printing as PDF. There are 50 businesses so; I have to repeat this process for 50 times every week.

I am looking for a macro, which can filter the each business vendor’s data and print as a PDF file.

Can anyone give me advice on the same? I have little knowledge on Macro’s, but not able to frame the logic to write the macro.

Thanks for your help.
Regards,
Vishnu V