Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing
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. -- _______________________ Naz, London |
#2
|
|||
|
|||
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. Naz wrote: 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. -- _______________________ Naz, London -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
Cell borders printing black instead of grey | Excel Discussion (Misc queries) | |||
problem printing to PDF | Excel Discussion (Misc queries) | |||
Illegal operation error while printing EXCEL or WORD Files | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |