In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. Quattro Pro would
then put all the selections onto one page and print. Is there a way
to select data on several tabs in Excel 2007 and have them print on
one page?

Not only will Excel not allow range printing from multiple sheets, it won't
allow printing non-contiguous ranges on the same sheet.

Can you copy the range to print from each sheet to a new sheet?

Or copy all data from each sheet to a new sheet then hide rows and columns
you don't want to print?


Gord Dibben MS Excel MVP

On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote:

In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. Quattro Pro would
then put all the selections onto one page and print. Is there a way
to select data on several tabs in Excel 2007 and have them print on
one page?

That would be too much work to achieve the goal. We use tabs for each
month of a rent collection database. To follow one tenant and print a
monthly amount by selecting one line from each month is what we could
do in Quattro Pro. By the sound of it, this is not possible in Excel.


On Jul 28, 11:23*am, Gord Dibben <gorddibbATshawDOTca wrote:
Not only will Excel not allow range printing from multiple sheets, it won't
allow printing non-contiguous ranges on the same sheet.

Can you copy the range to print from each sheet to a new sheet?

Or copy all data from each sheet to a new sheet then hide rows and columns
you don't want to print?

Gord Dibben *MS Excel MVP



On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote:
In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. *Quattro Pro would
then put all the selections onto one page and print. *Is there a way
to select data on several tabs in Excel 2007 and have them print on
one page?- Hide quoted text -

- Show quoted text -

Not possible without using VBA to transfer the tenant's lines from each
sheet to a new sheet.

Have you thought of having all tenants and months on one sheet and using
autofilter?


Gord

On Tue, 28 Jul 2009 13:19:22 -0700 (PDT), dj wrote:

That would be too much work to achieve the goal. We use tabs for each
month of a rent collection database. To follow one tenant and print a
monthly amount by selecting one line from each month is what we could
do in Quattro Pro. By the sound of it, this is not possible in Excel.


On Jul 28, 11:23*am, Gord Dibben <gorddibbATshawDOTca wrote:
Not only will Excel not allow range printing from multiple sheets, it won't
allow printing non-contiguous ranges on the same sheet.

Can you copy the range to print from each sheet to a new sheet?

Or copy all data from each sheet to a new sheet then hide rows and columns
you don't want to print?

Gord Dibben *MS Excel MVP



On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote:
In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. *Quattro Pro would
then put all the selections onto one page and print. *Is there a way
to select data on several tabs in Excel 2007 and have them print on
one page?- Hide quoted text -

- Show quoted text -

On Jul 28, 1:58*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Not possible without using VBA to transfer the tenant's lines from each
sheet to a new sheet.

Have you thought of having all tenants and months on one sheet and using
autofilter?

Gord



On Tue, 28 Jul 2009 13:19:22 -0700 (PDT), dj wrote:
That would be too much work to achieve the goal. *We use tabs for each
month of a rent collection database. *To follow one tenant and print a
monthly amount by selecting one line from each month is what we could
do in Quattro Pro. *By the sound of it, this is not possible in Excel.

On Jul 28, 11:23*am, Gord Dibben <gorddibbATshawDOTca wrote:
Not only will Excel not allow range printing from multiple sheets, it won't
allow printing non-contiguous ranges on the same sheet.

Can you copy the range to print from each sheet to a new sheet?

Or copy all data from each sheet to a new sheet then hide rows and columns
you don't want to print?

Gord Dibben *MS Excel MVP

On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote:
In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. *Quattro Pro would
then put all the selections onto one page and print. *Is there a way
to select data on several tabs in Excel 2007 and have them print on
one page?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Thanks for the idea, but no, the month's by tab works well and the tab
already has numerous columns that must be tracked monthly. I guess I
just like 'the good 'ol days' with Quattro Pro. It seems Excel is a
little behind in this area. Oh well.

On Jul 28, 1:58*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Not possible without using VBA to transfer the tenant's lines from each
sheet to a new sheet.

Have you thought of having all tenants and months on one sheet and using
autofilter?

Gord



On Tue, 28 Jul 2009 13:19:22 -0700 (PDT), dj wrote:
That would be too much work to achieve the goal. *We use tabs for each
month of a rent collection database. *To follow one tenant and print a
monthly amount by selecting one line from each month is what we could
do in Quattro Pro. *By the sound of it, this is not possible in Excel.

On Jul 28, 11:23*am, Gord Dibben <gorddibbATshawDOTca wrote:
Not only will Excel not allow range printing from multiple sheets, it won't
allow printing non-contiguous ranges on the same sheet.

Can you copy the range to print from each sheet to a new sheet?

Or copy all data from each sheet to a new sheet then hide rows and columns
you don't want to print?

Gord Dibben *MS Excel MVP

On Tue, 28 Jul 2009 09:42:17 -0700 (PDT), dj wrote:
In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. *Quattro Pro would
then put all the selections onto one page and print. *Is there a way
to select data on several tabs in Excel 2007 and have them print on
one page?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Actually, you gave me a good idea. A summary sheet pulling all
relevant data for an annual month by month total. Might be a little
work to set up but may also have benefits down the road. Thanks again.

Sounds like a good idea.

Pursue it.


Gord

On Tue, 28 Jul 2009 17:24:52 -0700 (PDT), dj wrote:

Actually, you gave me a good idea. A summary sheet pulling all
relevant data for an annual month by month total. Might be a little
work to set up but may also have benefits down the road. Thanks again.