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
Bookmarks