View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Jack Christopher Jack is offline
external usenet poster
 
Posts: 5
Default Variable Page Break

Hello,

I have a table that has the date in column A. The start date is variable based on the value in O1. From there, the next cell is calculate from the one above. This goes on to A368.

A | ... | O |
1 DATE 10/1/2016
2 =O1
3 =A2+1
4 =A3+1
5 ...



A | ... | O |
1 DATE 10/1/2016
2 2016/10/01
3 2016/10/02
4 2016/10/03
5 ...

So, my question is: Is there a way to reset the page breaks auto-magickally so that it prints one month range per page, columns A through K? Also, to only print 12 months worth.

Thank you,
~~Chris