Learn How To Create This Amazing Vehicle & Fleet Expense Tracker In Excel Today [Part 1]
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- 🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN TH-cam MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create your own Vehicle Expense & Maintenance tracker.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/VehicleExpPt1_Wb
📍 Watch Part 2 HERE: • Track Expenses, Fuel, ...
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:36 - Overview
2:53 - Worksheet Design
39:53 - Hide All
44:40 - Vehicle Tab
51:00 - Reminders Tab
52:18 - Meter Tab
52:44 - Dashboard Tab
56:22 - Load Vehicle
1:03:40 - Selection Change Event Worksheet
1:05:34 - Add Vehicle
1:07:08 - Add Picture Vehicle
1:09:59 - Show Picture Vehicle
1:13:44 - Clear Picture Vehicle
1:15:13 - Save Vehicle
1:19:05 - Load Picture
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #vehicleexpensetracker #expensetrackerinexcel #excelvba
![Fleetio Product Demo: A Modern Fleet Management Software Solution w/ Mobile App [Jan 2023]](http://i.ytimg.com/vi/VhX4pAzAWuA/mqdefault.jpg)
![Track Expenses, Fuel, Mileage AND Reminders in this Amazing Excel Vehicle Expense Tracker [Part 2]](/img/n.gif)
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
Honestly, this is a masterpiece of Excel Execution. You keep outdoing yourself.
Thank you so much Dr. John. I really do appreciate that and look forward to bringing you new and exciting videos each and every week. Much appreciated.
Thank you so much for this wonderful training video. This is something that everyone would love to have it. Once again thank you Randy Sir.
You are so welcome Ashokan. I am really glad you enjoyed it.
Mini Masterclass in Excel user interface design, right up until 39:00.
Absolutely golden process walkthrough. 🏆💯🔸🔶🔸
Thank you so much Ben I really appreciate that. One person said "Too Many Buttons". LOL. Well you can't please everyone. Make sure to check Part 2 coming this Tuesday. I always appreciate your feedback and following.
Excel For Freelancers I'll be watching it as soon as I can.
I'm looking forward for this presentation and would adopt to supplement my initiative, thanks for this great creativeness.
Hi and thanks so much. I think you will love it. It is a two-part series so make sure you check next week as well. Thank you.
Wow Randy once again great creativity...I've been waiting for something like this. I have a question and perhaps a suggestion for your part2. Perhaps when entering repairs to a specific vehicle you could facilitate entering several repairs on the same vehicle on the same date. Sometimes you are having several repairs done at the same time. Perhaps you had already planned on doing that, in which case thank you. Keep up the great work.
Hi Tony, thanks very much for your suggestion. Users can add unlimited repairs to a vehicle on any date, however its set as a form entry, as opposed to a table entry like an invoice, so it would be one repair at a time. With that said we could perhaps automate the repair date to either the current date or the last date entered to make it easier to add in multiple repairs on the same date quickly and easily.
Thanks for the great suggestion.
Thank you sooooo much ..your efforts are highly apprecated , I've just finished Part1 ...learning slowly :) but I am happy I've done it ..I like your style ..It's Amazing ...All is working well except ..one thing "the picture is not loading though I've added the picture load (VehicleShowPic) ..Maybe I should revise that again .. .revised & working well now ...thank you
So great i am glad you got it working. These things always take time on our first tries. Even for me. You are doing great so keep it up and thanks for watching Hamid.
Very creative. Love that conditional formatting trick that shows which tab is selected 👏
For sure, you are very welcome and happy to help Ray.
hello ray i cant seem to get it to work for me I followed the video but It keeps opening up as one big tab. i think I'm missing a step or something
Thank you very much Randy Sir. your efforts highly appreciated
For sure, you are very welcome
Mr. Randy, Thank you for your wonderful job ... ☺️
My pleasure! You are very welcome abdul.
Your works are wonderful and very useful. Lot of your efforts go behind it. Can I buy your works selectively instead of the full pack?
Hi and thanks very much. I only have the full packs available and not individually for sale. I hope this helps and thanks.
I have seen first time the level of the excle....it's amazing bro
Thank you so very much, I really appreciate that Temp
Thanks Randy for this beautiful video.
Thank you so much Syed. I am quite glad you enjoyed it.
This will up my skill set in my new journey as a transport officer.
Oh that is great to hear. Thank you for your Likes, Shares & Comments. It really helps.
Great. Waiting for the second part.
Thanks very much and I am looking forward to bringing it to you.
Great Training and thanks for sharing! I have one question though: How to create the modules in the VBA part(TopTabs_Macs, Reminder_Macs...)?
HI and thanks you can right click on any of the workbook sheets and click Insert > Add Module
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_Randy_Shared
Thanks alot . I have never seen this kind of excel in my carrer.
Thanks so very much Karthick. I am glad I can help and share. Thank you for your Likes, Shares & Comments. It really helps.
Great work Randy!
Thank you very much. I do appreciate that Alfred
Outstanding tutorial. Thanks for sharing! I'm attempting to edit a dropdown list box from the vehicle expense tracker template main form. I'm a newbie and struggling with that. Do you have a tutorial that addresses that?
Hi and thanks. The drop down list is tied to a named range. Editing the named range tied to the data validation list will also edit the contents of the list. I do not have a specific video on this however if you search "Excel Data Validation" you will get tons of great video trainings.
What a beautiful dashboard. Thanks a lot!!
I had a doubt. Can such a model be made for live tracking( ie. Updating the location of a truck etc based on an input excel file everyday)?
Hi Sajay, thanks so much. Yes certainly this can be customized for a live tracking, not a problem. I hope this helps and thanks so much.
Really nice tutorial.... I like your style. Will learn a lot from you. Do you have a favorite go-to for icon sets?
HI thanks so much Raymond I am glad you enjoyed the training. One of my favorites is : adioma.com/icons
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Awesome! Thank you for replying. Yours look terrific... just looking to recreate, via your tutorials, with my own personal touch :)
with it in a few weeks or months if I pour enough ti and effort into it. I'll be watcNice tutorialng many more of your videos for tips and inspiration.
Thank you for your Likes, Shares & Comments. I am happy to help Bhausaheb
If I continue to follow your videos I will become professional in Excel
For sure you will and thanks so much Ayoubah.
You are so inspiring, thank you
Thanks so much Steve, I really appreciate that.
Thank you so much sir for this skills.
It helps me alott.
For sure, you are very welcome Taposh.
it was really nice vedio but little hard note commands bcz of 🔎 zoom issue. Thank you so much for sharing such a nice work
Thanks so much and I am glad you like the video.
This is fantastic! Im really interested to know if something similar can be done in google sheets. Im trying to create one and this would be perfect
Hi and thanks. I am not sure about Google Sheets, however if you want to share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/f_1HsR9305I/w-d-xo.html
I hope this helps and thanks so much.
Really appreciate your great efforts
For sure, you are very welcome
Thanks this is a good application to develop and deploy in an organization
Thanks very much. I am glad I can help.
Great Video! Excuse me for butting in, I am interested in your thoughts. Have you researched - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a smashing one off guide for getting 7000 plus project management and business templates without the headache. Ive heard some unbelievable things about it and my m8 after a lifetime of fighting got amazing results with it.
Thanks for this great video.
For sure, you are very welcome Bora
Hello - Thank you for this! It is just the solutions I need for a small business. We use a MacBook and IOS systems, are your templates compatible with Microsoft 365?
Hi and thanks, my templates have been tested on PC's and not Mac's since Excel has limited functionality on some versions of Mac's.
However you can download the application and customize it however you want. More information on Excel & Mac's can be found here: www.macexcel.com/
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
100% perfect video 👍😊👏
Thank you so much Lars. I do appreciate that.
Great work, it will be helpful if you can make the vb code available as a text file! How to make question bank in excel and then randomly create test paper in word, just a thought, if possible.
Hi thanks very much for your comment., you can download this file using the links in the description above with either your email or Facebook Messenger. I do have a 2 part Quiz application on my channel in which you may find interesting so feel free to search for that. Thanks so much.
Please give me this file
Great video. I manage 300 vehicles, is there an easier way to put the vehicles other than on the dashboard
Hi Michelle, thanks so much. You can add the vehicle data directly into Vehicle sheet. If you need help customizing this we have thousands of Excel developers in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 30,000 Members who would love to help you with this. Thanks so much.
This is a great work sir, I am also trying to do this. When it comes to if error function , I cant go further. it doesn't show "vehicles" in drop down list to select.
Hi T-Dash, 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 40,000 Members who would love to help you with this. Thanks so much.
This is very interesting and informative. thank you for sharing.
Thank you so very much, I really appreciate that Elmer
This is really nice!!! Thank you for showing it step by step! I have some issues with some of the steps! It look like my excel .. some of the settings is not there! How can I get in touch with you??
Hi Cielie, 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 50,000 Members who would love to help you with this. Thanks so much.
Thank you so much, this is very creative and thanks for teaching us alot.
For sure, you are very welcome and I am happy to help and share
It's so great
Do you have video for beauty salon like this
HI thanks for your comment. I do not have a beauty salon application however i have man scheduling applications that may be helpful for this kind of business. Thank you for your Likes, Shares & Comments. It really helps.
This is good for who anyone wants to keep records for tax purposes!
Yes absolutely Joe. Thanks for your continued support
Brilliant thank you.
You are very welcome and I am happy to help Nitasha
Excellent Randy, Just one comment, maybe this was already covered in the 2nd part, I have not seen it yet.
The vehicle list on the right in the vehicle section, is that a control list, a frame, ? How it is supposed to grow as you add vehicles, I see that you paste the link from the vehicle sheet, but this list seems 'dead coded in there static".?
In other words, new vehicles added how do they show in this list?
HI and thanks Edward. The vehicles are just linked to the original list, so as soon as vehicles are added in the database they become visible in the main sheet. If you want to add a lot of vehicles, you may want to use a drop-down list design instead of the left menu design. I hope this helps and thanks for the comment.
Bro can we talk private
Which social media handle can we chat please
Hi,if you can include like a auto visit code generation of when vehicle visit for maintenance and give more option of reports..tech cost...open visit code and when finish repairing close visit code along with time..and also if include repairing code number of multi category..
Hi thanks for your great suggestion. I will do my best to try and get that in. Thanks so much.
@@ExcelForFreelancers thanks for consideration the suggestion..
Thank you for this excellent video. How can I change the icon without affecting the macros?
Hi and thanks you can ungroup the buttons, remove the icons, add your own icons, regroup and reassign the icon.
Please make sure to watch the video.
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
@@ExcelForFreelancers Thank you very much, it worked.
Very good. Thank you for your Likes, Shares & Comments. It really helps.
Again another GREAT Video.... i know the Full project isn't done but you did most of the work on the VEHICLE tab.... you have the ADD\SAVE btns... what about an UPDATE btn? maybe you need to make changes to an existing vehicle. You need to add some notes later on after your initial entry. Maybe it's planned??? Or is this OUR homework project for the week :)
Also a note: you copy a lot for formats from other cells to make is all alike.. you never click the FORMAT PAINTER Button?
Thanks 👍 Erik. When it comes to updates to the vehicles we have two choices. Updates via a button or automatic updates to previously saved vehicles. In part 2 I will opt for automatic updates, so that means as soon as a change is made the database is updated, using data mapping and helper columns off to the right. (I bet you can figure it out if you use some of my past trainings)
For the formats I guess i just got used to right click but i will also starting adding Format Painter in my trainings as well. I love saving keystrokes. Thanks for the great suggestion.
amazing masterpiece...waw.,️☕👍👍
Thank you so very much, I really appreciate that
More and more I use, I get interesting questions. When the number of vehicles are more than 15 then how can we load the vehicle details, because Vehicle List can have only 10 vehicles. Can we use drop down list to load the cars? In this case what change needs to be done in existing macro? Thanks in advance for your help!
Hi and thanks so much, you can use a drop down list for the vehicles, you can use a Match Formula to determine the row # of the vehicle, or Index/Match to determine the vehicle ID and load the vehicle details on change event.
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
Very nice advice
Thank you so very much, I really appreciate that Kama
Hi Randy. A plea for a little help please! I am trying to make a very simple spreadsheet "issues register" my work colleagues and I are using a bit more user friendly, printing off the entire worksheet much more cleanly as well as designing a userform to select a range of row(s) to print from the spreadsheet. That part is all good. At the end of the print routine (a command button within the userform) I have written the following piece of code:
"Worksheets("Register").Activate
' ActiveSheet.Range("C" & Rows.Count).End(xlUp).Row + 1
' Range("C100000").End(xlUp).Select."
Both lines are commented out here, but neither line will return the result I am look for, i.e. to have the last empty row in the active worksheet become active. For help I have spent too much time searching through various lines of Excel code as presented on YT, but struggle to see why it is that neither of the two options I have tried simply will not return the result needed.
I would sincerely appreciate your eyes on what I have written, welcoming your critical feed back.
Thank you.
Hi and thanks for your question. I think the issue is, I don't know what you mean to make a row 'become active' as this is confusing for me. I don't understand also 'last empty row' also. Do you mean the last row in a worksheet that contains a value? (that would be the last used row, not the last empty row.
Please be much more specific with your goal. Also please feel free to add your question and screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.
Amazing, the only thing that did not work for me was the Conditional formatting for top tabs, other than that, Thank you. Gonna start next now
Glad it helped and thanks so much.
@@ExcelForFreelancers Randy, because of you I finally started working towards my business.
You truly are a God send.
Thank you
Thank you so much Hamza
This is too nice
Thank you so much. I appreciate that and make sure you catch Part 2 coming this Tuesday.
I am re-building this great app in my language (with several modification, I might add) but am wondering how to prevent duplicate car names, or rather duplicate plate numbers, as those must be unique. I have watched the video several times and did not see a reference to duplicate prevention. Is there a template/video that can help me out?
HI and thanks very much. You can run a search to see if it exists, however it must be slightly different it if is a new vehicle or not. Something like this
FoundRow = Vehicles.Range("Veh_Name").Find(VehName,,xlValues,xlwhole).row
If 'New Vehicle
If VehRow 0 then
Msgbox "Vehicle name already exists"
Exit Sub
End If
Else 'Existing Vehicle
If FoundRow VehRow then 'This means the vehicle name was found, but not on the same row as this existing vehicle
Msgbox "Vehicle name already exists"
Exit Sub
End IF
Something like that. I hope this helps and thanks so much.
amazing video great
Thank you so very much, I really appreciate that.
Hi. I cannot seem to get the workbook - the 'Download Free Workbook' page seems to fail...
Hi and thanks for your comment. Sorry you had an issue. I noticed that the email company's website who delivers our emails was down for a few hours. Can you try again with the same link and it should work now. Thanks so much for your patience.
Wonderful ! Please Mr Austin, where do you find your icone ?
Hi Al thanks so much. I get a lot of icons from here: adioma.com/icons
@@ExcelForFreelancers Thank you, sir !
What was on the other sheets? i couldnt see everything on the vehcle list or the others
Hi and thanks, you can download this file for free, and check out the entire template, using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
!!! Thank you !!!
You're welcome Armo, glad I could help.
Nice video
Thank you so very much, I really appreciate that Saiful
Excellent
Thank you so much 😀 Kumar
Dear randy
I need to know from where I can get this icons
Hi Khaled, thanks so much for your comment. You can get those free icons from here:
adioma.com/icons
I hope this helps and thanks so much.
Hello i need help at 14:27 when i put the formula in and format everything one big tab opens up. i think I'm missing a step please advise
Hi and 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.
OMG! This is a master piece. How can i use this in my business? I have a trucking company and i would like to use this Expense Tracker.
Thanks so much
Hi and thanks so much. I am really glad you enjoyed the training and I do understand your requirements. You are welcome to download this for free and use it however you like. If you would like to have this customized for you, I would be happy to refer you to a competent developer who could handle this for you.
Just let me know if you would like to proceed and I can forward your details to them via email Randy@ExcelForFreelancers.com
Thank you very much.
@@ExcelForFreelancers yes i would like to get this customized for my business. Have him email me
@@ExcelForFreelancers i also have a MAC would that be an issue? Thanks
PC's are much better than MAC's for Excel uses however you can get most features with a few limitations. I hope this helps and thanks so much.
Good video 💖💖💖
Thank you Rofiqul
Nice
Thank you so very much, I really appreciate that Nashik
Thank you for your Likes, Shares & Comments. It really helps.
I tried your to build the excel application and getting debug error on .Range(4 & "." & 89).EntireRow.Hidden = False. Can you suggest why?
Hi Lalit, please use a colon instead of a period between the quotes. 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 Randy
How can we find first row immediately after the row we freeze ?
In this video you saved images in different folder , but how can we do by keep all our images in same excel file so that portability of the file is much more easier
Hello Biju thanks for your comments. You can simple use VBA line code to check on the froze row value and put that into a variable. Also, using VBA, you can copy photos from anywhere on your computer into a specific and designated location (See my Employee Manager for examples of that)
Thanks so much.
Randy its really awesome 😊
Thank you so much 😀
I am a small trader supply to railway. I am a one man army. Have to quote, get the order, issue order on the suppler, procure material, prepare delivery challan, Tax invoice, maintain books etc. I am conversant with excel. Maintain above data in separate sheets in one workbook. Challan, Tax invoice, purchase order are prepared with if, vlookup functions, I want to automate these and want a comprehensive dashboard report. Request suggest suitable program(s)
@@malaramu Gee, what else do you want?
Hi @Malaramu, Can you please create a post with the words PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.
I wish to get one by one tutorial or reference book to understand all the formulas & VBA as well.
It's really very difficult to implement when You just know the basic Excel. (it's looks a far impossible in beginning) so can you please show us few FREE excel ebooks or series tutorial.
which will work on Excel and VBa as needed.
when we look this video it's seems that I have skipped all the lecture in between.
Hi and thanks, I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
I am really waiting for it second parts
That is great and thanks so much. Piyush. Please feel free to share the video, so that I will do more multi-part videos (Sometimes people catch the 1st part but miss the 2nd) Thanks again.
@@ExcelForFreelancers Yeah sure I used to share your video to my friends
Hello Mr.Randy i have problem of adding vehicles, excel show me a runtime error '13' could you please help me with it.
thank you.
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 30,000 Members who would love to help you with this. Thanks so much.
Ok.
Thank you so much Mr.Randy
thanks
For sure, you are very welcome
Tracking of expiry dates and reminding before specific dates.
Can this system be created
:)
Hi and yes, thanks so much it can be tracked for sure as well as a reminder. This video on Collections & reminders are a also based on dates to help you with that: th-cam.com/video/0vmtkTBb3j0/w-d-xo.html
Can add the screenshot,
But on the left side under the VBA project... Vehicle List, Exp List, Fuel Log and reminder
Please give me some clue
Thanks
HI and thanks can you please post your question/ issue 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 already submit email for workbook part I, but didnt show up in my email? why?
Hi you may need to check your spam folder. 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.
Dear, how to do VBA Here please do you have any video for this
Hi and thanks very much, 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/VBADiscount_Randy
I need a 20+ list of cars. How do make the list grow accordingly in the vehicle dashboard?
HI and thanks you can download and customize this by updating the named ranges, code and formulas. Please make sure to follow the video. If you need help with this, please post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 50,000 Members who would love to help you with this. Thanks so much.
Please, how to do userform and not directly in the spreadsheet?
HI thanks that is a great question however userforms created with Excel are always depending on Excel. 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 have downloaded your free spreadsheet, thank you; I use Google Sheets and it doesn't seem to be working. Should it work in Google Sheets, pls? Thanks
Hi and thanks so much for your comment. These only work in Excel, as my focus for this channel is Excel and not Google sheets. Thank you for your Likes, Shares & Comments. It really helps.
Hi this video was great
Can I please get a copy of this excel please
Hi Amit, 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.
I want try creating this app, where can i find these icons (car, hammer and spanner etc)?
Hi and thanks for your comment. You ca try any one of these free icon sites
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
@@ExcelForFreelancers appreciated 🙏
Hi sir , can you upload a video how to create a database for medical cabinet and attached document to patent records. I would really appreciate if you can do so , thanks.
HI and thanks I have most of that already in this two-part series: th-cam.com/video/yd2Sn64hhqA/w-d-xo.html
Thank you for your comment.
Excel For Freelancers Hi thanks for your quick reply sir , I remember there was one video where you make it from scratch how to make but I can’t find it anymore . Are those files in excel can be download for learning tutorial ? Please advise thanks
HI thanks i have done nearly 150 videos and applications. Many from scratch so please feel free to search my channel. Every video contains a free download using the links in the description. Thanks again.
Excel For Freelancers I’ll check it out thanks sir .
Can u please make a vedio on Accounting at a automobile service station presentation in Excel ... Please reply fast ..
Hi and thanks so much. I will do my best to have that training added in the near future.
@@ExcelForFreelancers alright
Sir i need this template where can I download it or purchase it
Hi Gilwoode, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hello Sir I have a problem with this one.
Sub Vehicle_AddPic()
Dim GetFile As FileDialog
Set GetFile = Application.FileDialog(msoFileDialogFilePicker)
With GetFile
.Title = "Add Vehicle Pictures"
I'm currently Using my Mac. Care to help me with this? Thanks
Hi Kimberly, 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 50,000 Members who would love to help you with this. Thanks so much.
didnot recive the templet thank you aby how and keep on please
Sorry I recived now as promissed thank you
Great i am glad you got it. Maybe it took a bit of time but glad you were able to get it. Thank you for your Likes, Shares & Comments. It really helps.
Where could I find someone with your skill set to help me create an aircraft maintenance tracker?
HI DeRail, 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.
is this program available for purchase anywhere?
Hi Sterling, you can download this file free using the links in the description above with either your email or Facebook Messenger. However if you would like to support our channel you can get 100, 150 or 175 workbook packs for just 0.37 per template right here: www.excelforfreelancers.com/product/100-of-my-best-excel-workbooks
I hope this helps and thanks.
your god of excel
Thanks so much. :)
@@ExcelForFreelancers i wish i could join the Mentor ship program .
Thanks so much. I really look forward to have you in the program.
Can we also search with Car number?
Hi Mukesh, thanks so much for your comment. This application takes up to 10 car numbers however if you update it, feel free to add a Search as well. 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.
Where do those icons come from? I can't find hardly any.
Hi Tim, thanks so much for your message. You can find the icons I used within the application here:
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
I hope this helps and thanks so much.
Is it only expense tracker or we could add income?
Hi Igbal, thanks very much for your comment. You are welcome to add income as well. Please feel free to download the application using the links in the description.
Thank you so much
Note: "Add Vehicle" button should be placed under the vehicle list, since it names an operation on that list.
Hi Nicadi, thanks so much for the great suggestion. Much appreciated.
@@ExcelForFreelancers Cheers, mate. I love designing GUIs!... ;-)
EDIT: Now I may be pushing it (depending on what functionality your software really aims to deliver - and how far you're really intent on going with it), but... Shouldn't be there a button to delete a vehicle? (Mind you that, in my opinion, the functionality of such a button wouldn't be to wipe out all information for a given vehicle - unless explicitly told to do so - but rather mark it as inactive and move it to an archive of sorts.)
For sure there can be. In fact I am probably think of hundreds of features I would love to add to this. However in a TH-cam video I am limited by time (and viewers patience) so I try to just stick with the main features in order to complete the training in a reasonable amount of time. I always make the applications available for free so that you can add all the features you like. Thanks so much.
Dear Sir,, please you don't have editable Excel for this?
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hello sir,
Plz i want expenses and purchase entry and car delivery list income and expenses and profit&loss account in one book can u provide i want these all in one book
HI thanks for the comment. I am unable to take on any side projects however you are welcome to request a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.
Can we have this sheet for use
Hi, 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.
Dear sir,
i want to buy this excel sheet of fleet management
Hi Saleel, 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.
How much will it cost to have the full version of this Excel programm?
Hi, you can download this file for free using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@@ExcelForFreelancers I mean the completed version which include the part 2
Hi the Part 2 version you can also download using the links in the Part 2 description.
You can find the Part 2 link in the video description. I hope this helps and thanks so much.
I really need those vehicle list, expenses list, fuel log please😢🙏
Hi and thanks so much. You are welcome to download this using the links in the description and customize it however you like. I hope this helps and thanks so much.
I would like to see VIN # and a Year, perhaps Insurance policy #, agency and Phone???
HI and thanks for your comment. Please feel free to download this application using the links in the description and customize it to your exact requirements. Thanks so much.
@@ExcelForFreelancers I tried already one. So far I am still trying but there arr always some bugs😂😂😂
Feel free to upload your bugs with all of the details in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers thanks. Will do!
is it possible to download the file?
Hi, 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.