How do you use a macro to add an extra line at bottom of excel table

[gillcork22]

Hello!

I am new. I have been teaching myself excel, just starting to use macros. I though I could get the macro to record my actions and then it would just repeat back what i had done (that i wouldnt have to write codes/formulas for everything?) I need to practice more...but for now, could i get help with this...

I'm giving my boss a hand. She needs to keep track of the dates each of her employees does specific training courses. I've set up the attached sheet. Problem is my boss would not be able to adapt any of this or *add rows* when she requires them, so i was hoping to make a button that could do that for her.

See attached. How can I create a macro that will add a new row and bring the formulas with it but leave column A, C, and D blank?