Printing

[Naz]

Hello,

I have a workbook, that has several sheets in it. I need to greate a report
that consists of the different worksheets. I want to be able to click a
button and then have the relevent worksheets printed in the correct order,
and with page numbers that run across all the worksheets, and a table of
contents.
At the moment what I do is every month I paste into word as a picture the
pages i want, and let it create page numbers and table of contents. But is a
pain. Is there a way to do this in Excel, or an add-in? I use Excel XP.

 

[Dave Peterson]

If you group the sheets you want and have the headers include the page
numbering, then print, doesn't it come out ok?

If you need a macro, then record one when you select the sheets, and do the
print, and ungroup those sheets.