Need a Macro to delete an entire row from one worksheet & create a new row with formula

Need a macro that when I delete a row from worksheet #1, it will delete the entire row in the the 2nd worksheet where the data is being reference from worksheet#1. Then create a new line at the bottom with the formula already embedded, so that when data is added from worksheet one it will populate. I found an example of a macro code that inserts a new line, but still need the deletion code to be added. Please can someone help me with this.

HTML Code: 

Have a look here:
http://stackoverflow.com/questions/7...-deleting-rows

Hello yudlugar, I am a newbie to VBA, and I am not sure how to implement that method as it was defined.



here is the file I am using can you help me please. Copy of US05 - MPTS_test version.xlsm

Hi - sorry, I don't have time to implement the full solution for you right now, I'll try and check back later in case nobody else is able to help.

@yudlugar, here is some code I found and used that deletes my lines. I just need to automate this function when the row is deleted from main page and add a new row with formula for the row deleted.

HTML Code: