Automatically inserting page breaks - Help

[djohnson]

I have a spreadsheet that varies in size each month. I need a way to automatically insert a page break above every line that starts with a date. How can I do this?

 

[Greg Truby]

Welcome to the board.

There are literally hundreds of thread here regarding "insert page breaks". Just do a search. Here is a recent thread on the topic.

http://www.mrexcel.com/forum/showthread.php?t=560975&highlight=insert+page+breaks

Explore the concepts you see in some other threads and then, after you've played a bit, let us know what solutions you've tried and where you're stuck.

A couple of other questions that will help members here help you:

• What version of Excel are you using?
• Do you have any experience with macros?

 

[djohnson]

I am using Excel 2010 and am not very experienced with Macros. Looking at other Macros and trying to make changes to fix my example is hard because I don't really know what I am looking at. Here is an example of what I am working with.

The line below shows up in multiple rows in column C with different page numbers. I would like to insert a page break above the line. The date changes every month.

<STYLE>body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Arial"; font-size: x-small; }</STYLE> <TABLE style="WIDTH: 380px; HEIGHT: 26px" border=0 rules=none cellSpacing=0 frame=void cols=1> <COLGROUP><COL width=167></COLGROUP> <TBODY> <TR> <TD height=22 width=167 align=left>07/01/11 SYSTEM FINANCIAL SUMMARY - DETAIL Page 129</TD> </TR> </TBODY></TABLE>