I need to get this spreadsheet to have a User form, like the excel data entry window, to pop up automatically when the sheet is selected. This would be used to enter new information based on the date selected, or edit the current data. This would be a new form every week. Monday thru Sunday.
• When new information is entered in the User form, it would put that data in the correct day. There can be as many as 10-15 per day. Some days would have less, so it would need to auto adjust to how many rows would be needed per day.
• If the main sheet could be locked so no one could add or change data without going to the user form.
• I would like 1 empty row between completed days
I hope this makes sense? Thank you for your time please let me know if more information is needed.