Link to home
Start Free TrialLog in
Avatar of david remichi
david remichiFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Am I able to print data from 1 excel sheet on 2 sides of a sheet

Hi

I have a excel workbook and im trying to print data from one worksheet onto 2 sides of a piece of paper.

I need cells A1-J72 printed on one side of the sheet and then it flip the page and cells K1-S63 printing on the other side.

Am I able to do this via macro?
ASKER CERTIFIED SOLUTION
Avatar of ☠ MASQ ☠
☠ MASQ ☠

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dear student: MASQ's answer will probably not earn an "A" until you improve it.

Why don't you follow his advice?  Post the results and we can critique them for you.

His advice was:
you can build either another to print page 2 or extend the existing script. 
Maybe you could use one subroutine and call it for each page?   Use your imagination and good luck in your studies..

Rberke (aka UncleBob)
Avatar of david remichi

ASKER

I can explain this the other one was done by my brother by mistake and I thought that I had deleted it by cancelling

​Sorry