Insert and Copy to Multiple Sheets from a Master Sheet

Hello,

I am new to VBA code and have a perplexing (for me at least) issue related to inserting and copying a row to multiple sheets (one is actually a column). Inversely I will also need a similar action when deleting a record.

To give some context, in the attached workbook I have three main sheets – DRIVER, PEOPLE and MEASURES. There is a fourth sheet that should be unaffected by any insertion or deletions.

The Goal: As I enter a new service (i.e. insert a new row and populate the service field (Range A2 through A*) on the DRIVER sheet I would like this action (likely via Macro) to:

1. Insert a column at the appropriate position in the PEOPLE sheet and label it the same.
2. Insert a row at the appropriate position in the MEASURES sheet and label it the same.
3. When inserting the new column or row any formulas should be carried over.

The attached workbook has an example of what I would like to do.

Lastly, if I delete a row from my DRIVERS sheet - Say Service 2, I would like this to also remove the appropriate column from the PEOPLE sheet and appropriate row from the MEASURES sheet with all formulas staying intact.

Thanks in advance for any insight.