You need to copy the data across to form one worksheet. But you can use links instead of copying
and pasting values, if you are going to be doing this a lot. Or you can print them and use your
copy machine to make one sheet ;-)

HTH,
Bernie
MS Excel MVP


"happygirl4everuk" wrote in message
...
I need to print two worksheets (set as portrait) on one landscape A4 page -
is this possible or do I need to copy the data across to form one worksheet?