Learn How To Create this AMAZING Meeting Scheduler in Excel [Part 1]

In this week’s training, I will show you how to create a powerful Meeting Scheduler.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 - Introduction
0:42 - Overview
10:13 - Conditional Formatting
15:39 - Before Double Click
18:33 - Change Event
24:27 - Deactivate Worksheet
24:58 - Selection Change Event
33:54 - Month Selection
40:26 - Load Meeting
1:03:38 - New Meeting
1:04:39 - Delete Meeting
1:09:18 - Save and Update Meeting
1:20:35 - Add Attachment
1:21:34 - Load Month
1:33:52 - Previous and Next Month Schedule

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #meetingcheduler #meetingschedulerinexcel #excelvba

[Alufakwa]

At this point I think I only need excel in life. Thank you!

[tonyblack]

As always, undeniably exceptional value delivered again Randy. AMAZING will be an understatement... Thanks for continually saving SMEs potential costs for premium tools like these.

[rccjr]

THANK YOU RANDY AUSTIN for sharing your knowledge. (Sir, could make records logbook soon..thanks)

[ronrainey]

Great Video and great options for many additions - How would we change the meeting Date to a multiple dates ( date for more than one day) Thanks

[bikakigo]

could you make a video about reservations with a calendar and customer cards for booking.

[verolero]

This is awesome. I can totally use this for our internal meetings. I'm a venue coordinator and was wondering if you had a video on creating an annual calendar that I can share or have live with my colleagues so they can see an update of dates available for the venues rented out, I know there's Google calendar, but wanted to see if you have made a video of that sort where the annual calendar as I get renters for the venues I'm booking for; on this database I'd have the type of banquet hall, what date and their contact info. Also some can be tentative dates and some may have paid a deposit? Or not etc. There can be many moving parts to this too, I have begun creating a database of paid renters and potential renters to follow-up on. I'd hope you have a video on something for my line of work... as renters come and go... or something similar? This video really gave me some great insight as to what direction to go. Thanks so much for what you do. You are such a great help!

[angelagreen]

This exactly what I need, can this be done in google sheets?

[girlofephemeras]

Hello Randy! Thank you for this tutorial. Is it possible to have same date, same time to be booked for 2 different person and the meeting agenda are for two different reason?

[nhungphale]

Is possible if I add a column called Location next to the Staff name column?

[jemuelpanelo]

I like this video. I want to convert this one to a hotel scheduler... just want to change some editing like if the stayed for 3 days.. do you a have a video on that or can you make one?

[tasnimsultana]

Hi, what’s the function called when you click next month it gives a new data entry sheet for new month?
And how to do it?

[DipsyDoodleDaisy]

Hi Randy.

I have received a confirmation that the download was sent to my inbox however, it is not on my inbox or junk.

I’ve repeated the steps 3 times. Any tips?

Thank you. ❤

[imtiaztyebally]

Very nice scheduler. I have one question on how do you determine the row and column number for a particular date on the first sheet Column AA:AC. I don't see any formula in column AB and AC. Is this being done through a macro?

[ajitsingh]

Hi Randy, very impressed with the video, even i am facing the same problem of data not showing once i change the month, i had formatted all date cell's with dd/mmm/yyyy and even added "Sheet6.Range("AC2").Value = ">=" & Application.WorksheetFunction.Text(.Range("B8").Value, "mm/dd/yyyy")" code in LoadMonth Sub. Now monthwise filter is working on sheet6, but still Schedule Meeting is not showing anything.

[Mike]

Love your work, and have learnt so much. but with this workbook, I'm finding that the advanced filter in the "loadMonth" sub does not work as expected, just leaves the "CopyToRange" blank. Any ideas?

[ajittrainingpeaks]

How does meeting IDs get entered in meeting schedule sheet in column bb6 to bh40.

[darrell]

Can't get the actual calendar days to update correctly. I've spent hours looking at my formulas making sure they are correct. They are the same as yours and in the same exact cells as yours. For example, Jan 1, 2021 is actually on the first Friday of the month. On my calendar It's on the first Tuesday. =(

[Squidable]

How would I expand a meeting for a week or over a weekend?

[sherreh]

Can this calendar get meeting rooms added?

[kvbesprit]

Hi Randy. I love this spreadsheet, it saves me so much time and work scheduling the training I deliver. However, I cannot get the automated email to work. I just get an error saying 'We need to know who to send this to. Make sure you enter at least one name. Plea, please can you help me.