VBA / Excel - inserting rows between each of several hundred rows
Posted on 2013-11-26
In column A I have several hundred rows of data. I want create 2 copies of each row and insert it under the original row. EG I want to insert 2 copies of row 2 just below row 2, causing what is currently row 3 to move to row 5. I then want to repeat this for what is now row 5, and repeat until all the orignal rows have 2 copies beneath their original row,
Then in column B, against each set of idential items in column A I want to put text string 1 against the first, text string 2 against the second and text string 3 against the 3rd. EG after completing the procedure cells B2:B4 will contain respectively text string1 - text string 3.
I am sure this can be done in VBA but I am still a total novice with VBA so would appreciate some help.