Print 3 sheets on the same page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Revenger - 17 Jan 2006 12:21 GMT

Hi,
I have the following problem:
I have 3 worksheets with 5 rows of data on each worksheet. Now, I want to
print all three sheets on the same page (5 rows from the first sheet,
followed by 5 rows from the second sheet and finally 5 rows from the third
sheet).
Can anyone help me with this ?
Thanks !

Reply to this Message

Ken Wright - 19 Jan 2006 23:31 GMT

Why not just create a 4th sheet that links in each

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
of the three ranges to one block of data and then just print that. The
links will ensure that as you update sheets 1-3, then 4 will match.

> Hi,
> I have the following problem:
[quoted text clipped - 4 lines]
> Can anyone help me with this ?
> Thanks !

Reply to this Message

Ken Wright - 19 Jan 2006 23:50 GMT

Why not just create a 4th sheet that links in each of the three ranges to
one block of data and then just print that. The links will ensure that as
you update sheets 1-3, then 4 will match.

Regards
Ken.......................

Reply to this Message

Revenger - 20 Jan 2006 06:53 GMT

> Why not just create a 4th sheet that links in each of the three ranges to
> one block of data and then just print that. The links will ensure that as
> you update sheets 1-3, then 4 will match.

Yeah, thats one way to do it, but I downloaded an excel add-in "Print
selections" so the user can select what he wants and then print it out !
Thanks anyway !

Reply to this Message

Rate this thread: