insert rows and insert text in the cells in the inserted row

I am trying to improve my experience creating quizzes in a online gradebook course management software called D2L. This software has a CSV template for importing quizzes. The template has many types of questions, with specific rows and text for each question type. I only use three question types. I am fairly certain that if I can get started with a macro for one of the types, I can figure out the rest. The way I currently do this is when I want to add a question to the quiz, I copy the rows including two blank lines at the bottom from my template and then Insert Copied Cells where I want the question to appear. That works fine, but I know it can be faster.

I imagine my workflow will be to select the row where I want to insert these populated rows, and then run the macro.

This is a screen shot of the data in Excel.
6AD0513F-F71F-4378-998E-EAAEB72A8C22_4_5005_c.jpeg

This is the data in CSV form:

Please Login or Register  to view this content.

It might be useful if you could show us a before and after view. Not a lot of information to go on with work out the expected output.

BSB

Before there is nothing. After there is the text that I show in the screen shot.

If I imagine the way it could be done: I select a cell and run the macro. The macro inserts nine rows. It assigns the current cell the coordinate 0,0

Then it add the string "NewQuestion" into 0,0
It adds MC into 1,0
It adds QuestionText into 0,1
It adds "This is the question text for MC1" into 1,1
It adds Option into 0,2
It adds 0 into 1,2
It adds "This is the correct answer 1" into 2,2
It adds Option into 0,3
It adds 0 into 1,3
It adds "This is the correct answer 2" into 2,3

And just fills up the area with the exact text every time. Alteratively if the macro could load the clipboard with those values, it could just insert the rows and then paste.