print 1 paper from 2 sheets

  • Thread starter Thread starter Eric Tiethoff
  • Start date Start date
E

Eric Tiethoff

How can i print the range a1:m10 from sheet 1 AND a11:r10 from sheet 2 on
ONE piece of paper ? Anybody knows a solution ?
 
Create a new sheet.
Copy A1:M10 of Sheet1 to that new sheet
Copy A11:R10 of sheet 2 to that new sheet
Print from there.

If you have to do this lots of times, you can
select A1:M10
edit|copy
to the new sheet
shift-edit|paste picture link

And the same with A11:R10.

By using paste picture link, any change you make to those original ranges will
be reflected in the pictures.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

***Help on writing a vba code 12
Duplex printing 7
Copy Data from One sheet to Different Sheets 1
Excel VBA - Problem with Closing Print Preview 0
Printed image comes out small 1
Printing problem 5
Copying of non-consecutive, columnar data into consecutive-columnarcells 3
Need help formatting a sheet 0

Back
Top