Excel printing

[dj]

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?

 

[Gord Dibben]

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

 

[dj]

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.

 

[Gord Dibben]

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

 

[dj]

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






- 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.

 

[dj]

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






- 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.

 

[Gord Dibben]

Sounds like a good idea.

Pursue it.


Gord