Rows Insertion
 

hi members
how can I insert rows after every fiftth row I have data of more than
6000 rows that means I want to insert 1200 rows in that sequence


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=554552

Rows Insertion
 

I am assuming your date starts on cell in cell A1 in what follows.

Insert a new column to the left of all your data, so your data now
starts in cell B1.

In cell A1, enter this formula
=1+ROW()-ROW($A$1)+ROUNDDOWN((ROW()-ROW($A$1))/5,0)
and copy it down to the bottom row of your data. Make a note of the
largest number that this formula returns in column A.

Working down the column, this formula will generate 5 consecutive
integers, then a gap, then the next 5 consecutive intergers, then a
gap, etc.

In the cell in column A directly below this last row, enter a 6. In
the cell below, enter a 12, fill this series down until until the value
in the series is the multiple of 6 that is just less than the number I
asked you to note above.

Now select all your data, but continue your range below to include all
the extra numbers in column A we created.

Now select the range starting in cell A1, right to the end of your
data, and down to the last entry we created in column A, and sort by
column A.

You should now have a blank row (multiple of 6 in column A) after every
5 rows.

You can now delete column A.


--
RonnieD
------------------------------------------------------------------------
RonnieD's Profile: http://www.excelforum.com/member.php...o&userid=35736
View this thread: http://www.excelforum.com/showthread...hreadid=554552

Rows Insertion
 

Before doing the sort on column A, copy column A, and post it back on
column A "as values".


--
RonnieD
------------------------------------------------------------------------
RonnieD's Profile: http://www.excelforum.com/member.php...o&userid=35736
View this thread: http://www.excelforum.com/showthread...hreadid=554552

Rows Insertion
 

Is there an easy way to convert this solution to insert 25 blank rows
after every 1 row of data?

~Courtney


--
CAToso
------------------------------------------------------------------------
CAToso's Profile: http://www.excelforum.com/member.php...o&userid=15069
View this thread: http://www.excelforum.com/showthread...hreadid=554552