Insert row below when cell contents change to specific text or value

[AmishTech]

I'd really appreciate some help to come up with VBA code that does the following:

I have an excel table named "RegisterTable" to keep track of financial transactions.
Headings are in row 6 and data in columns B:N.

What I need is, code to insert 1 row below the active cell when Column G changes to "split".

For example:
G8 starts blank, but then is manually changed to "split".
The code should insert 1 row below row 8.

I tried different things, but I still don't understand coding well enough to put it all together.
Here is my latest attempt.

Please Login or Register  to view this content.

Thank you in advance!