I have an Excel workbook which has two sheets. The first sheet is
several pages long when printed and the second sheet is always one page
long. I want to print the second sheet on the reverse side of every
printed page.
For example:
Printed sheet 1 front = Excel sheet 1, page 1
Printed sheet 1 reverse = Excel sheet 2
Printed sheet 2 front = Excel sheet 1, page 2
Printed sheet 2 reverse = Excel sheet 2
Printed sheet 3 front = Excel sheet 1, page 3
Printed sheet 3 reverse = Excel sheet 2
.....etc etc
The printer I use is capable of duplex printing but I cannot figure out
how to print Excel sheet 2 on the reverse of every page. Does this need
a macro?
--
dziw
------------------------------------------------------------------------
dziw's Profile:
http://www.excelforum.com/member.php...o&userid=10422
View this thread:
http://www.excelforum.com/showthread...hreadid=562818