Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Ultimate Calendar Template Update [Gold & Silver] (Patreon)

Published:
2023-09-25 12:15:01
Imported:
2026-06

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s Ultimate Calendar Template training.

Here's the update I made for this training:

· Recurring Calendar Items requested by Arivind

· Send To Outlook requested by Arivind

· Simplified Day Formula requested by Marcel Maatman

· Print Calendar requested by Earl

· Drag & Drop Items requested by Henk van der Work

· Month & Year Summaries requested by Lori Shafer

· Up To 10 Calendar Items added by Randy Austin

· Updated Time Formats added by Randy Austin

· Selected Item Color added by Randy Austin

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

Gime GG

Hi! I absolutely loved this update, thank you very much. I was wondering if it would be possible to add birthdays and icons and a message to let the user know when the item they are creating clashes with another one. Thank you!

Excel For Freelancers

Hi Gime, thanks so much. Its a nice idea and I will try to incorporate it the next time I create a scheduling update. However, please feel free to download the update and try to add this feature yourself. If you run into any issues, please post your bug in our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel Thanks again for your continued support, Randy

Excel For Freelancers

Hi Robert, thanks so much. Editing the series would be a great feature. I will try to add this into an upcoming training. Thanks a lot for your continued support

Henk van der Werk

Thanks Randy for these nice and well worked-out features! This is exactly why i always say I love Patreon :-)

Larry Duffie

Adding year in recurring would be good for holidays and birthdays and such. I am currently trying to add now.

Jazzy Fresh

Randy, if I wanted to use this template to sync multiple staff appointments from Excel to my Outlook calendar similar to how you did in: https://www.youtube.com/watch?v=3n-bzYQqJyE&list=PLIBeRriXvKzCzCthqGHlduBPobcaF6pn6&index=5, but using this Calendar template which does not list out the times as in the video link I attached, but instead uses the dropdown in M6 for times, how can I do this? Or can you direct me to a video that syncs it to Outlook in a similar way but using the dropdown cell for time instead of referring to times listed in a range of cells? I would have to change Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("M4:M40")) Is Nothing And Range("B2").Value = False Then On Error Resume Next If Range("M42").Value = Empty Then AddNewSheet DbCol = Range("M42").Value 'Database Column to address the dropdown, but I'm not sure how I would sum that.

Excel For Freelancers

Hi Jazzy, thanks for your comment. It would be difficult to offer a solution without seeing your code and your worksheet structure, along with the specific issue you are facing. Can you post all of the details, along with the code and your updated screenshots in our Excel For Freelancers Group so we can have a look and offer some advice? http://bit.ly/groupexcel I hope this helps and thanks so much.

John Stark

With the Print Function Couldn't you set the Parameters to make it set the background color and the Borders allowing it to print ( Print Preview)

Excel For Freelancers

Hi John, great to have you here. Cell background colors would print however the printer settings would not display the page/picture background that was used in this training as far as I know. I hope this helps and thanks so much.