Hi

I have one spreadsheet. It has three views based on a macro changing the filter. What I want to do is print out multiple copies of these three views in order.

So what I would do at the moment is change the filter refresh the data and print it out. Do the same for the second view and the same for the third and then repeat the process again according to how many copies i need.

I am wondering if there is an easier way to do this as it is slow. Can you save each view in memory somehow and just use some VBA to make the printer do the work?