Did a similar maintenance system in MS Access. Love seeing someone who echoes my internal passion for facilities….as a retired facility manager, maintaining my home has the same importance to me.
HI and thanks Carlos. I appreciate that. I have had a few 'Work Order' trainings however if you feel that there is something important that i have not covered, please let me know and I will create a training on it. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so very much, I really appreciate that. I will try to do more videos in the near future with more reporting and planning. Thank you for your Likes, Shares & Comments. It really helps.
Great video, thank you. Jumping into deep end I suppose and trying to learn, mainly as a hobby and for my job as maintenance worker. So I was wondering how could I developed something that kept track of repairs implemented into this.
Hi and thanks so much. Please feel free to download and customize this however you like You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount
Great video, thank you. I would love to see how you create a Stunning Interactive Dashboard in Excel! Showing sales, cost of sale, expenses for a multi-product business. Thanks for your teaching
Hi Lars, thanks so much. Yes there is a TON i can add to this. Please put your ideas on the Patreon post and I will try to get to as much as I can. Thanks again for the great idea.
All videos in your channel are important. Where to start seeing. If I make a video about that, I think everyone will benefit. Everyone will be able to learn through serials.
Hi and thanks so much. Please make sure to develop your own applications, your own content and your own training, otherwise RU-vid will remove them if they use my applications or content. I hope this helps and thanks so much.
Amazing work! Thank you. One Suggestion in coding for determining the Last Row. Instead of using : Range("A9999").End(xlUp).Row --> maybe you can use: Range("A" & Rows.Count).End(xlUp).Row --> This way you only go down for as much as you need to instead going down all the way to 9999 then coming back up. I'm just saying if it helps speed up code
Thanks so much for the suggestion Elmer. I will add that in as well at times. I am glad you enjoyed the video. Thank you for your Likes, Shares & Comments. It really helps.
Great video, thank you. Jumping into deep end I suppose and trying to learn, mainly as a hobby and for my job as maintenance worker. So I was wondering how could I developed something that kept track of repairs implemented into this. E.g you have a component in stock, technician took a component and replaced faulty one, you can note the location of used component, the faulty component logged and at later date got fixed, then used somewhere else, so the history of that part is built up along with any parts related to it. E.g a machine and it’s hard drive for example.
HI Rob, thanks so much and glad you enjoyed the video. Based on your description this application can handle most of that. You may want to add some additional data in the Jobs Order Item Database if you like. If there are specific features you would like me to add, I will be doing that on our Patreon platform this week: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
You can create a adhoc maintenance request to do repair (replace the faulty one) and then schedule it. It will get recorded in the database that the component is loaded on a particular asset. Let me know if I misunderstood anything?
Wow, excellent job man. you are amazing. can you please develop a teacher's manager including only administrative details and supervision reports templates and teachers timetables? can you please do that? but without deatils about payrolls ! thanks a lot
Hi thanks so much. I am glad you enjoy the content. I have a complete school manager's series here: ru-vid.com/group/PLIBeRriXvKzCNzJdnrmVBjgF7W2iBqHqZ I hope this helps and thanks so much.
Hi Sayed, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
That is coming. Next year I will start a new channel, just for Freelancers, and I have a new course for freelancers available in just 1 month. Thank you for your Likes, Shares & Comments. It really helps.
It is incredible. Anyway, may I see a list of digital management report and plan of doing with social media. Example, for Facebook,as a person who manages with multi task
Ok, nice idea. I will add it to my list of videos to create. I do have one here, but it does not really have a calendar: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KlyLJfE9Bc0.html
Hi Randy, us there French people in your mentorship program? How to adapt Excel account software to french market if we join your program as French people ? Are there legal things to adapt into your Excel account software to match on French Market? Do you learn to student how to find customer as a Excel softwares freelancer to sell our applications? Do you propose several payement to join it during your promotion? Thanks Randy for all the value you give to us!
Hi and thanks so much for your comment. Yes i have had French people in the course and they have done very well. As far as the payments, it really depends upon time/money. If you have more time than money, the monthly payment option is a great choice. However if you would like to complete the course sooner than later, you may want to go with a full package. On completion our students have all of the tools to create and sell their own applications for passive income> www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
Hi and thanks so much. I try to focus on core excel features and functions whenever possible. Thank you for your Likes, Shares & Comments. It really helps.
I'm in way over my head with this, I'm going to need some training to use this template. can you point me in the direction on beginner courses so i can understand and use this? Thank you...
HI and thanks, yes for sure. Each Saturday, starting this week, I will be creating beginners VBA videos right here on my channel. So make sure you subscribe and set your notifications on. If you want to learn faster, you may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared
Hi and thanks so much Essam. I do appreciate that. I do have a Call Center application i called Help Desk Manager here; ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yr9UzELXG8M.html I hope this helps and thanks so much.
Wow i like that , and i have question i am fire man manager in ETHIOPIA and it's hard for me to give Rank to them by they performance so can you DO something about that and also dashebord also included based on there performance.
HI Elias. Thanks so much. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 40,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
Hi Juan, I also got your email. You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
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 so much. I did this training quite a long time ago, however for your issue you can 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.
I was able to download the file, I have some questions you'll probably help me: When I press a buttom I can see the following window: Error "1004" The following "Macro" desn't exist or the address: D:\Dropbox\Excel4Freelancers\FreeTrainingVideos\Work Maintenance Manager\Technicians
Hi and thanks you will want to make sure to include the path to your own folder of technician pictures. I discuss this in the training video. I hope this helps and thanks so much.
wondering if there is a way I can export my outlook calendar into Excel so I can see al my weekly and bi-weekly meetings and make a meeting cadence spreadsheet.
Hi and thanks so much. I have a video on that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3ws0hYUJTsc.html I hope this helps and thanks so much.
Hello Randy, I have an electrical contracting business and have over 500 maintenance contracts. This manager would be a fantastic addition for us to use. How could I purchase a working version of this application?
Hi Kevin, thanks so much for your comment. I provide the template for free however it is a good idea to have it customized, secured and ready to use in the real world by a qualified developer. I would be happy to refer you. Please email me all of your requirements so that I can refer a professional developer. Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
Wondering how I can replace Customers with Students and Technicians with Therapists 🤔 for my position as an ATP at a School for Blind and Disabled Children.
Hi and thanks there is no easy way to answer that in a RU-vid comment however, 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 you can download one of my more recent videos, such as Mobile Employee Timesheet (Download here: www.dropbox.com/s/jrwgqq5oy9m983d/Mobile_Employee_Timesheet.xlsm?dl=1) You can then copy the hidden pop-up calendar sheet and code if needed. I will make the updates as well in the near future. I hope this helps and thanks so much.
@@ExcelForFreelancers GOt it! the issue seems to be in the code, i copied the sheet,i seems to be missing this line "If ColNumb = 1 Then ColNumb = 8" right after code line 149. for the Select day Of Month Section. thank you for the quick replay, i am using it for a small project and it comes in handy beautifully.