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 RU-vid by far.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UwN_b0e3iKo.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.
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.
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 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.
8 месяцев назад
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VrwFrfJWNOM.html 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.
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.
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 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 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.
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.
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 :)
Hi and thanks, if you have events that are multiple days you can use this type of a scheduler: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VrwFrfJWNOM.html I hope this helps and 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.
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.
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.
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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-alFVTxLhlk4.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)
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
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VrwFrfJWNOM.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. 🙏☺️
Hi and thanks, yes sure, you can watch this training here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DVa2iKuf68A.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> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UwN_b0e3iKo.html I hope this helps and thanks so much.
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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YuCrEWU2Tm0.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.
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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UwN_b0e3iKo.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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9oebyN-ivhU.html 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.
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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ioro9kzW3t8.html I hope this helps and 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, 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 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 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.
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 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.
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 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 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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-27ofp1pq4ts.html or this training: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tal2jSKEOCU.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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VrwFrfJWNOM.html I hope this helps and thanks so much.
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. 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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-alFVTxLhlk4.html 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. 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.
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. I show you how to do that in this training: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UwN_b0e3iKo.html I hope this helps and thanks so much.
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 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, 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.
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
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 ru-vid.com/group/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z 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 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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-alFVTxLhlk4.html Thank you for your Likes, Shares & Comments. It really helps.
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 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 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 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
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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VrwFrfJWNOM.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.
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
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.
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 and thanks. This can happen if you are using a named range in your formula, however the named range does not exist in your worksheet or workbook. Please double check 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 , 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. This is normal now for any file that contains maros. 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/ I hope this helps and thanks so much.
HI and thanks make sure to go into the Options, Security Settings and enable all macros. 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
This is simple enough where you can add this to almost any application. Clean simple and nice, Even the Calendar uses only ONE cell for the large formula, the others are simple adding the previous day, even with the dynamic start day and color-coded holidays.
Hi and thanks for your feedback. If the code was a bit complex I do have a VBA Basic series here: ru-vid.com/group/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
Hi and thanks so much. The Admin tab was already set up before the video started. I have to limit the trainings to specific areas, otherwise many trainings would be 6 to 8 hours long. If you are looking for completely, from scratch training, 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 I hope this helps and 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, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks. You can use the shortcut Alt + F11 to get into the VBA Editor as well I hope this helps and thanks so much.
Hi Daniel, you can download this file using the links in the description under the word DOWNLOAD. I do need your email in order to know where to send the workbook. There is no need to create an account. I hope this helps and thanks.
This is a great calendar, however when you stipulate this will be built up from ground zero that even a beginner can create it, is not true. Your whole ADMIN section wasn't included in the creation for this calendar. Frustrating that I started 30 mins in to realize I have no idea how you created the ADMIN section. Great Calendar Poor execution as a tutorial.
Hi and thanks for your comment. I understand your frustration. If I had started with a blank workbook the training would be 8 hours long, so some work has to be done previously. These applications are certainly NOT for beginners and for intermediate to advanced Excel developers. Also, the Admin screen are simply filled in cells with some data to help establish some of the lists and fundamentals If you are looking for basic VBA training I have those lessons every Saturday here ru-vid.com/group/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
![How To Make A Calendar In Excel 2024 For Unlimited Years [From Scratch + Free Template]](/img/logo.svg){kind=logo}
