Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Certain Cell Value and Print that Page Number
I have a Worksheet that is sorted by our Sales Peoples initials in Col. B. I
have code that Loops down Col. B and inserts a horizontal page break when there is a change in sales persons initials. For example; AA Page 1 AA Horizontal Page Break BB Page 2 BB Horizontal Page Break CC Page 3 CC Is there a way to select all rows with initials "AA" and then Print Selection? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Certain Cell Value and Print that Page Number
If your list has column labels on row 1, use Data|Filter|Autofilter to show
only rows for that Sales Person, then print it. Excel automatically prints only the currently displayed area of the worksheet. You really don't need to insert Horizontal Page Breaks in the worksheet, unless there will be times that you want to print the entire worksheet. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Pages by Page Number | Excel Programming | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
How do I print a new number on each page | Excel Worksheet Functions | |||
Print a number of rows per page | Excel Programming |