Thank you for providing such helpful content. I'm currently working on modifying the template, but I've run into some difficulties. Could you please recommend any specific videos or resources where I can learn more about making modifications? My main issue arises after the 36:18 mark, as the worksheet design includes multiple sheets and I need to delete certain columns in both the customers and suppliers sheets.
Hi and thanks very much. If you delete columns, this requires modifications to the code, formulas, formats and functions across many macros within the code, so there would not be a single video to show you how to do this. You may want to hide the columns. To learn more about VBA I have a beginners series here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z If you would like some help with this, we have a group with 60,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.
I just completed my first week at a new job in the warehouse and the weekly report in nuts. I spent all day cutting a pasting from one work book to another, then adding things up. It's nuts... I feel like I'm wasting so much time doing the same thing over and over. My goal is to somehow automate this report from what I've already put on excel. Wish me luck...
I am sure you are going to do great. If you need help at any time, or jus looking for a straight answer to a question, feel free to join 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.
The power of excel is incredible. I watch excel video for fun. I'm brought here by the curiosity of how we can use Excel to better our inventory & procurement office in our school
Great thanks so much. I am glad you like it. 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
Just love your work. I've downloaded the sheet and started customizing it for our Not For Profit club. Learning a lot as I go along. I'm not sure if it was pointed out previously, but in the version I downloaded the Suppliers kept showing the Customers address. I looked back over the video at 1:42:41 and you have left the E6 and E7 values as Customers.Range instead of Suppliers.Range. Sorry if it has already been picked up. Cheers, Barry from Tassie Australia
Hi Barry, thanks so much. I did see that and fixed the issue, and updated it for downloads. I also made other updates and added features on our Patreon platform update here: www.patreon.com/ExcelForFreelancers Thanks so much for your continued support
Hi @barrtmcki8489. Were you able to modify it for a non profit? can you share amended excel as I need it for a non profit foundation I'm volunteering for? it will be of great help.
hello sir, When I was learning excel, I tried creating a system to take the input of students data and create a profitability chart. Your videos are very inspiring.
Hi and thanks for your comment. I am not sure what you mean by 'all the data that you have put'? The data I use in these templates is just sample data. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi and thanks so much. Yes, in this training I will be designing the worksheet from scratch, during the training, so you can follow along. I hope this helps and thanks so much.
Hi Randy, thank you for the work here. on the Customers sheet, how did you get the asterisks into the criteria tables? and how do you create these criteria tables?
Hi and thanks for your comment. The Asterisk are the wildcard characters used in the advanced filters. So you would manually type them in along with the value of the searched cell. These are common in Advanced filters. I have a training on that here: ruclips.net/video/YuCrEWU2Tm0/видео.html I hope this helps and thanks so much.
I really enjoy the quality of your videos. This is a great system for a small starting out company. I do have a question. In some states there are two different sales taxes, one for groceries, and a second for all other purchases. Have you created a video covering how to apply different sales taxes based on the category of the item? Here in Tennessee we have two different sales tax rates.
HI and thanks very much. If you want to add additional sales tax, you can add one additional row and also one additional tax settings in the Admin screen. I hope this helps and thanks so much.
awesome for excel programmers (or whatever you call them). This is really free training. Grateful for your content. but for people like me, I'd rather buy the finish product :D
Hi and thanks so much. I am glad to help. If you want I can have this customized and secured for you. Please feel free to email your requirements Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
This is AMAZING, super complex but all makes sense. Just a question, I can understand how to get the tables (Orders Purchases, etc) associated to the dashboard, is there another video how to add the tables?
Hi and thanks so much. Yes for sure you can watch this video for tables to dashboard ruclips.net/video/Gs3VZOTEmt4/видео.html I hope this helps and thanks so much.
HI and thanks. Yes. I use AutoHotkey for that. I have a video on there here: ruclips.net/video/gkmiNkbvpkE/видео.html And another one on how to automate typing with an AutoHotkey library coming out in a week
Thank you so very much, I really appreciate that Trang and I am so happy to create them for you. Thank you for your Likes, Shares & Comments. It really helps.
I have enjoyed it following each step but got stuck when it comes to the rules part at 30:44 because there's an error apparently it says it must have a value... but i did enjoy trying to follow the steps. is there any add ons that needs to be added to excel?
Hi and thanks so much. I am glad you enjoyed the training. The formula would be something like this =and($D8"",Mod(Row(),2)=0) Feel free to download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi and thanks so much. I do have a Restaurant Manager here: ruclips.net/video/p_ATIFfsRjU/видео.html I will also do a Produce Management System which will help with date-based Inventory very soon. I hope this helps and thanks so much.
@@ExcelForFreelancers do you have a video that goes over what you were doing or the part where you built that? I'm not familiar with that process. 37:29 shows many formulas. you were showing, for example formula =OFFSET(Customers!$A$3,1,,COUNTA(Customers!$A$3:$A$9998)-1,1) and a column highlighted. I just tried to do it and got errors. I'm stuck at this part
Hi there, Please make sure your sheet name is correct "Customers". 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, thank you for this priceless piece of work. I am currently at 37:30 Please how did you get the Order_ID that match? Though I didnt see you show how you listed those functions in the name manager, i tried it but mine didnt pop up when i typed order_id Please can you show how you created the names in the name manager? Thanks
Hi and thanks, yes i created the order id with a Named range such as =OFFSET(Orders!$A$3,1,,COUNTA(Orders!$A$3:$A$997)-1,1) I cover named ranges in this video: ruclips.net/video/yMz8S5ypBmg/видео.html I hope this helps and thanks so much.
This is my first time studying macros. This is so informative, and it helps me a lot. I hope you can answer what I can do if I need more colums in purchases, sales and products. Upon adding colums on the format itself, what should I do in VBA? Sorry. I'm new to this. (Freshly graduate, colleges don't teach this. 😢) Again thank you so so so much!
HI and thanks for your comment and I am glad you enjoy the training. Any changes to columns or rows will require multiple changes to the VBA Code, functions, formulas and formats so its more than I can answer in a RUclips comment. You may want to check out my Beginners VBA Series here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
Hi and thanks. Can you provide more details of the issue or challenge you are facing since I am not quite sure what the problem is. I hope this helps and thanks so much.
@@ExcelForFreelancers for example like this, I have an item called a motorbike footrest and it has different brands. I want to make the product name in the sales order section management inventory, row 9 column D the product name and in the description I just have to select the brand. Thank you and sorry if my English is still a bit lacking✌️✌️ Update: i did fix the issue, but now im facing a problem with the stock because the product name bassicaly contain a duplicate lolz Update 2: Finally i fix it. Thanks for the Tutorial Man it means a lot
Hi and thanks very much. You will want to create one single product (not multiple) then inside that product you can have a drop down list and select the brand. I hope this helps and thanks so much.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific conditional formatting issue 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 check out this template and training here: ruclips.net/video/CNornJ75mZM/видео.html I hope this helps and thanks so much
I have a question on 1:22:00 when working on the search customer feature. I copied your code for the Product_RefreshList() function and I'm changing the values and columns exactly to fit mine but it is not working I don't know why. The results table isn't changing. It is always empty. I have been trying to fix it for the past 2h and nothing is making sense please I need some help
Hi , Thanks for your comment. Please make sure to double check the Advanced Filter Criteria. 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.
Thanks so much for this video, i am working through it a learning , like really learning.. A quick question, is it possible to link Articles to a Vendor, so when you create a purchase order, only the articles for the specified vendor display on the drop down ?
Hi and thanks so much. Yes for sure it is possible. You can add a 'Preferred Vendor' to a product and then you can run an advanced filter by that vendor. I hope this helps and thanks so much.
This video is amazing. Are you able to integrate a pick slip, packing slip/despatching option where once despatched this reflects it in the stock on hand.??
Hi and thanks. Yes sure, anything is possible. Please feel free to download the free template and customize however you like. If you would like some help with this, we have a group with 60,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.
Let me try this I have found it when searching for an excel sheet that can help me manage my small business. It's really a small shop so I want to try and am sure it will help me even with my accounting and audit
hi I am really happy about your work, Quick question, How can I reduce and add quantity to the product for every purchase and sales i have? so If I purchase items, quantity should add to the product, and if I have sales quantity of the product should be deducted. how can you do it?
Hi and thanks very much. I show you how to do that in my recent Userform Point Of Sale training here: ruclips.net/video/9biCBLwEngM/видео.html I hope this helps and thanks so much.
Thank you so very much, I really appreciate that I do have a VBA for Basic series here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z 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 I hope this helps and thanks so much.
Thanks Randy for that new video, it's awesome what can be done with Excel ! Just a small question, does it work with older Excel versions (2019, 2016,...) ?
Hi and thanks for the Selected Item Row I use the selection change event and I bring over the item ID The row is generated from a formula such as =Iferrror(Match($B$2,Order_ID,0)+3,"") Please update the ranges and check the cells for hte actual formula. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
HI and thanks for your comment. I am glad you were able to get it. 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.
Do I format my own information to suit the tabs regarding customers, products etc? I’m going to do this but there’s a lot of info already on the file. Or is there a previous video I should watch
Hi and thanks very much. You can remove all of the sample data that is on the sheet to begin using it for personal use. Please keep in mind that these are templates and should be customized, secured and updated as per your own requirements. I hope this helps and thanks so much.
Great, thanks so much. I will be doing a lot more from scratch. I will try to keep them not so long, but some will be longer since its from scratch. Thanks for your continued support.
Hey Randy thanks for all of this so glad i found your channel right whn i needed it. So having to ho through a crash course of excel as we lost our guru. These have been awsome to learn new stuff by building. But i have an issue i have not been able to figure out how you did it. Aroun an hour and eight mins into the video you go change all of your tables and update them to not include the column of row to be displayed. There has to be an easy way to do that without messing all of the tables and formats up. I can see removing column adding column reshaping box format can be done for each. I just wondered what approach you did so if i can fix mine i am building step by step. And i can fix in the future if i encounter it again. Thanks
Hi and thanks very much. I am glad you liked the video. Anytime I bring over data from an original table, if i have to edit that data, I generally bring over the database row. I will put that in an adjacent column. To hide this, there are 3 methods. (Hiding the column, matching the font color with the background color, or in this case I used a custom format with either two semicolons ;; if its only numbers, or 3 semicolons ;;; if it is a mix of numbers and letters. This is a custom cell format. Please feel free to download the sample workbook. I hope this helps and thanks so much.
Plz share the accounting in excel template for sales purchases, inventory, p&l, balance sheet, sales and customers reports , item wise date wise sales wise customer wise. Every thing included
Hi and thanks so much. I made all resources, (icons, pictures, and all other items) available every week on our Patreon platform here: Https://www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Thank you for sharing such a great system with a detailed description.. I have two requests:- 1. I am wondering if we can calculate an average cost for the inventory (as purchases amount may change) for each item? 2. Can we add a calculation for the inventory report to calculate reorder stock (if we assume we need 2 months stock for each item - defined with specific quantities according to sales patterns) Thank you again .. your system helped me a lot and just keep me wondering what more support you will provide in your paid website?
Hi and thanks very much. When it comes to calculating the average cost, you can see this training here: ruclips.net/video/0aOVX2F2Ffk/видео.html Also, to determine reordering, I have another video on this here: ruclips.net/video/3BrscsEln7k/видео.html If you would like some help with this, we have a group with 60,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.
Thank you very much for your reply. I tried the system and I faced with 2 issues: 1. As per 1:12:38 there is an issue with the data validation also happens to me how to resolve it?? 2. How to protect the system so no one could change any things especially the IMSGroup, where the blue buttons to be deleted or moved around?? Thank you alot for your knowledge sharing.
Hi Abdel, For the protection options, you can see this video: ruclips.net/video/NXNA2uyCyJo/видео.html As far as the data validation issue, 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.
Great! @@ExcelForFreelancers I just want to know if I build the application and I want to download it to my customer PC! Can I use such application downloader as downloading all codes like an add-in?
Hi and thanks for your question. Yes, you can have your excel application downloaded and include add-ins as well. I hope this helps and thanks so much.
I have a problem about menu button. It only show up if I click purchases button but if I click other than that t doesn't show up just the list only 1:02:04
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 Randy! I really appreciate this video! Unfortunately I'm stuck at the minute 30:44 I literally rewrote the formula =and($D8"",Mod(Row(),2)=0), but it keeps telling me there's a problem. I'm really frustrated and I'm only at the beginning of the video :(. Please I need help because I don't know what I'm doing wrong
HI and thanks for your comment. The formula should be =and($D8"",Mod(Row(),2)=0) However with some language pages it will use a semicolon instead of a comma. I hope this helps and thanks so much.
Hi and thanks very much. I will be creating a new training with this feature in the near future. Thank you for your Likes, Shares & Comments. It really helps.
hello sir this is Abdul Shakoor Hashimi from Kabul Afghanistan, this video is a lot of help to so much people like me, loved this video of yours. I have a small computer business so could you please make an inventory management system for that. it will be so much help from you sir
Hi Randy, your teachings are great however, they are more advanced. I think maybe the missing part of these trainings is only two things otherwise we could have the detailed training. I don't mind if these trainings can take 2 or three hours as long as it is something that someone can follow without asking so many questions and be able to develop something from your programs Here are my Suggestions: 1. Losing the link on the name managers and applying it to the formulars. This is missing more detailed on how it is done and where it is extracting from. This part is very important! 2. Prepopulated the VBA codes. It would be good to start all your codes on the same template you have created from the beginning. We get lost on the middle of the way and we ended up not completing these trainings because you explain code and not making it with us. Unless you have any other class where we can learn this that will be good since we are new babies on these codes. However, the finish products of your work are brilliant always.
HI and thanks so much for your comment and feedback. I do appreciate that. When it comes to basic VBA, each Saturday I create a Basic VBA Training and I have 36 VBA Basic trainings here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z Concerning writing code and design. On any basic template, I can create it from scratch during the video. I have an entire series of 'from scratch' training you may like here: ruclips.net/p/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb Please also keep in mind that the template I use for training is available for free using the link in the description. You may also want to 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
Hi and thanks I added 'Locations' onto my recent Sore Management training on Patreon here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Thanks so much. Yes, and thanks. Excel is more powerful then we realize. Even I am surprised by Excel's power as I stretch its boundaries each week Thank you for your Likes, Shares and comments. It really helps.
thanks. found it. but after copying the data to my own sheets, I found out the name manager isn't displaying like yours in the video. could you shed some light on what I should do right@@ExcelForFreelancers
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific issue you are running into with that named range. 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.
Hola y gracias, esta plantilla es gratuita. Puede descargar este archivo utilizando los enlaces en la descripción debajo de la palabra DESCARGAR. Espero que esto ayude y gracias.
I am trying to help this district hospital create a manageable pharmacy inventory. Love all your tutorials. Trying to work around to create one. ❤❤❤love all your work. Cherrs.
I have a legacy access file from over 11 years ago that everyone uses... and it's slowly lost its functionality over time. Ive spent (to date), 50-60 hrs trying to learn how to fix it and playing with it trying to fix it and have been completely unsuccessful. But im also not versed in vba at all. So im now walking down this road because half the bottlenecks i deal with are vba related, or solved by vba
HI and thanks for your comment. It sounds like a nice project. I am unable to tak on any work, however, If you would like some help with this, we have a group with 60,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.
Thank you so very much, I really appreciate that. I will create a date-based inventory system in the near future that works with produce and milk that have to be sold by a certain date. I hope this helps and thanks so much.
Hi Randy is there a way to view dashboard by a selected month instead of current month by Today()? I thought this would be a good feature to have. Happy New Year 2025!
Hi and thanks very much for your idea. Yes certainly, you can set cells for date, year and month number then create month and year drop down lists. Instead of the current Today() you can point the formulas to the calendar date cell, which change when a month/ year is selected. I hope this helps and thanks so much.
HI and thanks so much. USB Bar Code Readers are simply a keyboard interface and act as keyboard and automatically pressing Enter or Tab. So any field that can be use with a bar code reader. I hope this helps and thanks so much.
Very helpful. I run a small fashion business. And I would like to take stocks with my barcode scanner. How can I include details of each product into the excel system through the barcode scan without manual input
Hi and thanks very much, on the Work Order, Purchase Order or Sales Order items can be entered using a bar code scanner. Thank you for your Likes, Shares & Comments. It really helps.
Your templates are very impressive Pls create an inventory management sheet for construction works... material purchase site wise, credit days and payment dues.
HI and thanks very much. THis template would work quite week for the construction field. I have also added 'Location' as a feature on the updated version shared on my Patreon platform here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Hi and thanks there could have been a temporary issue we were working on however it should be fine. Can you clear your cache and try again or another browser? www.ExcelForFreelancers.com I hope this helps and thanks so much.
For sure, you are very welcome and I am happy to help and share Tobaye. Lots of new tips and tricks in this training. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks very much. Yes I have many. You can search my channel for "Invoice" to find one that fits your requirements. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks so much. You can adapt this training and template to a farm ERP: ruclips.net/video/4_mbTZgfoz0/видео.html I hope this helps and thanks so much.
Do you have any templates or demos on any inventory management/POS excel based systems? Looking to track bulk inventory moving in and out from a warehouse. Would like to have it automatically update the system when removing or adding to the overall inventory. An added plus would be to have barcode scanner capability. Thanks!
HI and thanks so much. I have an entire playlist of POS Systems here: ruclips.net/p/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna I hope this helps and thanks so much.
Thank you sir, could you please create include - Can Selet Dilevery Team - Can Return Invoice - Create Picking list base on Team - Manage Pending invoices
Hi and thanks so much. I have already created an update for this on our Patreon platform here: www.patreon.com/ExcelForFreelancers You are welcome to download and customize this yourself, or get help using a PAID JOB 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.
![How To Create A Powerful Productivity Tracker In Excel [Full Training & Free Download]](http://i.ytimg.com/vi/t5Aucii5200/mqdefault.jpg)
![How To Create A Powerful Productivity Tracker In Excel [Full Training & Free Download]](/img/tr.png)
🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm
This is so detailed, so complex, so... so... fascinating. Thank you. I love it.
Thank you so very much, I really appreciate that and so glad you enjoyed the training
Thanks!
Thank you so very much, I really appreciate that
🤖Speed Up Excel Tasks with AI-Powered Solutions ► bit.ly/AIToolpack_Com
Thank you for providing such helpful content. I'm currently working on modifying the template, but I've run into some difficulties. Could you please recommend any specific videos or resources where I can learn more about making modifications? My main issue arises after the 36:18 mark, as the worksheet design includes multiple sheets and I need to delete certain columns in both the customers and suppliers sheets.
Hi and thanks very much. If you delete columns, this requires modifications to the code, formulas, formats and functions across many macros within the code, so there would not be a single video to show you how to do this. You may want to hide the columns. To learn more about VBA I have a beginners series here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
If you would like some help with this, we have a group with 60,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.
@@ExcelForFreelancers thank you
I just completed my first week at a new job in the warehouse and the weekly report in nuts. I spent all day cutting a pasting from one work book to another, then adding things up. It's nuts... I feel like I'm wasting so much time doing the same thing over and over. My goal is to somehow automate this report from what I've already put on excel. Wish me luck...
I am sure you are going to do great. If you need help at any time, or jus looking for a straight answer to a question, feel free to join 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.
Best of luck Bro..... Can you please update with your story how did you manage all that
Excel is getting more powerful features every day, thanks for the video and sharing!
For sure, you are very welcome and I am happy to help and share
The power of excel is incredible. I watch excel video for fun. I'm brought here by the curiosity of how we can use Excel to better our inventory & procurement office in our school
Great thanks so much. I am glad you like it. 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
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Just love your work. I've downloaded the sheet and started customizing it for our Not For Profit club. Learning a lot as I go along. I'm not sure if it was pointed out previously, but in the version I downloaded the Suppliers kept showing the Customers address. I looked back over the video at 1:42:41 and you have left the E6 and E7 values as Customers.Range instead of Suppliers.Range. Sorry if it has already been picked up. Cheers, Barry from Tassie Australia
Hi Barry, thanks so much. I did see that and fixed the issue, and updated it for downloads. I also made other updates and added features on our Patreon platform update here: www.patreon.com/ExcelForFreelancers
Thanks so much for your continued support
Hi @barrtmcki8489. Were you able to modify it for a non profit? can you share amended excel as I need it for a non profit foundation I'm volunteering for? it will be of great help.
hello sir,
When I was learning excel, I tried creating a system to take the input of students data and create a profitability chart. Your videos are very inspiring.
That's great to hear. Thanks so much for sharing and I am glad you enjoy this training
30:48
Conditional formatting is amazing. 😊
Thanks so much. I use conditional formatting in nearly every application I create. I love it too
Your channel inspired me to be master in excel..👍
WOW! That is great to hear. I really appreciate that and thanks so much
fascinating to see people who know how this works
Great and thanks so much. I am so glad you enjoyed the training
can you please suggest your videos for all the data that you have put, I'm having problem after 35:00 in understanding other sheets workflow.
Hi and thanks for your comment. I am not sure what you mean by 'all the data that you have put'? The data I use in these templates is just sample data. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hey Randy AUSTIN, thanks so much for your mind-blowing tutorials.
You don't know how life-changers your courses are to me !!!!
Thank you so very much, I really appreciate that Keita, I am really happy to help and share
We created a research tool to input recall data and pull a recalled item from the database. This video is brilliant.
Thank you so very much, I really appreciate that :)
Its sounds great! I'm really excited. Pls make this training as much more details as possible. Thks you!
Hi and thanks so much. Yes, in this training I will be designing the worksheet from scratch, during the training, so you can follow along. I hope this helps and thanks so much.
Thank you Randy for sharing this whole new level of awesomeness with us. God Bless you.
Thank you so very much for your continued support Syed :)
کیا اسے ڈاؤن لوڈ کیا جا سکتا ھے؟
جی بالکل کیا جاسکتا ہے۔ آپ کیا کرنا چاہتے ہیں ڈاؤن لوڈ کر کے؟@@saeedahmed1261
Thanks a lot for this simple yet powerful explanatory tutorial
For sure, you are very welcome and I am happy to help and share.
This is great! I was wondering though, is it possible to this in google sheets?
Hi and thanks so much. It may be possible however this workbook uses VBA which is exclusive to Excel.
I hope this helps and thanks so much.
Hi Randy, thank you for the work here. on the Customers sheet, how did you get the asterisks into the criteria tables? and how do you create these criteria tables?
Hi and thanks for your comment. The Asterisk are the wildcard characters used in the advanced filters. So you would manually type them in along with the value of the searched cell. These are common in Advanced filters. I have a training on that here: ruclips.net/video/YuCrEWU2Tm0/видео.html
I hope this helps and thanks so much.
I really enjoy the quality of your videos. This is a great system for a small starting out company. I do have a question. In some states there are two different sales taxes, one for groceries, and a second for all other purchases. Have you created a video covering how to apply different sales taxes based on the category of the item? Here in Tennessee we have two different sales tax rates.
HI and thanks very much. If you want to add additional sales tax, you can add one additional row and also one additional tax settings in the Admin screen. I hope this helps and thanks so much.
I have watched all the ads in your video to repay your generosity to share this video!
Thank you so very much, I really appreciate that. Very kind of you :)
36:19 can someone help me with the offset and counta formula used for creating name ranges? Is it same formula for all the name ranges?
Hi and thanks so much. You can use this formula
=OFFSET(Customers!$A$3,1,,COUNTA(Customers!$A$3:$A$9999)-1,1)
I hope this helps and thanks so much.
awesome for excel programmers (or whatever you call them). This is really free training. Grateful for your content. but for people like me, I'd rather buy the finish product :D
Hi and thanks so much. I am glad to help. If you want I can have this customized and secured for you. Please feel free to email your requirements Randy@ExcelForFreelancers.com
I hope this helps and thanks so much.
This is AMAZING, super complex but all makes sense.
Just a question, I can understand how to get the tables (Orders Purchases, etc) associated to the dashboard, is there another video how to add the tables?
Hi and thanks so much. Yes for sure you can watch this video for tables to dashboard ruclips.net/video/Gs3VZOTEmt4/видео.html
I hope this helps and thanks so much.
30:37 how did you suddenly come to mod(row2), please explain if there is a shotcut
HI and thanks. Yes. I use AutoHotkey for that. I have a video on there here: ruclips.net/video/gkmiNkbvpkE/видео.html
And another one on how to automate typing with an AutoHotkey library coming out in a week
Many thanks for your hard work ! These are actually invaluable assets to have in Excel 💯
Thank you so very much, I really appreciate that Trang and I am so happy to create them for you. Thank you for your Likes, Shares & Comments. It really helps.
I have enjoyed it following each step but got stuck when it comes to the rules part at 30:44 because there's an error apparently it says it must have a value... but i did enjoy trying to follow the steps. is there any add ons that needs to be added to excel?
Hi and thanks so much. I am glad you enjoyed the training. The formula would be something like this
=and($D8"",Mod(Row(),2)=0)
Feel free to download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
The Bob Ross of Excel? 🙂 Awesome stuff
Hahah thanks very much. I have heard that before. I do appreciate it
great tutorial!! i wonder if you gonna do one for food costing for restaurants
Hi and thanks so much. I do have a Restaurant Manager here: ruclips.net/video/p_ATIFfsRjU/видео.html
I will also do a Produce Management System which will help with date-based Inventory very soon.
I hope this helps and thanks so much.
I'm at 37:32 and where can I learn to do this part? Or is this something I have to buy?
Hi and thanks in this time period we are just doing an Index/Match formula. What is your specific question?
@@ExcelForFreelancers do you have a video that goes over what you were doing or the part where you built that? I'm not familiar with that process. 37:29 shows many formulas. you were showing, for example formula =OFFSET(Customers!$A$3,1,,COUNTA(Customers!$A$3:$A$9998)-1,1) and a column highlighted. I just tried to do it and got errors. I'm stuck at this part
Hi there, Please make sure your sheet name is correct "Customers". 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, thank you for this priceless piece of work.
I am currently at 37:30
Please how did you get the Order_ID that match?
Though I didnt see you show how you listed those functions in the name manager, i tried it but mine didnt pop up when i typed order_id
Please can you show how you created the names in the name manager?
Thanks
Hi and thanks, yes i created the order id with a Named range such as
=OFFSET(Orders!$A$3,1,,COUNTA(Orders!$A$3:$A$997)-1,1)
I cover named ranges in this video: ruclips.net/video/yMz8S5ypBmg/видео.html
I hope this helps and thanks so much.
Waiting….
For more.
I can’t find a word to thank you ❤❤❤❤🎉🎉🎉🎉
Great, thanks so much. I am so happy you enjoyed this training. Thank you for your Likes, Shares & Comments. It really helps.
thank you sir from Bangladesh ❤️🇧🇩
For sure, you are very welcome and I am happy to help and share
This is my first time studying macros. This is so informative, and it helps me a lot.
I hope you can answer what I can do if I need more colums in purchases, sales and products. Upon adding colums on the format itself, what should I do in VBA?
Sorry. I'm new to this. (Freshly graduate, colleges don't teach this. 😢)
Again thank you so so so much!
HI and thanks for your comment and I am glad you enjoy the training. Any changes to columns or rows will require multiple changes to the VBA Code, functions, formulas and formats so its more than I can answer in a RUclips comment. You may want to check out my Beginners VBA Series here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
I hope this helps and thanks so much.
@ExcelForFreelancers Thank you for the link!! I will study those first. Thank you so much!! I hope you are blessed with the best things in life!! 🥰
For sure, you are very welcome and happy to help
You just got a subscriber. Thanks for sharing! 🙏
That is great to hear. Thanks so much. I really appreciate that :)
Thanks for the tutorial man, that help me a lot. Quick question, so if got a single type product but the type is different what should i do?
Hi and thanks. Can you provide more details of the issue or challenge you are facing since I am not quite sure what the problem is.
I hope this helps and thanks so much.
@@ExcelForFreelancers for example like this, I have an item called a motorbike footrest and it has different brands. I want to make the product name in the sales order section management inventory, row 9 column D the product name and in the description I just have to select the brand. Thank you and sorry if my English is still a bit lacking✌️✌️
Update: i did fix the issue, but now im facing a problem with the stock because the product name bassicaly contain a duplicate lolz
Update 2: Finally i fix it. Thanks for the Tutorial Man it means a lot
Hi and thanks very much. You will want to create one single product (not multiple) then inside that product you can have a drop down list and select the brand.
I hope this helps and thanks so much.
33:36 when i enter the respectiver number i dont get a selection bar to show up i entered the conditional format 1:1 what could be the issue?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific conditional formatting issue 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 day MR, i need video about time sheet
Hi and thanks very much. You can check out this template and training here: ruclips.net/video/CNornJ75mZM/видео.html
I hope this helps and thanks so much
I have a question on 1:22:00 when working on the search customer feature. I copied your code for the Product_RefreshList() function and I'm changing the values and columns exactly to fit mine but it is not working I don't know why. The results table isn't changing. It is always empty. I have been trying to fix it for the past 2h and nothing is making sense please I need some help
Hi , Thanks for your comment. Please make sure to double check the Advanced Filter Criteria. 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.
Okay I requested to join and will see@@ExcelForFreelancers
Done, I uploaded the screenshots
@@ExcelForFreelancers
Ok very good, thanks so much. I was able to find the solution and point out the issue in our group
Hi, Randy. Hope you the best and thanks a lot for all the efforts you provide.
For sure, you are very welcome and so happy to share this with you. Thank you for your Likes, Shares & Comments. It really helps.
Thanks so much for this video, i am working through it a learning , like really learning.. A quick question, is it possible to link Articles to a Vendor, so when you create a purchase order, only the articles for the specified vendor display on the drop down ?
Hi and thanks so much. Yes for sure it is possible. You can add a 'Preferred Vendor' to a product and then you can run an advanced filter by that vendor.
I hope this helps and thanks so much.
This video is amazing. Are you able to integrate a pick slip, packing slip/despatching option where once despatched this reflects it in the stock on hand.??
Hi and thanks. Yes sure, anything is possible. Please feel free to download the free template and customize however you like. If you would like some help with this, we have a group with 60,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.
Let me try this I have found it when searching for an excel sheet that can help me manage my small business. It's really a small shop so I want to try and am sure it will help me even with my accounting and audit
Thank you so very much, I really appreciate that and I am happy to help and share
hi I am really happy about your work, Quick question, How can I reduce and add quantity to the product for every purchase and sales i have?
so If I purchase items, quantity should add to the product, and if I have sales quantity of the product should be deducted.
how can you do it?
Hi and thanks very much. I show you how to do that in my recent Userform Point Of Sale training here: ruclips.net/video/9biCBLwEngM/видео.html
I hope this helps and thanks so much.
Subscribed though I don't know basics of VBA. You deserve more than like and subscribe. I will come back after learning VBA😢😅
Thank you so very much, I really appreciate that
I do have a VBA for Basic series here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
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
I hope this helps and thanks so much.
Thanks Randy for that new video, it's awesome what can be done with Excel ! Just a small question, does it work with older Excel versions (2019, 2016,...) ?
Hi and thanks so much. Yes for sure, this will work with any version of excel on, or after 2007. I hope this helps and thanks so much.
@@ExcelForFreelancers thanks for your answer ! 👍
Hi, thanks for this video! Which formula do you use for the Item Row in tab Order List?
Hi and thanks for the Selected Item Row I use the selection change event and I bring over the item ID
The row is generated from a formula such as
=Iferrror(Match($B$2,Order_ID,0)+3,"")
Please update the ranges and check the cells for hte actual formula. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hi Randy! Thanks for the IMS template! How to get rid of the pub inside? Thx in advance!
Ok! I got it...
HI and thanks for your comment. I am glad you were able to get it. 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.
You are the Boss!
Thank you so very much, I really appreciate that
Thank you and love you brother from India😊😊😊
For sure, you are very welcome and I am happy to help and share
Do I format my own information to suit the tabs regarding customers, products etc? I’m going to do this but there’s a lot of info already on the file. Or is there a previous video I should watch
Hi and thanks very much. You can remove all of the sample data that is on the sheet to begin using it for personal use. Please keep in mind that these are templates and should be customized, secured and updated as per your own requirements.
I hope this helps and thanks so much.
Liked and subbed man 👍
Thank you so very much, I really appreciate that Michael
Cant thank enough for this, lets hope god pays in u some way as i cant do anything at the moment. Really good one
For sure, you are very welcome and thanks so much. I appreciate it. Thank you for your Likes, Shares & Comments. It really helps.
Now this is what we talking about, 3 days wait seems extremely long
Great, thanks so much. I will be doing a lot more from scratch. I will try to keep them not so long, but some will be longer since its from scratch. Thanks for your continued support.
Is it possible to purchase this IMS?
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Hey Randy thanks for all of this so glad i found your channel right whn i needed it. So having to ho through a crash course of excel as we lost our guru. These have been awsome to learn new stuff by building. But i have an issue i have not been able to figure out how you did it. Aroun an hour and eight mins into the video you go change all of your tables and update them to not include the column of row to be displayed.
There has to be an easy way to do that without messing all of the tables and formats up.
I can see removing column adding column reshaping box format can be done for each. I just wondered what approach you did so if i can fix mine i am building step by step. And i can fix in the future if i encounter it again.
Thanks
Hi and thanks very much. I am glad you liked the video. Anytime I bring over data from an original table, if i have to edit that data, I generally bring over the database row. I will put that in an adjacent column. To hide this, there are 3 methods. (Hiding the column, matching the font color with the background color, or in this case I used a custom format with either two semicolons ;; if its only numbers, or 3 semicolons ;;; if it is a mix of numbers and letters. This is a custom cell format.
Please feel free to download the sample workbook.
I hope this helps and thanks so much.
Thanks for providing the work book.
For sure, you are very welcome and great to have you here
This application is world best…….❤
Thank you so very much, I really appreciate that
Plz share the accounting in excel template for sales purchases, inventory, p&l, balance sheet, sales and customers reports , item wise date wise sales wise customer wise. Every thing included
Hi and thanks, please check out the Ultimate ERP which has almost everything. I hope this helps and thanks so much.
thank you so much, I´am learning many things here...
Can you let available every items you used on this video?
such as background, icones and so on..
Hi and thanks so much. I made all resources, (icons, pictures, and all other items) available every week on our Patreon platform here: Https://www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
You're genius.
Thank you so very much, I really appreciate that . Thank you for your Likes, Shares & Comments. It really helps.
Thank you for sharing such a great system with a detailed description..
I have two requests:-
1. I am wondering if we can calculate an average cost for the inventory (as purchases amount may change) for each item?
2. Can we add a calculation for the inventory report to calculate reorder stock (if we assume we need 2 months stock for each item - defined with specific quantities according to sales patterns)
Thank you again .. your system helped me a lot and just keep me wondering what more support you will provide in your paid website?
Hi and thanks very much. When it comes to calculating the average cost, you can see this training here: ruclips.net/video/0aOVX2F2Ffk/видео.html
Also, to determine reordering, I have another video on this here: ruclips.net/video/3BrscsEln7k/видео.html
If you would like some help with this, we have a group with 60,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.
Thank you very much for your reply.
I tried the system and I faced with 2 issues:
1. As per 1:12:38 there is an issue with the data validation also happens to me how to resolve it??
2. How to protect the system so no one could change any things especially the IMSGroup, where the blue buttons to be deleted or moved around??
Thank you alot for your knowledge sharing.
Hi Abdel, For the protection options, you can see this video: ruclips.net/video/NXNA2uyCyJo/видео.html
As far as the data validation issue, 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.
Great! @@ExcelForFreelancers
I just want to know if I build the application and I want to download it to my customer PC! Can I use such application downloader as downloading all codes like an add-in?
Hi and thanks for your question. Yes, you can have your excel application downloaded and include add-ins as well. I hope this helps and thanks so much.
Thank you for your great tutorials. It is really helpful for us. Much appreciated.
For sure, you are very welcome and I am happy to help and share
I have a problem about menu button. It only show up if I click purchases button but if I click other than that t doesn't show up just the list only 1:02:04
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 Randy! I really appreciate this video!
Unfortunately I'm stuck at the minute 30:44 I literally rewrote the formula =and($D8"",Mod(Row(),2)=0), but it keeps telling me there's a problem. I'm really frustrated and I'm only at the beginning of the video :(. Please I need help because I don't know what I'm doing wrong
HI and thanks for your comment. The formula should be
=and($D8"",Mod(Row(),2)=0)
However with some language pages it will use a semicolon instead of a comma.
I hope this helps and thanks so much.
Could you please demonstrate, what will happen with formating of chart when month and year will change?
Hi and thanks very much. I will be creating a new training with this feature in the near future. Thank you for your Likes, Shares & Comments. It really helps.
hello sir this is Abdul Shakoor Hashimi from Kabul Afghanistan, this video is a lot of help to so much people like me, loved this video of yours.
I have a small computer business so could you please make an inventory management system for that.
it will be so much help from you sir
HI and thanks very much. I do have that already here: ruclips.net/video/dfMchM3sTm4/видео.html
I hope this helps and thanks so much.
Hi Randy, your teachings are great however, they are more advanced. I think maybe the missing part of these trainings is only two things otherwise we could have the detailed training. I don't mind if these trainings can take 2 or three hours as long as it is something that someone can follow without asking so many questions and be able to develop something from your programs
Here are my Suggestions:
1. Losing the link on the name managers and applying it to the formulars. This is missing more detailed on how it is done and where it is extracting from. This part is very important!
2. Prepopulated the VBA codes. It would be good to start all your codes on the same template you have created from the beginning. We get lost on the middle of the way and we ended up not completing these trainings because you explain code and not making it with us. Unless you have any other class where we can learn this that will be good since we are new babies on these codes. However, the finish products of your work are brilliant always.
HI and thanks so much for your comment and feedback. I do appreciate that.
When it comes to basic VBA, each Saturday I create a Basic VBA Training and I have 36 VBA Basic trainings here ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
Concerning writing code and design. On any basic template, I can create it from scratch during the video. I have an entire series of 'from scratch' training you may like here:
ruclips.net/p/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb
Please also keep in mind that the template I use for training is available for free using the link in the description.
You may also want to 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
Can you provide a source for where you got those stock images if possible?
Hi and thanks I create the images with Midjourney: www.midjourney.com
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks it does
Thanks
Thanks teacher ❤
How ca we Get multi warehouse inventory management
Hi and thanks I added 'Locations' onto my recent Sore Management training on Patreon here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Could you add cost tracking when creating a product?
Hi and thanks. You are welcome to download this template and customize it however you like. I hope this helps and thanks so much.
Wow, valuable assets. I didn't know that in excel you could do this big thing. Thanks.
Thanks so much. Yes, and thanks. Excel is more powerful then we realize. Even I am surprised by Excel's power as I stretch its boundaries each week
Thank you for your Likes, Shares and comments. It really helps.
Your skills have the potential to enhance my work significantly.🙂🙏
That is great to hear and I am very happy to help and share
helping with the datasets used for this exercise will be useful. thanks in anticipation admin
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
thanks. found it. but after copying the data to my own sheets, I found out the name manager isn't displaying like yours in the video. could you shed some light on what I should do right@@ExcelForFreelancers
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific issue you are running into with that named range. 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.
Thank you Sir. How to download template 🎉❤
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Buenas, cual es el precio de este archivo?
Hola y gracias, esta plantilla es gratuita. Puede descargar este archivo utilizando los enlaces en la descripción debajo de la palabra DESCARGAR. Espero que esto ayude y gracias.
This guy is a legend 💯🙏
Thank you so very much, I really appreciate that. Very kind of you
I am trying to help this district hospital create a manageable pharmacy inventory. Love all your tutorials. Trying to work around to create one. ❤❤❤love all your work. Cherrs.
HI and thanks so much. Please check out my Pharmacy POS here: ruclips.net/video/lpJ6_ynPuU4/видео.html
I hope this helps and thanks so much.
Great tutorial. Thanks
Thanks so much, I really appreciate that.
U got a sub. Excel and vba is really hard to find decent help with. Thanks
Thank you so very much, I really appreciate that and great to have you here
@@ExcelForFreelancers do you do access/vba? If i had a file and i sent it, could you modify it? Like, as a service?
I have a legacy access file from over 11 years ago that everyone uses... and it's slowly lost its functionality over time. Ive spent (to date), 50-60 hrs trying to learn how to fix it and playing with it trying to fix it and have been completely unsuccessful. But im also not versed in vba at all. So im now walking down this road because half the bottlenecks i deal with are vba related, or solved by vba
HI and thanks for your comment. It sounds like a nice project. I am unable to tak on any work, however, If you would like some help with this, we have a group with 60,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.
Interesting indeed, moving away from Access to Excel is quite a challenging appetite 😊
amazing work Sir 💯
Thank you so very much, I really appreciate that. I will create a date-based inventory system in the near future that works with produce and milk that have to be sold by a certain date. I hope this helps and thanks so much.
Do you you want this
Hi Randy is there a way to view dashboard by a selected month instead of current month by Today()? I thought this would be a good feature to have. Happy New Year 2025!
Hi and thanks very much for your idea. Yes certainly, you can set cells for date, year and month number then create month and year drop down lists. Instead of the current Today() you can point the formulas to the calendar date cell, which change when a month/ year is selected.
I hope this helps and thanks so much.
wow you did hard work, i wish i can know Excel.
For sure you can, thanks so much
looks amazing, eager to learn with this training, notifications On
Thanks so much. I appreciate your continued support. I am sure you will love this one
Great Job Randy. How can I implement a barcode scan function to their whole process.
HI and thanks so much. USB Bar Code Readers are simply a keyboard interface and act as keyboard and automatically pressing Enter or Tab. So any field that can be use with a bar code reader. I hope this helps and thanks so much.
Very helpful. I run a small fashion business. And I would like to take stocks with my barcode scanner. How can I include details of each product into the excel system through the barcode scan without manual input
Hi and thanks very much, on the Work Order, Purchase Order or Sales Order items can be entered using a bar code scanner. Thank you for your Likes, Shares & Comments. It really helps.
Nice 👍👍
Thank you so very much, I really appreciate that Naveed
Thank you for your Likes, Shares & Comments. It really helps.
Your templates are very impressive Pls create an inventory management sheet for construction works... material purchase site wise, credit days and payment dues.
HI and thanks very much. THis template would work quite week for the construction field. I have also added 'Location' as a feature on the updated version shared on my Patreon platform here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Interesting
Hi Randy I love your videos and wanted to go to your website but to no avail i could not is there something wrong please
Hi and thanks there could have been a temporary issue we were working on however it should be fine. Can you clear your cache and try again or another browser?
www.ExcelForFreelancers.com
I hope this helps and thanks so much.
Heeey boss
How do we display the sales and purchases of other months on the dashboard?
Hi and thanks. I added this feature for the Patreon members here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Hi Randy thanks for sharing
For sure, you are very welcome and I am happy to help and share Tobaye. Lots of new tips and tricks in this training. Thank you for your Likes, Shares & Comments. It really helps.
Great job, I enjoyed it👌
Great, thanks so much and I am glad I can help and share
Hi! amazing tutorial, where can i download it from?
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.
Hi, do you also have a sales invoicing management application?
Hi and thanks very much. Yes I have many. You can search my channel for "Invoice" to find one that fits your requirements. Thank you for your Likes, Shares & Comments. It really helps.
Tanks, ye a great inspiration.
For sure, you are very welcome
Great as usual. could you create a farm erp solution?
Hi and thanks so much. You can adapt this training and template to a farm ERP: ruclips.net/video/4_mbTZgfoz0/видео.html
I hope this helps and thanks so much.
Do you have any templates or demos on any inventory management/POS excel based systems? Looking to track bulk inventory moving in and out from a warehouse. Would like to have it automatically update the system when removing or adding to the overall inventory. An added plus would be to have barcode scanner capability. Thanks!
HI and thanks so much. I have an entire playlist of POS Systems here: ruclips.net/p/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna
I hope this helps and thanks so much.
Thanks!
Thank you so very much, I really appreciate that
Thank you sir, could you please create include
- Can Selet Dilevery Team
- Can Return Invoice
- Create Picking list base on Team
- Manage Pending invoices
Hi and thanks so much. I have already created an update for this on our Patreon platform here: www.patreon.com/ExcelForFreelancers
You are welcome to download and customize this yourself, or get help using a PAID JOB 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.