I am trying to figure the best way to allow a user to input data into Excel and then have the data inserted as rows into a worksheet.

I am using lists/drop down menus for the data that is selected by the user.

Is there a recommended best practice?

Thank you