Hi Callum,

No answer so I'll have a go.

Answer depends on how long the list is.

If not too long, then select Insert-Rows. Then press the F4 key to
repeat the task as necessary.

To automate it a bit more here's a macro which you can attach to a
shortcut key combination. (Gives one keystroke row each 4 row
insertion)

Sub Insert4Rows()
ActiveCell.Range("A1:A4").Select
Selection.EntireRow.Insert
ActiveCell.Offset(5, 0).Range("A1").Select
End Sub

But if you want a complete solution then post on the excel programming
group


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532268