Batch Inserting Row Sheets in between page breaks

Basically what I'm trying to do is this.



I want to insert a page break after every different occurence in a column. For instance, say column B has data as follows.



1

1

2

2

3

3



I would like to insert a page break after each occurance of a different number as follows.



1

1

-

2

2

-

3

3



Then what I would like to do is batch insert row sheets so that between every page break is a number of cells divisible by 8 for printing reasons. So what it would look like is this



1

1

blank

blank

blank

blank

blank

blank

-

2

2

blank

blank

blank

blank

blank

blank

-

3

3

blank

blank

blank

blank

blank

blank



If you could help me somehow batch ANY of this process, I would really appreciate it. This job is rather tedious done by hand so this would really save me some time.



Thanks!

Hi

This assumes that your data starts in A2, with either a blank cell in A1, or a header that is different from the A2 value.

Please Login or Register  to view this content.

Hope that gets you going.

rylo

thank you so much for your reply! this will greatly help.

I'm having a few problems though (i'm such a noob at this sort of thing so I apologize in advance), hopefully you can give me a little more help to get me going on this.

all of my data resides in column B and starts at B2 leaving B1 for a header.

and the other problem I have is, I uhm... don't know how to run this code in excel 2007 haha. So i would really appreciate any help you can lend :D

thanks in advance!

Hi

Attach an example workbook with your current structure and some dummy data that matches your format. That way the code can be revised to suit your actual situation.


rylo