Excel "Form" Input to Protected Data Sheet

I'm aware of Microsoft forms and pushing data to excel via Office 365. I'm aware of the internal "Excel Form"

I do not like using the internal excel form. Microsoft forms is nice but web based. Before I spend a lot of time there, I was curious if anyone had a recommendation or an example for the following. (This is a single user application.)

1. Data entered using form. Data is transferred to excel sheet that is protected to prevent editing.
2. The form can be searched/found and "Modified", updating the data set row in excel.


Backstory, The data entered into excel is 30 cell's per data set minimum. Data entered will be 10 - 30 data sets per session. During testing and setup I found it very easy to lose track and focus because my mind works in columns (Top to bottom). So the idea of the form is really just an visual aid for entering data.

Thank you.

You can build a custom UserForm to do all of this. It requires a little bit of VBA to make it function but is far more flexible than the built in forms that Excel has.

Attach a sample workbook and a little more info around what you want it to do and I'll gladly help you along the way with it.

BSB