Hi all,

I'm hoping to find a simple way to add page breaks in my template to the start of each day, to make it more printer friendly.

Originally, I had planned to use =IF(b1b2,"Page",1) command in column D to determine where I wanted the page breaks to be, then use Go to - Constants - Text, to add page breaks on each "Page" cell. However, I only get a page break in the first instance.


Day 1 1737 Data 1
Day 1 1752 Data 1
Day 1 1800 Data 1
Day 1 1827 Data 1
Day 1 1830 Data 1
Day 1 1930 Data 1
Day 1 2030 Data 1
Day 1 2230 Data 1
Day 1 2330 Data 1
Day 2 0000 Data Page
Day 2 0030 Data 1
Day 2 0100 Data 1
Day 2 0200 Data 1
Day 2 0230 Data 1
Day 2 0300 Data 1


I'm hoping someone here knows a simple way to accomplish this, preferably without resorting to VB scripting, as I am a VB noob.