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

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.

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

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

~Courtney