Hello and many thanks for your help
I have a User form (sorry if that is the incorrect term) that adds a new event to a table and the cost details to another table in a different worksheet.
Attached is the spreadsheet template I used for the table and calendar without the Add New Event button. My current button allows the user to add a New Event to the EVENTS tab table by Inputting the Event Name, Hosted By, Recurrence, Description, and the Projected Cost of the Event. It also adds the Cost Details for the event and allows them to add multiple items. My issue is with the Date and Recurrence. I need to be able to allow the user to add the date of the event. However, everywhere I look online, it says to add the date picker. I do not have access to add the date picker. Is there another way to do this?
Also, I need to be able to add the date multiple times depending on the recurrence. For example, I have a date that occurs Monthly, I want the event to come up monthly. Is this possible?
Lastly, on the budget tab, I want the recurrence to also allow me to calculate the projected cost and the actual cost per month and year. For example, if the event occurs monthly, I want the cost per month and cost per year to reflect that.
Your help and suggestions are greatly appreciated!
Bookmarks