Printing two tabs of the same worksheet to one double-sided page
 

I have a worksheet that is filled out by our various division. The workbook
has two tabs.

Right now, I have set it up so that each tab prints to fit one page. I go
to the first tab, print on one page, then go the the second tab, and print it
on one page.

Ideally, I would like to print these double-sided on the same piece of paper.

I would also like to figure out a way to automate this task (perhaps using
macros?). These are monthly reports which come in from over 30 divisions. It
takes a long time to do this manually, even with the macros I currently have.
[ I curently have a macro set-up which sets the page formatting to fit to
one page. I go to each tab and use the shortcut to this macro.]

I would appreciate help regarding how to print on the same piece, and if
possible, how to do this automatically.

Sicnerely,

Jennifer

Printing two tabs of the same worksheet to one double-sided page
 

Jennifer

Double sided printing is most likely to a setting on your printer.

You can go through all your sheets by wrapping your macro within a for
-next loop.


For Each Sheet in ActiveWorkbook
...
Your code
....
Next Sheet

Martin

http://homepage.ntlworld.com/martin.rice1/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532721