| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need macro to page break between company names automatically
I have one report with multiple company names and clients listed with totals
and I need the report to page after each company when printing. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need macro to page break between company names automatically
Check out on the menu, Data Subtotal...at each change in..
CompanyName; Sum DollarField; check Page Breaks between Groups HTH "Ms Magers" wrote: I have one report with multiple company names and clients listed with totals and I need the report to page after each company when printing. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need macro to page break between company names automatically
Thanks, that is a step in the right direction only now I am getting a page
with my lists and then a separate page with sub totals. I wish you could sub total to get the page break without really adding a sub total. "Jim May" wrote: Check out on the menu, Data Subtotal...at each change in.. CompanyName; Sum DollarField; check Page Breaks between Groups HTH "Ms Magers" wrote: I have one report with multiple company names and clients listed with totals and I need the report to page after each company when printing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert page break automatically? | Excel Discussion (Misc queries) | |||
| Page Break Preview Automatically Adjusting | Excel Discussion (Misc queries) | |||
| automatically enter a page break | Excel Worksheet Functions | |||
| automatically insert row at each page break | Excel Worksheet Functions | |||
| automatically put in page break after 14 lines. | Excel Programming | |||
Linear Mode
