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 2000 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=554566

Please post back and insert commas and periods where appropriate. As
written, what you wrote is nonsensical and cannot be understood. HTH Otto
"b166er" wrote in
message ...

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 2000 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=554566

Insert a column to the left. In that column (A) number the 1st 5 rows 1 thru 5. In cell A6 enter the formula =A1+6 then copy this formula down to the end of your data. On your first blank row enter 6 on the next row enter =A6001+6 and copy that down 2000 rows. Copy paste special the values in the column then sort based on the numbers in column A and you will have a blank row every 6th row.