INSERT PAGE BREAK WITH CRITERIA

[williekay]

I have a worksheet that list information by months. All January first, then Febuary, etc. I have a column that list the last entry of the month with TEXT(CELLDATE,"mmmmm"). So the last entry for Januray in this column list January. I was wondering if there was a way to loop through with something like, IF THERE'S SOMETHING IN THIS COLUMN GO TO THE NEXT ROW AND INSERT A PAGE BREAK ????

Willie

 

[SkipVought]

Hi,

Take a look at Data/Subtotal.

You can pagebreak on "on each change in..."

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}