Printing Multiple Copies of Just One Tab of a Worksheet

**AZNDrumsKazuki** · 06-04-2013, 01:12 PM

Hey all!

It's been a while since I needed to ask a question on here (I'm getting better!), but I have run into yet another wall...

I have a workbook with multiple tabs... I would like to print the entire workbook with one copy per tab EXCEPT FOR one tab, which I need to make multiple copies of in order to hand out to my coworkers... Let's say 3 copies...

HOW DO I DO THIS?

Thanks in advance to all who view and reply... ^_^

-AZNdrumsKazuki

**young_86** · 06-04-2013, 03:30 PM

hi,
well maybe try print whole workbook in one copy, and then select tab you want to print in 3 copies, go to file menu, click print. And then under print what, click selection, choose how many copies and ok.

i hope its work.
have a nice day

**AZNDrumsKazuki** · 06-04-2013, 03:43 PM

Well, yes, that's the manual way of doing it, but I need it to be automatic... I print these new reports out but the 100s every day and it would be nice to be able to have it print out 3 copies of one tab automatically...

**young_86** · 06-04-2013, 03:53 PM

oh, ok. im not very good in macros, but i think you can try record it or try with new topic in section vba/macros. i'm sure somone will help. good luck
sorry for my previous post