To get you started take a look at this.
It will not solve your issue as it is, because you will need to modify it for your own needs, however the basic principles are there.
What we have above is a specified column and a set range or rows. The code will look through ever row and insert a new row between each in the range specified. After the row is created it will then change that value to the specified value (ie. "This is the new data").
In this code we are using a loop, which can be read up on here.
For quick little codes to see how excel works I would also recommend to try and record macros to see processes. Recording a macro will allow you to also learn new methods of doing things.
Bookmarks