I need to open a new worksheet for a new year. (The year starts July
1st)

I have copied the previous year worksheet to a blank worksheet in
order to keep the formatting and formulae.

How do I copy the page setup for printing?

Thanks,

Robin Chapple