I made my calendar using the day and items as one string with vblf. I also used advanced filter to get monthly items. I added different fill colors for appts or events for my wife or myself. Birthday days get a picture of the celebrant in the lower left-hand corner. Navigation is very similar to yours. It hangs on the refrigerator door with magnets. I do love the way you created the days and colored them accordingly. Now, I get to merge the two. It gives this retired man something to occupy his mind. Thanks for all the tutorials that you give. You really are the best!
HI and thanks Robert. It seems you have created an outstanding calendar. Very well done. I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks @user-bp6dq7vi1u I show you how to do that in this training: th-cam.com/video/UwN_b0e3iKo/w-d-xo.html I hope this helps and thanks so much.
Can't wait Randy ! I venture to say that my excel career without your comprehensive trainings would be way TOO HARD. I still hope to learn a lot from you. Keep it up Mr AUSTIN.
Thanks so much, Keita, I really appreciate the continued support. This one is relatively simple (for you) and small, so that means that I can both design AND code this one from scratch, during the video, so I am excited to bring it to you. Thank you for your Likes, Shares and comments. It really helps.
Another awesome project. Thanks so much Randy. I made a few additions to my personal calendar. I split the tasks into 2 categories each with their own sub categories. I also added a couple dynamic fields to show pending or unfinished tasks. (FILTER is the best new formula!) Different colored boxes depending on their status. Also a button to send an email to the administrator responsible for QCing the task. This one is so much fun to use. I get ideas for additions almost every time I fire it up. You’re the man. Thank you for the content. Best on TH-cam by far.
This tutorial is incredible, thank you for sharing - it's sparked a whole new interest in Excel for me. I've been trying to figure out how to sort events that last all day, or don't have a specified start time. When I enter them as 00:00, the cell goes blank - and when I changed the data validation to "All day", Excel sorts this after the valid times (so All day items display below the items with actual start times, I want to show the All day items on top). Is there a way to do this? Thank you
Hi and thanks very much. Make sure that you add a 'Duration' column and field and set the length of that to something like 12 hours. You can then sort by date and duration (descending) so that Duration appears first. I have a vertical scheduler training that may help with this here: th-cam.com/video/alFVTxLhlk4/w-d-xo.html I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you Randy - that's really helpful. I'd like to be able to share the calendar via Sharepoint to allow users to collaborate on it. Is there a reason why they would not be able to enter new items? A debug error comes up but I can't tell where the issue is, as it works for me (as the original creator)
Great stuff. Is it possible to add resources (employee) for each course ? Need a calendar where I can schedule my courses and add freelance instructor for each courses. There could also be some action on each courses that need extra employee
Hi and thanks, Yes for sure this can be completely customized. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Great thanks so much. I will be creating this one from scratch, step by step, so you can learn how to create this yourself. Thank you for your Likes, Shares & Comments. It really helps.
Hi thank you so much for this video! I have a problem, so at 59:30 you said that we must run an advanced filter from A to F, right? But once I do that most of my items disappear. Then when I go back to coding and I type 'With ItemsDB.' I don't get anything. Could you please help me with it?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi, I thoroughly appreciate this video. However, I'm stuck at 1:23:19-Calendar Load. My "Calendar Item" Box at M is not loading any of the data from my selected calendar item although the data appears in the ItemDB sheet. Is there a way to have my code reviewed? Also, I reviewed the Video and still missing at what point the object CalItem was declared and type identified. Where is this done?
Hi Peggy, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. If you would like some one on one help, please email me the details and I can forward it to a qualified developer for a fair price (Randy@ExcelForFreelancers.com ) I hope this helps and thanks so much.
Fixed It! I changed the VBA code in Sub Calender_Refresh I changed this code: ItemTime = Format(.Range("P" & ResultRow).Value, "h:mm AM/PM") To :ItemTime = Format(.Range("P" & ResultRow).Value, "HH:mm") It is working perfertly well. Thank you Randy YOU ARE A BRIGHT STAR!!!
Hi, can you help me please!! i'm stuck at 39:17, i'm trying the formula, but it keeps saying that i entered too few arguments for this function, what am i doing wrong or is there anothere formula that i can use
Hi and thanks, if you have events that are multiple days you can use this type of a scheduler: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html I hope this helps and thanks so much.
Hi Randy, thanks for the wonderful tutorial, i followed step by step till the point where you tested the Calendar_refresh code, "compiler error: Invalid qualifier" poped up and i couldent figure it out, any thoughts on that?
Hi Waleed, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Good Morning. I am starting to set up my excel calendar, but I need help setting up the admin sheet within the work book. Which video should I watch that will walk me thru the process. Thanks,
Hi and thanks very much, each admin screen is different, slightly, in the School Manager series i have an admin in which i go step by step here: bit.ly/SchoolManagerSeries However if you have a specific question or specific issue, please post it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Thank you so very much, I really appreciate that and will add more customizations to new scheduling applications in the near future. Thanks again
ปีที่แล้ว +1
Thanks for this tutorial. Trying to figure out how to make it where an event has a start date and an end date, so I want it to display across multiple days. So, it’s almost what I need, but not fully there just yet,
Hi and thanks very much. You may want to check out my gantt task manager which has start and end days here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html I hope this helps and thanks so much.
HI and thanks. You can try merging and centering the cells for each day, then use the same formula I have used for the existing cells. I hope this helps and thanks so much.
Hi and thanks very much. I used a pop-up color picker (which is just a bunch of rectangular shapes put together) to be able to choose a color. I hope this helps and thanks so much.
Randy, Do you have any training videos I can look at that would help me add a second date to the calendar? I think I am going to use this to setup deliveries and pickups but I only want it shown on those days not the duration of the period. Thanks
HI Justin, thanks for your message. You could just add two cells in your calendar sheet with From and To dates. You can then link these two days with the criteria in the calendar items sheets, instead of the beginning and end of the month. Then make sure to run the calendar refresh macro on any change of these two cells. Make sure to watch the entire training video to help with this. I hope this helps and thanks so much.
HI and thanks yes that is certainly possible. I will try to add a similar feature in the future however you can see how its done here: wellsr.com/vba/2019/excel/vba-playsound-to-play-system-sounds-and-wav-files/ I hope this helps and thanks so much.
GREAT VIDEO! How do I show that an event runs for more than one day/timeframe? Duration is in minutes. I need it in "days". I want to use the calendar to show meetings that overlap. Thank you!
Hi and thanks so much. If you are looking for events that run over multiple days, you may want to check out my Task Manager video and template here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html I hope this helps and thanks so much.
This is absolutely amazing! I had no idea the capabilities of Excel such as this. If I may Ask, I am trying to use this to crate a calendar to track monthly budget items and bills rather than appointments, under the Calendar Items sheet, is there a formula or way of setting Calendar Item dates as recurring on a specific day of the week/month/or EOM? Happy to support your patreon for any tips or tricks on this usage of you calendar.
Hi and thanks so much. I did add 'Recurring Items' to this calendar in the Patreon update (Gold & Silver Members) here www.patreon.com/posts/ultimate-update-89800221 Also, if you sign up for Gold Annual I am offering all 140 workbook updates as a free bonus, so please keep that in mind. I hope this helps and thanks so much.
Randy, Thanks for these wonderful Excel workbooks and training. I am working on the Excel Calendar workbook I wanted to add addition items under the Calendar Items table. I am trying to make this into an Emergency Management Exercise Scheduler. The current Excel Calendar has Item Name; Item Date; Time; Duration; and Notes. I wanted to add 4 additional fields, Type of Exercise (dropdown), Facility Type, Category and Status. I have tried to expand of the current fields to include the additional fields, but I get an error, Runtime Error 1004 -the extract range has a missing or invalid field name. I have persed trough line by line in the editor but I am lost and can not see where I made the mistake. Any assistance would be appreciated. Thank You Dale
Hi and thanks very much. This issue has to do with an advanced filter, headers not matching or incorrect range. I have a training on Advanced Filters which will help you find and fix this issue here: th-cam.com/video/YuCrEWU2Tm0/w-d-xo.html I hope this helps and thanks so much.
Hi really great video and template. Is it possible to have different Calendar items colours? When I change the colour for a new item all the previous calendar items change aswell.
Hi and thanks, yes it is. I have a completed Calendar Pro version here you may like: rebrand.ly/CalendarPro_YTDesc I hope this helps and thanks so much.
@@ExcelForFreelancers Darn it tempting to purchase. But I have mac. Beside I prefer the style of your free download. Could I get this as a bespoke £ add on? Can contribute to your account.
Hi and thanks so much. I do have other calendars that may be more helpful to you here: th-cam.com/video/7f2zrZAMkko/w-d-xo.html This is a new multi-day version with multiple colors. I hope this helps and thanks so much.
Hi Randy! I've watched this and the task manager tutorial to make a calendar for a friend who still uses a paper agenda and it was really helpful. Especially considering I had never written a single line of code before. They're both excellent and I have almost finished it. I have one small issue. My friend is a teacher, and it would be amazing if she were to be able to schedule recurring events. I know you did something similar for the task manager, but I don’t think it worked with the following example: “Give classes to Laura” every three days for the next three months. I don’t know how to calculate the skip or the end date. I hope you can help with this. Thank you very much for your trainings! I really like them.
HI and thanks so much. I am really glad you liked the training. I have actually added the 'Recurring Events' feature onto the updated version for our Patreon members which will be out on Monday. www.patreon.com/ExcelForFreelancers IF you are not yet a member, it would be great to have you. Thank you for your Likes, Shares & Comments. It really helps.
Hello, Thank you for this amazing Calendar making video in detail, I am trying to make it however I am getting error of Shape method while running macro, can you please help me to resolve this.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
hello everyone, i try the calendar and is amazing i have a cleaning and construction company and for the cleaning i am using a daily route with appts for the week and my question is it is possible to change color of the appt? i want to put a color for the cleaning and a different color for the personal appts like a dr. appt. thank you
This is an amazing tool, thank you i am braking my brain thinking how to put a recurring appts i am not good creating macros for the recurring routes biweekly@@ExcelForFreelancers
Hi and thanks, I added the 'Recurring Appts.' feature on this Excel Calendar template on the Patreon update (Each week I add more features and create a new video for our Patreon members here) www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Hi and thanks very much. Within the weekday formulas please change it so that the last number is a 1 instead of a 2. Please also make sure to watch the entire video so you know how to customize this template. I hope this helps and thanks so much.
Thank you Sir for this tutorial. It's really help me a lot as a beginner. May i please know how to add more than 5 appointment per day? I tried to change the value to10 on the visual basic but when you add new item it will goes that covered the other date. You're response is much appreciated. Thank you
Hi and thanks so much. I show you how to do that in my Patreon update (up to 10 appointments) here: www.patreon.com/posts/ultimate-update-89800221 I hope this helps and thanks so much.
HI Randy, thank you for sharing this! Just had a question if something like this (a dynamic calendar) could be used to incorporate a work schedule and then linked to create invoices for the different type of work. (I think you may have a video on something similar?) But then be able to run reports (breakdown) work done for different months years etc. ….So basically what I'm trying to ask is, if you could run reports on the contents inside the dynamic calendar for the different months, days, years etc ? (so as in this example how many times you did a certain activity i.e.. attended a field trip) Many thanks
Hi and thanks. Yes, for sure, anything is possible with Excel. I have a scheduling and linked invoice in my Clinic Manager training here: th-cam.com/video/9oebyN-ivhU/w-d-xo.html I hope this helps and thanks so much.
Hi Ferrao, thanks so much for your comment. For the Admin sheet I just added a Page Background (same background as in the calendar) then I added and formatted my lists and then created dynamic named ranges from those lists. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you very much for your response. I am a bit slow with excel and do not know how to create the dynamic named ranges as you mentioned. Is there any of your tutorials that can help me with that.... Would appreciate it. 🙏☺️
This is super helpful. I have been trying to make it so different events are colored different on the calendar but can not figure it out. Can you help?
Hi and thanks so much. You can add additional fields such as Item Type (or Appt. Type) in the Admin screen along with a different color for each. I show you how to do that in this training> th-cam.com/video/UwN_b0e3iKo/w-d-xo.html I hope this helps and thanks so much.
Hi and thanks. Yes for sure you can. You can great a new conditional format formula such as =D4=Today() and apply that to every cell in the calendar, starting with Cell D4 and it will color the current date I hope this helps and thanks so much.
Thanks. I solved it with an admin cell =today() and named it Today. Then conditional formatting =ISERROR(MATCH(D4,Today;0))=FALSE Works well too.@@ExcelForFreelancers
How to you change the sheet name from Sheet 1 to a name. in the Developer mode my sheets still show up as Sheet 1(New name) how do I change sheet 1 to show New name(new name) in developer
Hi Dwayne, thanks very much. Each sheet has two names. One is the visible sheet name in which you can change from the sheet itself. The other is the sheet code name, in which you can change from the VBA Editor. Just click on a sheet, then F4 for Properties and then you can change the sheet code name within the properties. I hope this helps and thanks so much.
Hi and thanks very much. You can copy and paste links or screenshots into OneNote, otherwise they are separate programs. I hope this helps and thanks so much.
Great template Randy! I was thinking on adding the name of the holiday. Also, is it possible to create a list with our family birthdates? Could you please help me on this? Keep up the good work.
Hi Jorge, thanks so much for your comment. You could create another sample shape, just like we did on the one for appointments, however instead of loop through the appointments you can loop through holidays and birthdays on the Admin screen and create a new shape for each Holiday or Birthday and add the name and place it to the left of the date for each day. I hope this helps and thanks so much.
Hi Angel, thanks for your comment. I am not sure I understand the question. Are you asking for a week-view schedule in which only a single week is displayed? If so, please check out this training: th-cam.com/video/27ofp1pq4ts/w-d-xo.html or this training: th-cam.com/video/tal2jSKEOCU/w-d-xo.html I hope this helps and thanks so much.
I mean for bookings. I'm trying to convert this calendar into a employee vacation calendar. Trying to figure out how to book more than one day at a time.@@ExcelForFreelancers
HI and thanks for the additional details, you may want to look at this Task-Manager which does multi-day events/tasks here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html I hope this helps and thanks so much.
Hi and thanks very much. This would require format, formula and VBA changes so it would not be something I can explain in a comment, however if you need help with this please create a post in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
This one is simple, clean and nice. I think you will like it. I have lots of ideas for Patreon on this one as well (Recurring items, drag & drop, color-coded calendar item items,, etc. This one was simple enough where i could design AND code during the training :) :) Thanks for your continued support Sammy :)
Hello, perhaps a silly question but I am struggling to link the combo box for years with the information in the admin section. Were the steps for the admin sheet recorded somewhere that I can watch?
Hi and thanks if you want to watch a training from scratch please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries Also for your specific issue, can you please post it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks so much Matt. If you are looking for just the basic template with possible bugs and issues, its free, and can download it using the link under the word DOWNLOAD in the description If you would like a secure and completed version of this Calendar with full email support. Can you please send me an email so that I can get you a link for the full and complete version as it is just about to be launched. Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
HI and thanks. I go over that in this video, however you can do something like a conditional formatting formula such as =Or(Weekday(YourDate,2)=6,Weekday(YourDate,2)=7) A formula like that would return true if it was a Saturday or Sunday You may also like this vertical calendar in which I color days of the week with conditional formatting th-cam.com/video/alFVTxLhlk4/w-d-xo.html I hope this helps and thanks so much.
Hi, How were you able to create the cal item color box? also when doing the VBA, Calendar.Shapes is not recognized and am getting an error message, how can I fix this?
Hi Sarah, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hi and thanks, the color palette is simple a group of rectangular shapes put together and grouped. Then this group of shapes is either hidden or displayed by selecting on a cell. Feel free to copy the one that I have. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi and thanks, in the Admin screen there is an option to change the color to anything you want. I show you this in the training video. I hope this helps and thanks so much.
Hi and thanks, If you are doing this yourself, just create a list of days, then create a named range for the days and call it 'Weekdays' I hope this helps and thanks so much.
Hi and thanks. Currently, the status won't change automatically however this can programmed in very easily. Feel free to download and customize this template however you like and make sure to watch the entire training video I hope this helps and thanks so much.
It’s cool but not really a calendar that can be used by a team at work. If there are more than 5 items to enter on a single day, the entries start overlapping and hiding each other. There is also no selection option to state that someone is taking a full day of vacation or out of the office for the entire day. The holidays can be manually entered and the date on the calendar turns yellow, but would be nice if we could enter the name of the holiday or a date that the company is closed. The calendar does not show time ranges. Like if someone were to have a meeting from 8:00-10:00, it doesn’t say that, it just says meeting at 8:00. Would have to search for the duration on the calendar items tab. Again, really cool Excel project, but just not as capable as an Outlook or Sharepoint calendar.
HI David, thanks so much for your comment and feedback. All of that is capable in Excel and these are all features I have added in past calendars. I am limited to the features I can add in a single training since followers want me to make them from scratch, during the training. Excel is far more capable, certainly and you are welcome to download it and customize it however you like. I hope this helps and thanks so much.
Hi and thanks very much for your comment and question Amir. I did add up to 10 appointments per day in the Patreon update along with recurring appointments and a whole lot more in the update here: www.patreon.com/posts/ultimate-update-89800221 It would be great to have you on Patreon. I hope this helps and thanks so much.
@@ExcelForFreelancers The link doesn't work. Is there a solution? And thank you so much, sir. Your videos are very valuable lessons Please continue. You are an inspiration
Hi and thanks, the link works just fine, however you would need to sign up as a member, and its just a few dollars a month. This is the only way i can bring you the free content each week. I hope this helps and thanks so much.
I'm thinking of a very challenging project, an Excel application to record the data of a transport company. It would record data on trucks, drivers, customers, costs for each destination, fuel for each destination, employee salaries, trip costs for each destination, mechanic salaries, fees paid to the driver for each trip, reminders for maintenance or other repairs for each truck, repair costs for each truck, the work done by each mechanic on each truck, parts replacement for each truck, the different fleets of trucks, daily loads for each customer or private individual, registration of each customer or private individual, automation of invoice drafting which would be different for each customer, automation of sending an email to each customer to inform them about the available trucks for them, and a dashboard showing the company's net and gross sales over the desired period, best customers, number of loads per customer or private individual, etc. As I said, it's a real challenge, but it's possible with you.
This sounds like a great application. If you need any help or guidance please feel free to post your question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi Randy i am suscribe and i bought the 300 templates but i have been looking for calendars, invoices and book appt forms , i have no idea about excel but i have been watching a lot of tutorials and can you tell me how you did the admin screen for calendar i don't get it . thank you in advance
Hi and thanks so much for your your purchase and great to have you here. I have lots of calendars and Invoices in that pack. The admin screen is a basic sheet in which I used a background picture and a few lists in which I have created named ranges for those lists (Such as Days, Years, Holidays, Times & Durations) I also use a single cell to track the color of the calendar items. You can change this cell color to any color you want. I hope this helps and thanks so much.
Hi there, how would the VBA macro change if you wanted to have events displayed over multiple days/weeks. Do you have a start date and an end date and time is irrelevant?
Hi and thanks so much. Please check out my Gantt Task Manager for items that span more than a single day here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html I hope this helps and thanks so much.
@@ExcelForFreelancers Is there any way you could show us how to do the start and end date in this format because the gaant view does not meet my needs but this template exactly does except you can only do one task per day. This would be life changing if you could share please! I see you have had multiple similar requests if possible.
I wrote the code for the Calendar Refresh but it keeps coming up with 'Complie error Invalid qualifier' on the word 'Calendar' in the line... For Each ItemShp In Calendar.Shapes. Could you help out with this please?
Hi and thanks for your comment. You will want to make sure your sheet code name is set to Calendar instead of sheet1 or sheet2 (or something like that) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi and thanks. I did this template quite a while ago. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi Randy, while back I downloaded this video to my email and it did not show up (or something happened to it) but suffice it to say, I tried to download it again and it gave me an error (something went wrong is all it said). What do you need for me to acquire this download one more time? Thanks. Love your stuff, keep up the amazing work you do!
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com. I really want to get you this workbook. Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hi and thanks so much. I make the icons, pictures, backgrounds and all other resources available each week on our Patreon platform here: www.patreon.com/ExcelForFreelancers We would love to have you there
Hi and thanks very much, you can use the Weekday function in Conditional formatting, based on the date, something like =Or(Weekday(yourdate,2)=6,Weekday(yourdate,2)=7) Just make sure the 'yourdate' is pointed to the column that contains your dates. The vertical Calendar is an interesting idea and I have added it to my list of videos to create I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
I have just recorded a brand new training for a vertical calendar based on your request which will be available next week, and it is going to be from scratch. Thanks again for the nice idea
Thanks so much for your great idea. I have now programmed and recorded this training, based on your request, here: th-cam.com/video/alFVTxLhlk4/w-d-xo.html Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks very much. You can use a conditional formatting, based on the current week # or based on dates A formula like: =WEEKNUM(D4, 1)=WEEKNUM(TODAY(), 1) would work just fine inside the conditional formatting The "1" would mean starting on Sunday, and yo would change that to a 2 if your week started on Monday. I hope this helps and thanks so much.
Hi and thanks you can also use conditional formatting based on a string. A quick google search can help you with that. Thank you for your Likes, Shares & Comments. It really helps.
Hi, I'm have trouble with the Item ID/Item Name's stacking on top of one another instead of sorting below each other in the relevant date. Any idea why this is happening?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
I really like this, but I need a similar calendar that shows where my boss and her directors and there travel events, separating each individual by color. So when I show my boss the monthly calendar it shows what events her directors are attending.
Hi Loren, thanks so much. Please check out this Calendar Pro, that may help you achieve that: www.excelforfreelancers.com/go/calendarpro I hope this helps and thanks so much.
Hi Randy, i have tried implementing this training in my work and the code for some reason isn't working, though i have followed every step just like the way you showed it. Sub Calendar_refresh () 'clear all existing item shapes from calendar sheet For each ItemShp in Calendar.Shapes So when i run the macro it's highlighting the word calendar.shapes and the error 'invalid qualifier' pops up. Please help
HI and thanks for your comment. It would be hard to tell however make sure you have the Dim ItemShp as shape abovee. Also make sure your sheet code name is "Calendar" I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
HI and thanks, the color picker is just a square shape with many other square shapes with colors. You can simply copy this shape to any other workbook you want, and also copy and paste the macro and reassign the macro in the new workbook to the new shape. I hope this helps and thanks so much.
Hello, sir I would request you to please create a management system for hotel which includes channel manager, billing, guest entry details and daily expenses.
Hi and thanks for your comment. Please feel free to check out this Hotel Booking template here: th-cam.com/video/ioro9kzW3t8/w-d-xo.html I hope this helps and thanks so much.
hi randy i am having trouble with macros, it keeps saying macro setplatformcolor not found how i can solved it i try different ways and nothing can you help please
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi and thanks you will want to make sure you have Dim ItemShp as Shape Somewhere above the line I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi and thanks. I had made the Admin sheet before the video. (this is important otherwise videos would be 4 to 8 hours long and nobody would watch) You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi and thanks, this shape may be hidden so make sure you click the Selection page and then 'Show All' shapes to make sure it is visible. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hello teacher, My Name is Mhammed from Morocco I am very happy because I finished my first draft of my Minimarket POS following to your good guidelines ❤❤🎉🎉 Thank you very very much Teacher for your helps I wich my good to help you in your life. If you have time please share with us How can we connect Display Customer pole with Excel VBA. Iwant to connect my POS with Monitor of price VFD.
Hi and thanks very much, I am glad you liked the raining. I am not sure what the Display Customer pole is so you may want to check with their documentation. I hope this helps and thanks so much.
Hi and thanks very much. I did not add any data validation for weekdays. Was there some type of conditional formatting you wanted to add? Thank you for your Likes, Shares & Comments. It really helps.
Hi David, thanks for your comment. We do not have any sponsorships however we do plan some good Black Friday deals in November. I hope this helps and thanks so much.
HI , thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Hi and thanks for your comment. All you would need to do is right click on any of the sheets in VBA and click Insert > Module. I have a VBA For Beginners training every Saturday where i will be teaching this. Please join us. Thanks so much
If this is your idea of simple VBA coding, I hate to think what difficult or complex VBA coding looks like.🤔🤣 But seriously. This is an excellent video nicely explained. Sadly, I've hit a problem and I'm not sure if it's the code or another Beta bug. When I try to run my Calendar_Macros macro, I get a visual basic "compile error invalid qualifier". The "offending" Qualifier is *Calendar* in the line of code... For Each ItemShp In Calendar.Shapes ... Your help would be appreciated.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. It is possible you have not named your sheet correctly or dimensioned your variable. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers Thanks for getting back to me. I just thought I'd update you (and everyone else) on my progress. I'm not on Facebook. But, I did follow up on your tip to check I named my sheet correctly (I did) especially checking my spelling (again, correct). However, something urged me to check the Sheet Properties. And, sure enough, that's where the problem was. In Sheet Properties, the Sheet Name was "Sheet2". I changed it to "Calendar". On a whim, I immediately checked the Sheet Properties for the "Items DB Sheet". Sure enough, in Properties, the Name was "Sheet3". I altered it accordingly, saved the File under a different name to be safe and tested the Code. Success! The Beta version of Excel has some wonderful things not available to mere mortals who only have the consumer release, my favourite being the new checkbox feature, but it does tend to throw a curve ball from time to time...like not updating the Properties Sheet when renaming a Sheet for instance. But that is something I take into account and accept as I was warned in advance of the potential for possible bugs. Luckily, taking your tip to heart and diving deeper into Excel, I found the problem and was able to work around it. No further issues experienced. The calendar works as intended.
Hi and thanks very much, you can learn here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass I hope this helps and thanks so much.
Seems like I'm great at finding problems. HAHA... Great app, however a few things are missing from this to make it work. Example: the color palette on the admin page refers to a shape that doesn't exist. Also, if you add a new item with a time of 12:00 AM, it will fail for the cell being empty even though it isn't.
HI and thanks so much for your comments and feedback. I will make sure to check the color palette exists on the sheet and that its assigned to the correct macro. For the 12:00 AM issue, Excel does not see it as a value, since 12:00 AM is zero, so we can work around this by instead of checking if values are empty in those 3 cells (M4:M6) we can use a CountA Formula like this: If Application.WorksheetFunction.CountA(.Range("M4:M6")) < 3 Then MsgBox "Please make sure to add in an Item Name, Date & Time" Exit Sub End If This fixes the issue and I will make the updates on the downloaded version
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Disappointed. Downloaded the "free" file to find it filled with ads not a surprise I guess. Also the macros wouldn't run. Also, tried following along with the video to build my own but failed because you never showed how to build the lists you were using on the admin page. couldn't go past the year dropdown button because there was nothing behind it. Appreciate the work you put into it.
HI and thanks for your download. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ For the ads, you can simply right click on the ads and click delete and they are gone forever. If i were to show every feature available in these workbooks, each training would be 6 to 10 hours long, so I have to set some limits. The skills to build this requires intermediate to advanced VBA, however, I do have a series for beginning VBA here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html I hope this helps and thanks so much.
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
I made my calendar using the day and items as one string with vblf. I also used advanced filter to get monthly items. I added different fill colors for appts or events for my wife or myself. Birthday days get a picture of the celebrant in the lower left-hand corner. Navigation is very similar to yours. It hangs on the refrigerator door with magnets. I do love the way you created the days and colored them accordingly. Now, I get to merge the two. It gives this retired man something to occupy his mind. Thanks for all the tutorials that you give. You really are the best!
HI and thanks Robert. It seems you have created an outstanding calendar. Very well done. I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
hi how did you add different colors for appts
thank you
Hi and thanks @user-bp6dq7vi1u I show you how to do that in this training: th-cam.com/video/UwN_b0e3iKo/w-d-xo.html
I hope this helps and thanks so much.
Can't wait Randy !
I venture to say that my excel career without your comprehensive trainings would be way TOO HARD.
I still hope to learn a lot from you.
Keep it up Mr AUSTIN.
Thanks so much, Keita, I really appreciate the continued support. This one is relatively simple (for you) and small, so that means that I can both design AND code this one from scratch, during the video, so I am excited to bring it to you.
Thank you for your Likes, Shares and comments. It really helps.
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Another awesome project. Thanks so much Randy. I made a few additions to my personal calendar. I split the tasks into 2 categories each with their own sub categories. I also added a couple dynamic fields to show pending or unfinished tasks. (FILTER is the best new formula!) Different colored boxes depending on their status. Also a button to send an email to the administrator responsible for QCing the task. This one is so much fun to use. I get ideas for additions almost every time I fire it up. You’re the man. Thank you for the content. Best on TH-cam by far.
Oh that is really great to hear. I am so glad you enjoyed the training and a great customization Idea. Very well done and thanks again.
This tutorial is incredible, thank you for sharing - it's sparked a whole new interest in Excel for me.
I've been trying to figure out how to sort events that last all day, or don't have a specified start time. When I enter them as 00:00, the cell goes blank - and when I changed the data validation to "All day", Excel sorts this after the valid times (so All day items display below the items with actual start times, I want to show the All day items on top). Is there a way to do this? Thank you
Hi and thanks very much. Make sure that you add a 'Duration' column and field and set the length of that to something like 12 hours. You can then sort by date and duration (descending) so that Duration appears first. I have a vertical scheduler training that may help with this here: th-cam.com/video/alFVTxLhlk4/w-d-xo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you Randy - that's really helpful. I'd like to be able to share the calendar via Sharepoint to allow users to collaborate on it. Is there a reason why they would not be able to enter new items? A debug error comes up but I can't tell where the issue is, as it works for me (as the original creator)
Great stuff. Is it possible to add resources (employee) for each course ? Need a calendar where I can schedule my courses and add freelance instructor for each courses. There could also be some action on each courses that need extra employee
Hi and thanks, Yes for sure this can be completely customized. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
i am really excited for these another template to learn
Great thanks so much. I will be creating this one from scratch, step by step, so you can learn how to create this yourself.
Thank you for your Likes, Shares & Comments. It really helps.
Hi thank you so much for this video! I have a problem, so at 59:30 you said that we must run an advanced filter from A to F, right? But once I do that most of my items disappear. Then when I go back to coding and I type 'With ItemsDB.' I don't get anything. Could you please help me with it?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi, I thoroughly appreciate this video. However, I'm stuck at 1:23:19-Calendar Load. My "Calendar Item" Box at M is not loading any of the data from my selected calendar item although the data appears in the ItemDB sheet. Is there a way to have my code reviewed? Also, I reviewed the Video and still missing at what point the object CalItem was declared and type identified. Where is this done?
Hi Peggy, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this.
If you would like some one on one help, please email me the details and I can forward it to a qualified developer for a fair price (Randy@ExcelForFreelancers.com )
I hope this helps and thanks so much.
I really love what you are doing ! Congratulations genius !
Thank you so very much, I really appreciate that Frize. Thank you for your Likes, Shares & Comments. It really helps.
I want to change the PM-AM time format in my calender appointments... how do I do that. I want it to display the international time like 13:00 etc
Fixed It! I changed the VBA code in Sub Calender_Refresh
I changed this code: ItemTime = Format(.Range("P" & ResultRow).Value, "h:mm AM/PM")
To :ItemTime = Format(.Range("P" & ResultRow).Value, "HH:mm")
It is working perfertly well.
Thank you Randy YOU ARE A BRIGHT STAR!!!
Hi Rayman, I am very glad you were able to fix it. Very well done
Hi, can you help me please!! i'm stuck at 39:17, i'm trying the formula, but it keeps saying that i entered too few arguments for this function, what am i doing wrong or is there anothere formula that i can use
HI and thanks it would be difficult to know unless i saw your formula. Can you share it here? Thanks so much
This is extremely helpful. What if I have an event that extends over multiple days? over an event that repeats?
Hi and thanks, if you have events that are multiple days you can use this type of a scheduler: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html
I hope this helps and thanks so much.
Hi Randy, thanks for the wonderful tutorial, i followed step by step till the point where you tested the Calendar_refresh code, "compiler error: Invalid qualifier" poped up and i couldent figure it out, any thoughts on that?
Hi Waleed, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers
awesome, I’ll be there soon.
Thank you
Great, thanks so much
Good Morning. I am starting to set up my excel calendar, but I need help setting up the admin sheet within the work book. Which video should I watch that will walk me thru the process. Thanks,
Hi and thanks very much, each admin screen is different, slightly, in the School Manager series i have an admin in which i go step by step here: bit.ly/SchoolManagerSeries
However if you have a specific question or specific issue, please post it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
If possible range date include text i think more power full. Great work Mr Austin All of your creation is impressive.
Thank you so very much, I really appreciate that and will add more customizations to new scheduling applications in the near future. Thanks again
Thanks for this tutorial. Trying to figure out how to make it where an event has a start date and an end date, so I want it to display across multiple days. So, it’s almost what I need, but not fully there just yet,
Hi and thanks very much. You may want to check out my gantt task manager which has start and end days here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html
I hope this helps and thanks so much.
How would you conditional format to shade all the cells in the day for the holiday?
HI and thanks. You can try merging and centering the cells for each day, then use the same formula I have used for the existing cells. I hope this helps and thanks so much.
Great work! I'm making this calendar.. How did you get the color theme on the Admin sheet cell F7 under Cal.Item Color
Hi and thanks very much. I used a pop-up color picker (which is just a bunch of rectangular shapes put together) to be able to choose a color. I hope this helps and thanks so much.
Randy, Do you have any training videos I can look at that would help me add a second date to the calendar? I think I am going to use this to setup deliveries and pickups but I only want it shown on those days not the duration of the period. Thanks
HI Justin, thanks for your message. You could just add two cells in your calendar sheet with From and To dates. You can then link these two days with the criteria in the calendar items sheets, instead of the beginning and end of the month. Then make sure to run the calendar refresh macro on any change of these two cells. Make sure to watch the entire training video to help with this. I hope this helps and thanks so much.
I will definitely try this. Thank you Randy!
For sure, you are very welcome and happy to help
Great work again,would it be possible to add some sort of audible noise to remibd you of what you set.thsnks
HI and thanks yes that is certainly possible. I will try to add a similar feature in the future however you can see how its done here:
wellsr.com/vba/2019/excel/vba-playsound-to-play-system-sounds-and-wav-files/
I hope this helps and thanks so much.
GREAT VIDEO! How do I show that an event runs for more than one day/timeframe? Duration is in minutes. I need it in "days". I want to use the calendar to show meetings that overlap. Thank you!
Hi and thanks so much. If you are looking for events that run over multiple days, you may want to check out my Task Manager video and template here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html
I hope this helps and thanks so much.
Thank you so much for your quick reply! Will check it out.
very helpful
Great, thanks so much and glad you liked the training.
This is absolutely amazing! I had no idea the capabilities of Excel such as this. If I may Ask, I am trying to use this to crate a calendar to track monthly budget items and bills rather than appointments, under the Calendar Items sheet, is there a formula or way of setting Calendar Item dates as recurring on a specific day of the week/month/or EOM? Happy to support your patreon for any tips or tricks on this usage of you calendar.
Hi and thanks so much. I did add 'Recurring Items' to this calendar in the Patreon update (Gold & Silver Members) here
www.patreon.com/posts/ultimate-update-89800221
Also, if you sign up for Gold Annual I am offering all 140 workbook updates as a free bonus, so please keep that in mind.
I hope this helps and thanks so much.
Randy,
Thanks for these wonderful Excel workbooks and training. I am working on the Excel Calendar workbook I wanted to add addition items under the Calendar Items table. I am trying to make this into an Emergency Management Exercise Scheduler.
The current Excel Calendar has Item Name; Item Date; Time; Duration; and Notes. I wanted to add 4 additional fields, Type of Exercise (dropdown), Facility Type, Category and Status.
I have tried to expand of the current fields to include the additional fields, but I get an error, Runtime Error 1004 -the extract range has a missing or invalid field name.
I have persed trough line by line in the editor but I am lost and can not see where I made the mistake.
Any assistance would be appreciated. Thank You Dale
Hi and thanks very much. This issue has to do with an advanced filter, headers not matching or incorrect range. I have a training on Advanced Filters which will help you find and fix this issue here: th-cam.com/video/YuCrEWU2Tm0/w-d-xo.html
I hope this helps and thanks so much.
Hi really great video and template. Is it possible to have different Calendar items colours? When I change the colour for a new item all the previous calendar items change aswell.
Hi and thanks, yes it is. I have a completed Calendar Pro version here you may like: rebrand.ly/CalendarPro_YTDesc
I hope this helps and thanks so much.
@@ExcelForFreelancers Darn it tempting to purchase. But I have mac. Beside I prefer the style of your free download. Could I get this as a bespoke £ add on? Can contribute to your account.
Hi and thanks so much. I do have other calendars that may be more helpful to you here: th-cam.com/video/7f2zrZAMkko/w-d-xo.html
This is a new multi-day version with multiple colors.
I hope this helps and thanks so much.
Randy, thanks for share all your knowledge and skills.
My pleasure and thanks so much for your likes, shares and comments
Hi Randy! I've watched this and the task manager tutorial to make a calendar for a friend who still uses a paper agenda and it was really helpful. Especially considering I had never written a single line of code before. They're both excellent and I have almost finished it. I have one small issue. My friend is a teacher, and it would be amazing if she were to be able to schedule recurring events. I know you did something similar for the task manager, but I don’t think it worked with the following example: “Give classes to Laura” every three days for the next three months. I don’t know how to calculate the skip or the end date. I hope you can help with this. Thank you very much for your trainings! I really like them.
HI and thanks so much. I am really glad you liked the training. I have actually added the 'Recurring Events' feature onto the updated version for our Patreon members which will be out on Monday. www.patreon.com/ExcelForFreelancers
IF you are not yet a member, it would be great to have you. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hi Randy! Yes, I saw that and all the other features that will be included. Can't wait!
Great. Thanks so much
Hello, Thank you for this amazing Calendar making video in detail, I am trying to make it however I am getting error of Shape method while running macro, can you please help me to resolve this.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
4am in the morning here is South Africa, notification on,😅😅😅
Awesome thanks so much. I really appreciate that and can't wait to see you in the live chat :)
hello everyone,
i try the calendar and is amazing i have a cleaning and construction company and for the cleaning i am using a daily route with appts for the week and my question is it is possible to change color of the appt? i want to put a color for the cleaning and a different color for the personal appts like a dr. appt.
thank you
Hi yes for sure it is. I show you how to do that here: th-cam.com/video/UwN_b0e3iKo/w-d-xo.html
I hope this helps and thanks so much.
This is an amazing tool, thank you i am braking my brain thinking how to put a recurring appts i am not good creating macros for the recurring routes biweekly@@ExcelForFreelancers
Hi and thanks, I added the 'Recurring Appts.' feature on this Excel Calendar template on the Patreon update (Each week I add more features and create a new video for our Patreon members here) www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
I want my calendar week to start on a Monday and not Sunday? How is this possible, because all the ones I've seen start on a Sunday?
Hi and thanks very much. Within the weekday formulas please change it so that the last number is a 1 instead of a 2. Please also make sure to watch the entire video so you know how to customize this template.
I hope this helps and thanks so much.
Thank you Sir for this tutorial. It's really help me a lot as a beginner. May i please know how to add more than 5 appointment per day? I tried to change the value to10 on the visual basic but when you add new item it will goes that covered the other date. You're response is much appreciated. Thank you
Hi and thanks so much. I show you how to do that in my Patreon update (up to 10 appointments) here: www.patreon.com/posts/ultimate-update-89800221
I hope this helps and thanks so much.
Thank you sir @@ExcelForFreelancers
HI Randy, thank you for sharing this! Just had a question if something like this (a dynamic calendar) could be used to incorporate a work schedule and then linked to create invoices for the different type of work. (I think you may have a video on something similar?) But then be able to run reports (breakdown) work done for different months years etc.
….So basically what I'm trying to ask is, if you could run reports on the contents inside the dynamic calendar for the different months, days, years etc ?
(so as in this example how many times you did a certain activity i.e.. attended a field trip)
Many thanks
Hi and thanks. Yes, for sure, anything is possible with Excel. I have a scheduling and linked invoice in my Clinic Manager training here: th-cam.com/video/9oebyN-ivhU/w-d-xo.html
I hope this helps and thanks so much.
Randy, thanks for sharing this amazing tutorial....I wanted to know how did you create the Admin sheet.
Hi Ferrao, thanks so much for your comment. For the Admin sheet I just added a Page Background (same background as in the calendar) then I added and formatted my lists and then created dynamic named ranges from those lists.
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you very much for your response. I am a bit slow with excel and do not know how to create the dynamic named ranges as you mentioned. Is there any of your tutorials that can help me with that.... Would appreciate it. 🙏☺️
Hi and thanks, yes sure, you can watch this training here: th-cam.com/video/DVa2iKuf68A/w-d-xo.html
I hope this helps and thanks so much.
This is super helpful. I have been trying to make it so different events are colored different on the calendar but can not figure it out. Can you help?
Hi and thanks so much. You can add additional fields such as Item Type (or Appt. Type) in the Admin screen along with a different color for each. I show you how to do that in this training> th-cam.com/video/UwN_b0e3iKo/w-d-xo.html
I hope this helps and thanks so much.
This was a great workout. 👍
I Have a question for you
Could we highlight the cells of the current day in the calandar?
Hi and thanks. Yes for sure you can. You can great a new conditional format formula such as
=D4=Today()
and apply that to every cell in the calendar, starting with Cell D4 and it will color the current date
I hope this helps and thanks so much.
Thanks.
I solved it with an admin cell =today() and named it Today.
Then conditional formatting =ISERROR(MATCH(D4,Today;0))=FALSE
Works well too.@@ExcelForFreelancers
Ok very good, glad to hear that :) very well done :)
I really love what you are doing ! Congratulations genius ! very interested video
Thank you so very much, I really appreciate that and so glad you enjoyed it
How to you change the sheet name from Sheet 1 to a name. in the Developer mode my sheets still show up as Sheet 1(New name) how do I change sheet 1 to show New name(new name) in developer
Hi Dwayne, thanks very much. Each sheet has two names. One is the visible sheet name in which you can change from the sheet itself. The other is the sheet code name, in which you can change from the VBA Editor. Just click on a sheet, then F4 for Properties and then you can change the sheet code name within the properties.
I hope this helps and thanks so much.
Hello is it possible to use these kind of spreadshets insinde onte note ?
Hi and thanks very much. You can copy and paste links or screenshots into OneNote, otherwise they are separate programs. I hope this helps and thanks so much.
Great template Randy! I was thinking on adding the name of the holiday. Also, is it possible to create a list with our family birthdates?
Could you please help me on this?
Keep up the good work.
Hi Jorge, thanks so much for your comment. You could create another sample shape, just like we did on the one for appointments, however instead of loop through the appointments you can loop through holidays and birthdays on the Admin screen and create a new shape for each Holiday or Birthday and add the name and place it to the left of the date for each day.
I hope this helps and thanks so much.
@@ExcelForFreelancers I will try that. Thanks again!
Hi thanks for the calendar. Is their a way to schedule full weeks or a number of days?
Hi Angel, thanks for your comment. I am not sure I understand the question. Are you asking for a week-view schedule in which only a single week is displayed?
If so, please check out this training: th-cam.com/video/27ofp1pq4ts/w-d-xo.html or this training: th-cam.com/video/tal2jSKEOCU/w-d-xo.html
I hope this helps and thanks so much.
I mean for bookings. I'm trying to convert this calendar into a employee vacation calendar. Trying to figure out how to book more than one day at a time.@@ExcelForFreelancers
HI and thanks for the additional details, you may want to look at this Task-Manager which does multi-day events/tasks here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html
I hope this helps and thanks so much.
Hi. If I wanted to add a row to the calendar item box how would I go about transfering that info to the calendar item DB sheet?
Hi and thanks very much. This would require format, formula and VBA changes so it would not be something I can explain in a comment, however if you need help with this please create a post in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
Oh, I have an idea which application needs this!!!!!
This one is simple, clean and nice. I think you will like it. I have lots of ideas for Patreon on this one as well (Recurring items, drag & drop, color-coded calendar item items,, etc. This one was simple enough where i could design AND code during the training :) :) Thanks for your continued support Sammy :)
Hello, perhaps a silly question but I am struggling to link the combo box for years with the information in the admin section. Were the steps for the admin sheet recorded somewhere that I can watch?
Hi and thanks if you want to watch a training from scratch please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
Also for your specific issue, can you please post it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
Hello this calendar idea is really cool. Is it possible to have the excel template?
Hi and thanks so much Matt.
If you are looking for just the basic template with possible bugs and issues, its free, and can download it using the link under the word DOWNLOAD in the description
If you would like a secure and completed version of this Calendar with full email support. Can you please send me an email so that I can get you a link for the full and complete version as it is just about to be launched. Randy@ExcelForFreelancers.com
I hope this helps and thanks so much.
Hey Randy, I have a question, do you know how to make the saturday and sunday date number = conditional format to RED? @
HI and thanks. I go over that in this video, however you can do something like a conditional formatting formula such as
=Or(Weekday(YourDate,2)=6,Weekday(YourDate,2)=7)
A formula like that would return true if it was a Saturday or Sunday
You may also like this vertical calendar in which I color days of the week with conditional formatting th-cam.com/video/alFVTxLhlk4/w-d-xo.html
I hope this helps and thanks so much.
Hi,
How were you able to create the cal item color box? also when doing the VBA, Calendar.Shapes is not recognized and am getting an error message, how can I fix this?
Hi Sarah, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
So cool !
Thank you so very much, I really appreciate that
Great !!
I tried to download this sheet, but nothing in my mailbox .....
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
How do you make that colour palette in cell F7? I cannot find anyway of doing that.
Hi and thanks, the color palette is simple a group of rectangular shapes put together and grouped. Then this group of shapes is either hidden or displayed by selecting on a cell. Feel free to copy the one that I have. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Excelente. Una inquietud. Cómo podría cambiar el color a la forma seleccionada?
Hi and thanks, in the Admin screen there is an option to change the color to anything you want. I show you this in the training video. I hope this helps and thanks so much.
I'm stuck on the data validation lists at 15.26. Do I make them?
Hi and thanks, If you are doing this yourself, just create a list of days, then create a named range for the days and call it 'Weekdays'
I hope this helps and thanks so much.
Does this also update the status of task in the calendar whether completed or not . If completed the actual date of completion
Hi and thanks. Currently, the status won't change automatically however this can programmed in very easily. Feel free to download and customize this template however you like and make sure to watch the entire training video
I hope this helps and thanks so much.
Thank you so much Randy for this amazing tutorial.
Thank you so very much, I really appreciate that Syed. This one was a bit more basic than some of the others
@@ExcelForFreelancers Yes it was but still, love the way you get it done.
It’s cool but not really a calendar that can be used by a team at work. If there are more than 5 items to enter on a single day, the entries start overlapping and hiding each other. There is also no selection option to state that someone is taking a full day of vacation or out of the office for the entire day. The holidays can be manually entered and the date on the calendar turns yellow, but would be nice if we could enter the name of the holiday or a date that the company is closed. The calendar does not show time ranges. Like if someone were to have a meeting from 8:00-10:00, it doesn’t say that, it just says meeting at 8:00. Would have to search for the duration on the calendar items tab. Again, really cool Excel project, but just not as capable as an Outlook or Sharepoint calendar.
HI David, thanks so much for your comment and feedback. All of that is capable in Excel and these are all features I have added in past calendars. I am limited to the features I can add in a single training since followers want me to make them from scratch, during the training. Excel is far more capable, certainly and you are welcome to download it and customize it however you like. I hope this helps and thanks so much.
This is a cool calendar!
Thank you so very much, I really appreciate that
How can I make one day in the calendar include multiple items instead of just 5? Can you help me, please?
Hi and thanks very much for your comment and question Amir. I did add up to 10 appointments per day in the Patreon update along with recurring appointments and a whole lot more in the update here: www.patreon.com/posts/ultimate-update-89800221
It would be great to have you on Patreon.
I hope this helps and thanks so much.
@@ExcelForFreelancers The link doesn't work. Is there a solution?
And thank you so much, sir. Your videos are very valuable lessons Please continue. You are an inspiration
Hi and thanks, the link works just fine, however you would need to sign up as a member, and its just a few dollars a month. This is the only way i can bring you the free content each week. I hope this helps and thanks so much.
I'm thinking of a very challenging project, an Excel application to record the data of a transport company. It would record data on trucks, drivers, customers, costs for each destination, fuel for each destination, employee salaries, trip costs for each destination, mechanic salaries, fees paid to the driver for each trip, reminders for maintenance or other repairs for each truck, repair costs for each truck, the work done by each mechanic on each truck, parts replacement for each truck, the different fleets of trucks, daily loads for each customer or private individual, registration of each customer or private individual, automation of invoice drafting which would be different for each customer, automation of sending an email to each customer to inform them about the available trucks for them, and a dashboard showing the company's net and gross sales over the desired period, best customers, number of loads per customer or private individual, etc. As I said, it's a real challenge, but it's possible with you.
This sounds like a great application. If you need any help or guidance please feel free to post your question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
I'm working on exactly what you need. Interested in such application, when is ready? Send me your contact.
Hi Randy i am suscribe and i bought the 300 templates but i have been looking for calendars, invoices and book appt forms , i have no idea about excel but i have been watching a lot of tutorials and can you tell me how you did the admin screen for calendar i don't get it . thank you in advance
Hi and thanks so much for your your purchase and great to have you here. I have lots of calendars and Invoices in that pack.
The admin screen is a basic sheet in which I used a background picture and a few lists in which I have created named ranges for those lists (Such as Days, Years, Holidays, Times & Durations) I also use a single cell to track the color of the calendar items. You can change this cell color to any color you want.
I hope this helps and thanks so much.
Hi there, how would the VBA macro change if you wanted to have events displayed over multiple days/weeks. Do you have a start date and an end date and time is irrelevant?
Hi and thanks so much. Please check out my Gantt Task Manager for items that span more than a single day here: th-cam.com/video/VrwFrfJWNOM/w-d-xo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers Is there any way you could show us how to do the start and end date in this format because the gaant view does not meet my needs but this template exactly does except you can only do one task per day. This would be life changing if you could share please! I see you have had multiple similar requests if possible.
Brilliant!
Thank you so very much, I really appreciate that
Excellent sir
Thank you so very much, I really appreciate that. I am so glad you enjoyed this
Very good course, really enjoyed it
Thank you so very much, I really appreciate that Tyrone :)
I wrote the code for the Calendar Refresh but it keeps coming up with 'Complie error Invalid qualifier' on the word 'Calendar' in the line... For Each ItemShp In Calendar.Shapes. Could you help out with this please?
Hi and thanks for your comment. You will want to make sure your sheet code name is set to Calendar instead of sheet1 or sheet2 (or something like that)
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
What was the formula for the days of the week??
Hi and thanks. I did this template quite a while ago. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi Randy, while back I downloaded this video to my email and it did not show up (or something happened to it) but suffice it to say, I tried to download it again and it gave me an error (something went wrong is all it said). What do you need for me to acquire this download one more time? Thanks. Love your stuff, keep up the amazing work you do!
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com. I really want to get you this workbook. Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
hi randy, how i can get the icons for the calendars, thank you
Hi and thanks so much. I make the icons, pictures, backgrounds and all other resources available each week on our Patreon platform here: www.patreon.com/ExcelForFreelancers
We would love to have you there
I need a vertical calendar, I struggle to highlight the weekends though
Hi and thanks very much, you can use the Weekday function in Conditional formatting, based on the date, something like
=Or(Weekday(yourdate,2)=6,Weekday(yourdate,2)=7)
Just make sure the 'yourdate' is pointed to the column that contains your dates.
The vertical Calendar is an interesting idea and I have added it to my list of videos to create
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
I have just recorded a brand new training for a vertical calendar based on your request which will be available next week, and it is going to be from scratch. Thanks again for the nice idea
Thanks so much for your great idea. I have now programmed and recorded this training, based on your request, here: th-cam.com/video/alFVTxLhlk4/w-d-xo.html
Thank you for your Likes, Shares & Comments. It really helps.
Hello, sir
How do I make the sampleshape different colors if it is in the same week?
Hi and thanks very much. You can use a conditional formatting, based on the current week # or based on dates
A formula like:
=WEEKNUM(D4, 1)=WEEKNUM(TODAY(), 1)
would work just fine inside the conditional formatting
The "1" would mean starting on Sunday, and yo would change that to a 2 if your week started on Monday.
I hope this helps and thanks so much.
Thank you very much. If I want to change the colors based on specific item name using the refresh button by adding a select, how can I do that?
Hi and thanks you can also use conditional formatting based on a string. A quick google search can help you with that.
Thank you for your Likes, Shares & Comments. It really helps.
Hi, I'm have trouble with the Item ID/Item Name's stacking on top of one another instead of sorting below each other in the relevant date. Any idea why this is happening?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
I really like this, but I need a similar calendar that shows where my boss and her directors and there travel events, separating each individual by color. So when I show my boss the monthly calendar it shows what events her directors are attending.
Do you have anything like that?
Hi Loren, thanks so much. Please check out this Calendar Pro, that may help you achieve that: www.excelforfreelancers.com/go/calendarpro
I hope this helps and thanks so much.
Hi Randy, i have tried implementing this training in my work and the code for some reason isn't working, though i have followed every step just like the way you showed it.
Sub Calendar_refresh ()
'clear all existing item shapes from calendar sheet
For each ItemShp in Calendar.Shapes
So when i run the macro it's highlighting the word calendar.shapes and the error 'invalid qualifier' pops up.
Please help
HI and thanks for your comment. It would be hard to tell however make sure you have the Dim ItemShp as shape abovee.
Also make sure your sheet code name is "Calendar"
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hello, I am really fond of watching this course. May I know where I can download this free template? Please let me know if someone has it.
Hi and thanks very much. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
What if I want to assign different colors to different events?
Hi and thanks very much. I show you how to do that in this training: th-cam.com/video/UwN_b0e3iKo/w-d-xo.html
I hope this helps and thanks so much.
Hello, I'm a little lost. How did the color picker for each item was added?
HI and thanks, the color picker is just a square shape with many other square shapes with colors. You can simply copy this shape to any other workbook you want, and also copy and paste the macro and reassign the macro in the new workbook to the new shape. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you so much!!! Really loving this tutorial of yours.
Thank you so very much, I really appreciate that
Hello, sir I would request you to please create a management system for hotel which includes channel manager, billing, guest entry details and daily expenses.
Hi and thanks for your comment. Please feel free to check out this Hotel Booking template here:
th-cam.com/video/ioro9kzW3t8/w-d-xo.html
I hope this helps and thanks so much.
hi randy
i am having trouble with macros, it keeps saying macro setplatformcolor not found how i can solved it
i try different ways and nothing can you help please
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hello I’m having trouble with “ItemShp” in VBA keep saying “Variable not defined”
Hi and thanks you will want to make sure you have
Dim ItemShp as Shape
Somewhere above the line
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Does this work in Google Sheet as well sir?
Hi and thanks for your comment. This would only work in Microsoft Excel, desktop version.
I hope this helps and thanks so much.
I don’t know where the admin page came from or how it was made. Also where is the link for the free template?
Hi and thanks. I had made the Admin sheet before the video. (this is important otherwise videos would be 4 to 8 hours long and nobody would watch)
You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Am I able to do this in Google Sheets aswell?
Hi and thanks for your comment. This would just be for the desktop version of Excel. I hope this helps and thanks so much.
Your are the Best
Thank you so very much, I really appreciate that
I cant get the SampleItemShp to display on the calendar. Any ideas what Im doing wrong?
Hi and thanks, this shape may be hidden so make sure you click the Selection page and then 'Show All' shapes to make sure it is visible. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hello teacher,
My Name is Mhammed from Morocco I am very happy because I finished my first draft of my Minimarket POS following to your good guidelines ❤❤🎉🎉
Thank you very very much Teacher for your helps I wich my good to help you in your life.
If you have time please share with us How can we connect Display Customer pole with Excel VBA. Iwant to connect my POS with Monitor of price VFD.
Hi and thanks very much, I am glad you liked the raining. I am not sure what the Display Customer pole is so you may want to check with their documentation.
I hope this helps and thanks so much.
How did you set the Data Validation on Weekdays?
Hi and thanks very much. I did not add any data validation for weekdays. Was there some type of conditional formatting you wanted to add?
Thank you for your Likes, Shares & Comments. It really helps.
Thank you
For sure, you are very welcome and happy to help
DAVID HEAR FROM KENYA. DO YOU CAN I GET A FULL SPONSORSHIP IN THE FREELANCE COURSE
Hi David, thanks for your comment. We do not have any sponsorships however we do plan some good Black Friday deals in November.
I hope this helps and thanks so much.
Hi I love ur video but I really have no knowledge of excel,. I'm stuck half way,. I would love some help please
HI , thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
Macros
When I go into the Developer Tab, and click VB
I don't have the Modules Folder.
What Step am I missing? This is my first time using Macros.
Hi and thanks for your comment. All you would need to do is right click on any of the sheets in VBA and click Insert > Module.
I have a VBA For Beginners training every Saturday where i will be teaching this. Please join us. Thanks so much
If this is your idea of simple VBA coding, I hate to think what difficult or complex VBA coding looks like.🤔🤣
But seriously. This is an excellent video nicely explained.
Sadly, I've hit a problem and I'm not sure if it's the code or another Beta bug. When I try to run my Calendar_Macros macro, I get a visual basic "compile error invalid qualifier".
The "offending" Qualifier is *Calendar* in the line of code...
For Each ItemShp In Calendar.Shapes ...
Your help would be appreciated.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. It is possible you have not named your sheet correctly or dimensioned your variable. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers
Thanks for getting back to me. I just thought I'd update you (and everyone else) on my progress. I'm not on Facebook. But, I did follow up on your tip to check I named my sheet correctly (I did) especially checking my spelling (again, correct). However, something urged me to check the Sheet Properties. And, sure enough, that's where the problem was.
In Sheet Properties, the Sheet Name was "Sheet2". I changed it to "Calendar". On a whim, I immediately checked the Sheet Properties for the "Items DB Sheet". Sure enough, in Properties, the Name was "Sheet3". I altered it accordingly, saved the File under a different name to be safe and tested the Code. Success!
The Beta version of Excel has some wonderful things not available to mere mortals who only have the consumer release, my favourite being the new checkbox feature, but it does tend to throw a curve ball from time to time...like not updating the Properties Sheet when renaming a Sheet for instance. But that is something I take into account and accept as I was warned in advance of the potential for possible bugs. Luckily, taking your tip to heart and diving deeper into Excel, I found the problem and was able to work around it.
No further issues experienced. The calendar works as intended.
Hi and thanks so much for the update. I am glad you wer eable to get it resolved. Thank you for your Likes, Shares & Comments. It really helps.
Hi sir I want to learn advanced Excel formulas and dashboard
Hi and thanks very much, you can learn here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass
I hope this helps and thanks so much.
Seems like I'm great at finding problems. HAHA... Great app, however a few things are missing from this to make it work. Example: the color palette on the admin page refers to a shape that doesn't exist. Also, if you add a new item with a time of 12:00 AM, it will fail for the cell being empty even though it isn't.
HI and thanks so much for your comments and feedback. I will make sure to check the color palette exists on the sheet and that its assigned to the correct macro.
For the 12:00 AM issue, Excel does not see it as a value, since 12:00 AM is zero, so we can work around this by instead of checking if values are empty in those 3 cells (M4:M6) we can use a CountA Formula like this:
If Application.WorksheetFunction.CountA(.Range("M4:M6")) < 3 Then
MsgBox "Please make sure to add in an Item Name, Date & Time"
Exit Sub
End If
This fixes the issue and I will make the updates on the downloaded version
Am I able to print all of the months?
Hi and thanks yes certainly you can. I have also added more features onto this from our Patreon platform here www.patreon.com/ExcelForFreelancers
💕 from here
Thank you so very much, I really appreciate that Mary
I am almost done but have an issue with running the code
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Disappointed. Downloaded the "free" file to find it filled with ads not a surprise I guess. Also the macros wouldn't run. Also, tried following along with the video to build my own but failed because you never showed how to build the lists you were using on the admin page. couldn't go past the year dropdown button because there was nothing behind it. Appreciate the work you put into it.
HI and thanks for your download. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/
For the ads, you can simply right click on the ads and click delete and they are gone forever.
If i were to show every feature available in these workbooks, each training would be 6 to 10 hours long, so I have to set some limits.
The skills to build this requires intermediate to advanced VBA, however, I do have a series for beginning VBA here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
Workbook closes intermittently. Are there issues with codes?
Hi and thanks for your comment. I have not had that issue. Do you have any other add-ins or workbooks that may be running at the same time?
I have added features and changed some formats. Would you like to have a copy of mine? It also has paint job estimating.@@ExcelForFreelancers
Hi and thanks. Sure you can email it to me here Randy@ExcelForFreelancers.com
genious!
Thank you so very much, I really appreciate that