View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dziw dziw is offline
external usenet poster
 
Posts: 1
Default Double sided print (same page on reverse)


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