Add new row with VBA two lines above subtotal when I fill in the last row

This is probably an easy one..but I'm having troubles.

Sheet1 I have the following:

R11 | Col_C | Col_K & Col_L merged
--------------------------------
R12 | Description | Price
--------------------------------
R13 | Description | Price
--------------------------------
R14 | Description | Price
--------------------------------
R15 | |
--------------------------------
R16 | |
--------------------------------
| SubTotal (L17)
-------------------------------

I'm trying to keep R16 empty. I would like it so when I finish entering data in R15 (could even make it so when R15/Col_KL has data) it automatically adds a new row (keeping the formatting of R15 (R16 has a thick border on the bottom that I don't want on the row above it))

I have the following that works if I click a button/macro but I'd like it done automatically when I get to the 2nd last row:

Please Login or Register  to view this content.