Macro to move Headers to the next print Page.

[awagenhurst]

The website that generates my list seperates my items by every 27 items then it prints the header on every page. i already have a macro that makes everything fit the page and ever 50 rows prints another page. so what i'm trying to do is run a macro that looks at column A for the header then it looks at the cell below it and if it matches delete the header and the space so it'll print more than 27 itmes. but if the cell below the header doesnt match the previous header itll cut every row and paste to the next page. I'll attach 4 excel sheets to show what I'm talking about.

Stage 1 is how i get the sheet from the website.

Stage 2 is when I run my macro to make sure it fits.

Stage 3 is what I'm looking for to put ever header onto the next print page, in print preview its 33 pages,

Stage 4 is where the macro would look at the cell below the header and see if it matches the above header if not does nothing, if it does match it'll delete the header, cut/paste to the above. this way it'll only print 23 pages.

[awagenhurst]

Ok i just finishe stage 3 if you have a better way of doing it then PLEASE let me know but as for me on to stage 4

[awagenhurst]

OK so i just finished all the stages it does wat i need it to do so im happy and brain fried.