Print data from two worksheets onto one page

[jlwalker63]

Hi. I have a file with data on two separate worksheets. They need to stay on separate worksheets. But I need to print both worksheets on a single page, without scaling either. They're not large, they will both fit onto a single sheet without scaling.


I did an internet search, my friend did an internet search and while we found things similar, we couldn't find anything specifically addressing this issue. Neither of us know VBA.

Does anyone know how to do this?


Jennifer

 

[Gerald Higgins]

I can't think of way to do exactly that, but how about creating a third worksheet, which duplicates both worksheets, and you then print that third worksheet, not the other two ?

 

[jlwalker63]

That's what I was trying to avoid. Thanks though.