Auto-filling calendar from a list

Wow! That's an old one of mine. I've updated it to give you more recent years in the drop-down (K4 in the Calendar sheet), and I've included your sample data in the Activities sheet.

Hope this helps.

Pete

Is there an easy way to enter additional columns of data? I am looking at building an event forecasting tool for a catering operation and beyond just capturing the date and the title I want to include the guest count, location, and time

You shouldn't really ask questions in someone else's thread (known as "hijacking") - instead you should start a new thread of your own, with a link back to this one if you think it is relevant.

That being said, however, you should search the forum for threads of mine with "calendar" in the title, as I have submitted several files over the years with different requirements from other posters, and you may find one that fits the bill more than this one (which is based on the first one I submitted several years ago).

Hope this helps.

Pete

My apologies. I'm new to this and created an account just to explore these templates. I didn't mean any offense and appreciate your reply.