How to set worksheets to print in different order in the same file

T

Tamall

I want to group pages that are alpha order by dept without doing separate
files.
 
G

Gord Dibben

Hard to tell when you have used the term "worksheets" in the subject line
and "pages" in the body of your post.

Are those worksheets or printed pages?

You could sort the sheets by name then select the ones the ones to print.

See Chip Pearson's site for code to sort sheets.

http://www.cpearson.com/excel/sortws.aspx


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print order of TriFold - Publisher 365 0
Page numbering with Merged Document and IF statements 1
Merging from an Excel file with graphics 1
Consolidation Table from Different Excel Tabs with Different Format 1
Format column widths from one table to a separate table on same page 1
Embed the same Excel multiple times 0
Images are pixelated when saving to PDF 0
macOS Office365 Word 0

Top