With programming, you can create an Excel UserForm, to use for data entry.
Click a button, and the data is stored on a hidden worksheet, and the form is cleared out, so you can start a new entry.
This video shows how to add the textboxes, where the data will be entered in the UserForm.
Visit this page to see the entire series of videos - How to Build an Excel UserForm with Text Boxes for Data Entry.
https://www.contextures.com/exceluser...