Code that adds a row in a defined range in the same location as another sheet

[VentureSheets]

I have a data entry area that is a defined range ("Data_Entry_Defined_Range") on a sheet called Data Entry Sheet that allows users to input data which then feeds over to a separate sheet (Report Sheet) with a defined range called ("Report_Defined_Range").

The report sheet is used to provide a pre-built printer friendly report of the data entry information.

The problem I am having is that my users would like to able to add rows and information to the "Defined_Data_Entry_Range" on the Data Entry Sheet and have the added rows, formulas and information feed over to the Report Sheet automatically.

Is there some VBA coding that will automatically add a row on the Report Sheet & copy over the formulas/information in the exact same row location as the information added to the Data Entry Sheet?

Here's the basic syntax I'm looking for:

If a Row is Added to "Data_Entry_Defined_Range" on "Data Entry Sheet" Then

Add Row in exact same location in "Report_Defined_Range" on "Report Sheet" & copy formulas & information.

Please let me know if you have any questions or need further clarification.

I appreciate your time!

Thanks!