Need VBA code to insert new row based on drop-down cell text

[powerpivotlegal]

Hello Excel wizards. I need a multi-faceted vba code that automatically runs when a drop-down text option is selected. I need the VBA to change the drop-down text to another text option in the original row and then add another row and pre-populate the drop-down cell text in that new row.

For example, if a user selects the drop-down option "Contribution - Shares of Opco" in Column C ("Transactions"), I want the code to change the drop-down selection to "Contribution" and then add a row immediately below that in the table and automatically select the drop-down option "Share Transfer of Opco" in Column C for the user. The drop-down selections are linked to lookup tables that pull in prices and people are always forgetting that "Contribution - Shares of Opco" involves 2 separate transactions and 2 separate prices.