Printing Help

[shaunbuk]

My issue is as follows
I fill in fields on a worksheet called “Inputs”
From this sheet fields are automatically filled on a worksheet called “Curtains”
The worksheet “Curtains “ is essentially 2 different types of curtain top half of the worksheet being one and bottom half being another
When I print I get a A4 sheet with either the top or bottom filled in (as the worksheet looks)
What I want to do is to be able to print the top half or bottom half only but expanded to fill the A4 sheet
Any ideas please?

[dogberry]

Hi
Have you tried selecting what you want to print alter your printer settings for A4 and then use print selection rather than just print.

Chris

[shaunbuk]

Thanks for that

I am looking for a way so that it does it automatically for example if it know its a type A curtain it expands that section only without me doing anything except pressing print (I would like to macro it all and have the macro button on the input sheet so that I don't even go to that page)