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.
Bookmarks