macro select value & insert new row in the last value to found

Hello Excel Forum Users!

Hello,
I'm trying to create a macro that takes the Select value in "A4:A" range & insert me a new row in the last value to found in "C9:C" range and if possible put me "S" in "E4:E" RANGE..
it's possible??

Attached is a workbook with a before and after example of what I'm trying to do.

Thanks again for all..

Best Regards!

Attached is a workbook with a before and after example of what I'm trying to do.

thanks.
feroguz