Insert a new row every 6th line with a defined value

[dawsonsoo]

Hi,
I have a spreadsheet with a bunch of rows with data starting in A1.
Every 6th row, I want to insert this URL http://fsm.babbleserver.com/wp-conte.../07/image1.jpg and what used to be in the 6th row will get scooted down to row 7.
Same for the 12th row with http://fsm.babbleserver.com/wp-conte.../07/image1.jpg and the data that used to be in row 12 gets pushed to 13...etc. all the way down to as far as I have data.

I posted in Excel general and someone said to try VBA - please advise, thank you!

~S

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick