I have a worksheet that in column "S" I have written a simple equation that checks column "R" to see if a value is repeated. When it comes to an instance where the cell in column "R" does not repeat, it inputs "Insert Page Break" in the affected cell in column "S".
Is there a way to automatically insert a page break at the cell that "Insert Page Break" occurs and continue down the worksheet until it finds the same instruction again?
You can see an example attached.
Chris Nelson
Bookmarks