how do I insert 4 rows in between each value in a list of data

[Callum]

I have a long list of data in a notebook.txt file.

I want to copy and paste it into excel, but leaving 4 empty rows in between
each value. i.e. a list of 10 values will now be 50 rows long (but with 40
spaces).

Can anyone help?

Thanks in advance

[John James]

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 for 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