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 -