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.

Is there a simple formula for this? Please advise, thanks!
~S

[nathansav]

No real formula, i think, will be VBA