| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
| How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
| change page number watermark in page break preview | Excel Discussion (Misc queries) | |||
| change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Threaded Mode
