Macro for Inserting Pre-Populated Rows

[Origina1Penguin]

How do I create a macro that generates a new row with pre-populated formulas in each cell?


I actually only need to populate cloumns A through C in the new row(s). I'll need multiple macros as well, so the line where the row(s) are inserted will move if one or more rows had been inserted already. This is basically a form with questions being answered by the user, and I want some of the questions to generate a follow-up question if not left blank. The follow-up question will be inserted immediately below the trigger question with set text in column A, column B is blank (this is where questions are answered in the whole form), and column C displays a concatenation.

I'm really new to macros, but any help in the right direction will be greatly appreciated.

 

[mole999]

START MACRO RECORDER
insert a row where you need it, enter the formulas logically, left to right
stop macro recorder
copy the macro
paste here between code tags
and explain what you need to be done,
new line at always the same location? etc