My problem is I want to run a macro event every time user tries to insert a new row. Also, I want to know the row number for newly inserted row so that data from another can be copied to one of newly inserted row's cell.

Please assist me to implement this functionality. Any pointers/links are highly appreciated.