Print Break after each name

[leanne2011]

Hi

I was helped with the code below - but it filters then individually sends the pages to the printer. How can I just add a page break after each processor change and be able to at any point manually press print and it will print the excel sheets out on 1 page for each processor. So if there was 10 processors there would be 10 printed sheets ?

I attach sample data too

Many thanks

Please Login or Register  to view this content.

[leanne2011]

can anyone help please?

[jaslake]

Hi Leanne

Try this

Please Login or Register  to view this content.

[leanne2011]

absolutely spot on - sincere thanks !!!!

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.