PC Review


Reply
Thread Tools Rate Thread

Batch Inserting Row Sheets in between page breaks

 
 
New Member
Join Date: Jul 2008
Posts: 1
 
      3rd Jul 2008
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting page breaks Rich Mogy Microsoft Excel Worksheet Functions 3 10th Apr 2009 11:26 PM
inserting page-breaks =?Utf-8?B?VERS?= Microsoft Excel Programming 4 13th Aug 2007 05:20 AM
Inserting page numbers with many section & page breaks? =?Utf-8?B?bGluZGE3Ng==?= Microsoft Word Document Management 1 1st Apr 2005 05:04 PM
Inserting Page Breaks =?Utf-8?B?RGFuIEdpbGVz?= Microsoft Excel Misc 2 21st Feb 2004 03:41 PM
Help inserting page breaks Mike F. Microsoft Excel Worksheet Functions 0 1st Jul 2003 08:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:21 PM.