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