Large Pivot Table Printing

Hey guys, long time no post.

I receive a report every month from a client. In this report, I get information via pivot table and have to manually go through and click on the account number, click print, click the next account number, click print etc etc. This process alone takes an average of two hours out of my day.

Is there a macro that could be run to automate this task and just loop until it reaches the last account number?

I attached screen shots to possibly help.

Thanks in advance!

The beginning of the month is coming up and I could really use some help..

I tried searching through previous threads and couldn't find a similar one..

Any help would be hugely appreciated.

I attempted a loop function that was on the Tips section, but have no idea what I'm doing...

Someone please helpp??

Hi pcargila,

It is time to learn to code!!

You need to record a macro that does a filter and print (or two). Then you need to look at the VBA code and clean it up so it loops through all your printings.

I've attached two files (one in .xlsm and another in .xls) that are examples.

In your problem you will want to find the List that drops down of account numbers and use those cells for your loop.

Without your file it would be hard to give you the exact cells and process. I hope you can learn from the attached example.