This is greatest content in making app in excel that i have ever seen on youtube so far. This channel deserves million subscribers! Thank you very much for sharing!
I am working on a quarterly Audit reporting program for a non profit organisation and some of the things I learned here will help me alot... cheers....
@@ExcelForFreelancers Since two days, I am working on daily time sheet of auditors and once again this video helped me alot in developing best possible features in the time sheet program... Sir... with due respect I admire your skills....
the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system. Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!
Thank you so very much, I really appreciate that. Please also check out my Restaurant POS here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html I hope this helps and thanks so much.
Finally What i was dreaming has come true...Randy you have done a lot for me...Once upon a time youtube introduced me to Randy and Randy introduced me to Success. Thank you so much sir am short of better words.
That is awesome, thanks so much Admalu. I really do appreciate that and look forward to create many more. Thank you for your Likes, Shares & Comments. It really helps.
wow !!! you are really good ...( map ret tann li kou tè sèk ki bezwen la pli.) i cannot wait to see and learn from your application,..,.. ou fèm fou Excel.( you make me crazy for Excel.
HI and thanks so much. 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 downloaded the workbook-thank you for making this available! Do you have a video that explains how to use the worksheet itself, once it's completed? I watched the video to see how I can change out the product, vendor, etc. information but since it primarily focuses on how to build the worksheet, I'm not sure how to proceed and be able to use the worksheet itself. Thanks again!
Hi and thanks so much. This is the only video I have however I will try to create something in the future on how to use it. Thank you for your Likes, Shares & Comments. It really helps.
This is awesome!! I would like to see this but add a feature to route specific items, once ordered to a kitchen view. Basically I’m thinking of building this for a small restaurant/food truck.
HI Justin, thanks so much. You can combine this with the Restaurant POS that does have a 'kitchen view' for an excellent POS for a restaurant. You can watch that one here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
Thanks a lot this is amazing! i have added a column "Active" in the products page (people managing the product catalog put Y if Active, N if Not)- and added this column to the criteria list. This enables to filter out from the Product choice on POS products that are no longer active or on sale. This also garantees that the old inactive products are still in the products database in order to retrieve orders that included it. Again a big thanks for sharing your knowledge and super useful templates.
Thanks so much for your comment. Adding the active feature is a great idea, since you can still save data for all items, however the list of available/ active items is smaller than the complete list. A great idea no doubt. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hello, there seems to be a bug i cannot explain in that part of the code: Sub Orders_CustomerVendorFilter() POS.Range("D5:F999").ClearContents 'Clear any previous results With Orders .Range("L3").Value = "*" & POS.Range("J3").Value & "*" LastRow = Range("A99999").End(xlUp).Row If LastRow < 3 Then Exit Sub For some reasons, the lastrow found seems to return 20 (i have try it on your original workbook after entering more than 25 order and all customers entered after 20 cannot be found generating a "no results found" message.... weird, any idea what could be causing this? many thanks in advance
@@ExcelForFreelancers Found a way, i reclarified the page before the range: With Orders .Range("L3").Value = "*" & POS.Range("J3").Value & "*" LastRow = Orders.Range("A99999").End(xlUp).Row
Absolutely amazing video as always!! For restaurant applications if this had a customizable dining room layout that would show which tables were occupied, the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system. Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!
HI and thanks so much. You can combine two of my other applications and videos which contain restaurant and table designs here: th-cam.com/video/gx2R_H_mRO0/w-d-xo.html and here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html I hope this helps. Should you have any additional questions, please do not hesitate to ask.
Hi Randy. I love your videos and your techniques on how you approach a problem solving. Your results are absolutely inspiring to me and have helped me many times. However, it would also be interesting to me if there was a "reset button" per Excel folder that would empty the folder contents with one click when a new year, new month, etc. begins. It would also be interesting to know how to create a dynamic invoice with Excel, which can then be printed out for the client. Best regards from Germany, NRW, Joko
Hi and thanks so much. I am really glad you enjoy the training. I do a lot of work with files and folders in my "File Manager" series so you can check that out on my channel. I also have a printable Invoice application and training video right here: th-cam.com/video/99xVbVMABJ0/w-d-xo.html I hope this helps and thanks so much.
Hi Randy... this training was really amazing and helpful. thank you for continuous mentoring. Just want to ask if where can I download this file it will be very big help in my small business. thanks and more power to you.
Hi, you can download this file using the links in the description under the word DOWNLOAD. You can also get this file along with many other POS templates in my 300 workbook download bit.ly/300WkBks_Randy I hope this helps and thanks so much.
Hello Randy, Thanks for the video. Question: Do you have a similar template that can work best for a laundry business? Also, do you do customer templates which may satisfy specific startup business like laundry services?
HI and thanks so much. This application would work great for a laundry business with some small customizations. If you need help with that you can post your requests in 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.
Thank you randy! You have unleashed the power of excel. I missed the premier of this video but this is an absolutely amazing starting point, I'm gonna learn and customize this pos and inventory to my hearts content.
Thanks so much for the training. I was looking for a POS with out monthly Subscription and I came across this 09/02/2024. I will like to know how can I track sale’s monthly? Also will this template be created every month?Does it fit into a Grocery Store? Thanks for your response
Hi and thanks, yes for sure you can track sales or add any reports to this template, even for monthly. If you need help with this, please post a PAID JOB 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 had to deal with a few POS systems. Important for us was always: Import/export Customers and products (including modifiers). Export of sales reports and various sales statistics is a must. When dealing with food very important were food modifiers. If you have a made-to-measure salad it needs a variety of modifiers. Type of salad, Protein selection, dressing selection, vegetable selection, and so on. If you consider a restaurant, you can have eat-in, take-out, and catering orders. All can have different menu items that have the same name but are prepared differently. For example, a Geen salad for a catering order is 6 person minimum and individual order is just one portion. Yet the name is the same. To create the perfect POS is very challenging and it has to be PCI compliant. If you can't charge the c/c directly from the POS application it is kind of pointless to create one in my opinion. But it's a great training topic for sure. Can' wait to see the difference from your previous version.
Very interesting and thanks so much for sharing. So many possibilities with Excel. That is the issue with most developers. We try to create something for everyone and end up either not creating anything at all or creating something for nobody. It is better to create a simple, straight-forward application that is great for some, instead of trying to add every possibility, feature and option to accommodate everyone. Keep It Simple and you will have a huge amount of success.
Hi Randy Hope Fine I saw many videos in excel but I must say you are a genius really or a magician of excel, i also say thanks to you for making a awesome content in excel , Randy please make something for mobile phone business , sale purchase link with auto IMEI number matching with accessories inventory , transfer data to another sheet based on value & print bill when we apply command to print.....Think about it Stay Blessed ............
Thanks so much Shafaq, I really appreciate that. Feel free to download this application, or any of the other POS and customize it however you like, based on your own requirements. I hope this helps and thanks so much.
Great Video very informative…thanks Randy. I was just wondering how to modify the same to use for QSR segment, where based on the recipe the Inventory can be updated….basically in purchase I input the raw material and for sales I input the final item and based on the yield and recipe details inventory position can be derived
Hi Shantanu, thanks for your comment. I have a another video which focuses on Build Of Materials which will help you with this here th-cam.com/video/dfMchM3sTm4/w-d-xo.html I hope this helps and thanks so much.
I enjoyed the training thank you very much Randy. Brilliant excel training. I fell in love with the video when I saw it, I said I would like do develop applications like these with training. I have a question, every time you click on a cell it get's highlighted and shows a green boarder around the cell. I would like to know how I can remove that so that when I click it looks like a plane screen without cells inside. I would like to have a feel of a proper application where no one would guest that it's an excel application. I hope you understood and I hope you will help. Thanks in advance.🙏
Hi and thanks, you would want to click on the View menu then uncheck the gridlines which will remove the grid. You can also add custom backgrounds too. Another option if you would like it to look like an application would be to use a userform. Yesterday I just released a Point Of Sale in a Userform in which I think you would like here: th-cam.com/video/9biCBLwEngM/w-d-xo.html I hope this helps and thanks so much.
HI Randy, would you able to start a beginners and intermediate series and teach newbies. I know there are so many videos on TH-cam but im sure there are so many people including myself who would love to learn it from you.
Hi and thanks so much. Perhaps in the future I will do that, but like you said, so many great teachers are teaching basic and intermediate already. I hope this helps and thanks so much.
sir You are great tutor & your video is really helpful & so easy for beginners Sir I have one quarry there is no discount option If you would make a video on discount option like ( In rupees And In Percentage) choosing option many-many thanks for this .
Hi and thanks very much. I do have another POS version that has a discount option here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html You can also set the currency to anything you like I hope this helps and thanks so much.
Good day, Randy, great training, much appreciate your time and effort, I have a question, how difficult would not be to have two different currency payment USD and Euro which have an exchange rate ar present of 1 USG is 1.17 Euro and have a way of tracking client that has a 30 credit. Thank you
Hi Sandy, thanks so much for your comment. I am glad you liked the training. It would not be very difficult. In fact I have a currency convert training and template in which you can find right here: th-cam.com/video/jPGQVUZfnHM/w-d-xo.html I hope this helps and thanks so much.
Hi Naser, yes certainly it can. You can use my Label Creator application to help you with that (4 part series) here: th-cam.com/play/PLIBeRriXvKzA8UaXrndVnM0TyfZ8WHrtu.html I hope this helps and thanks so much.
Thank you so much. This one is a MUST see as it combines so many great tricks, trips and techniques and rolls them up into an incredible and useful application.
Hi, I love this training and I downloaded this file and made some modifications to fit to my small business. I love that it accommodated my business needs. My problem though is I wanted to convert it to Google Spreedsheets so I can conveniently use it with other devices that do not have excel but it does not function just like the way it did in excel. Is there a way it could be converted to Google spreedsheets?
Hi and thanks very much. Google and Excel are very different platforms with different code. It is much better to have Excel on the other devices or if it is a mobile or tablet you can use my mobile POS training to help you with that here: th-cam.com/video/55yg9ZmLCEw/w-d-xo.html I hope this helps and thanks so much.
Love the training as usual. Would be great to see customer loyalty program as well. 1 point per $ spent (suggestion). Show balance and be able to redeem points toward purchase as a tender. The concept could also be used for electronic gift cards. Thanks for all the hard work that you put into these videos!
Hi Darren, thanks for your comment and suggestion. That is a nice idea. I will add that to my list of possible videos in the near future. You are also free to download this application and customize it however you like.
if I purchase the workbooks off your website, does this include the completed final excel programs? Or do I still have to go thru the process and program the app I want? Interested in the inventory and pos stuff.. I am looking at purchasing the 200 package. please let me know. Thanks
Hi and thanks. These workbooks are the same exact ones in the videos I create. These are templates and not complete applications. I create these in just a few days for training purposes so you would want to customize and secure them for your own requirements, or have a qualified developer take care of that for you. I hope this helps and thanks so much.
HI Albert, thanks so much. Yes certainly the permissions check can be place anywhere as long as no data is updated or added if the user does not have the appropriate permissions. Thank you for your Likes, Shares & Comments. It really helps.
Thank you very much Randy, long training but worth every second!! I made some adjustments to suit my particular case, nothing too drastic, and thought I was almost at the finish line. Now my issue is I don't know how to protect everything from users that could change formats, unhide hidden columns / sheets, view / change code, etc. I love excel, but still have to get to grips with VBA and intend to do your VBA training. I've tried a few pieces of code I found but none worked. I wonder if there is a video or code which could help me? I'm probably not the first person to encounter this issue. Many thanks.
Hi and thanks very much. I am glad you enjoyed the content. I do have a video on protecting your workbook here: th-cam.com/video/NXNA2uyCyJo/w-d-xo.html I hope this helps and thanks so much.
Hi and thanks. You can update the Formulas, Named Ranges and VBA code to add more than 6 categories. Please make sure to watch the entire video to see how to do this. If you run into any issues, please post your screenshot and issue 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.
hi Randy, I'm so glad to see you again with inventory and POS in a single video, one request can add an online order, if we can add a Shipping Button, that can help to add shipping details with advance payment with tracking ID, I think it can add Sale Purchase Button, because Purchase don't need that much, but online order is need everyday, thanks brother,
Hi and thanks so much. Yes certainly. I show you how to sync online orders in this Website Order Sync. training: th-cam.com/video/egzNg7AL7uY/w-d-xo.html I hope this helps and thanks so much.
@@ExcelForFreelancers thank you for your valuable reply, I just ask about add few information on a button, no need other apps, hope you can understand manage each software for each issues
@@ExcelForFreelancers I've a Cycle accessories shop in Bangladesh, I've service center also, i want to make membership with keep clients info for give offer who take parts and service, please add this
Yes for sure. Feel free to download any template and customize this yourself. If you need help with this, please feel free to join my Mentorship course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
Hi the video is too good and what hold me is your approach towards every Comment. I've never seen a youtuber who replies to almost all the queries. You are not only good but "THE BEST". God Bless you.
Instant Sub. I decided to dedicate my Labor Day weekend to your video project and WOOHOO!!! I'm alright with Excel, but I got stumped on one part that now, I think is an error and I'd like to bring it to your attention. At 1:25:41, you began creating a conditional statement base on a variable that, although defined, had not yet been set. Executing the code at this point would not produce the desired effect because there is no "LastResultRow" value (null, right? or just nothing). That aside, this is a true gem and I can't believe work like yours exists in a public forum. Bravo friend, Bravo.
Hi CavalierNSN, 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.
@@ExcelForFreelancers Hello again! Thank you for the reply! I didn't mean to report a bug because I'm not able to download your reference file (long story, not at home, not a lot of space, family everywhere, etc). I like to decompress with thought exercises, and I was so impressed by your video that I decided to just see if I could follow you from a blank workbook as an exercise over the long holiday weekend and I'm a glutton for punishment (lots of pausing... and typing). I got past my issue with raspberry iced tea and by using the "LastRow" formula for the "LastResultRow" variable. From there, I just redirected it to the filtered order results. Boom! I'm back on track. You guys did a great thing here and I'm grateful! So, no issue to report; "LastResultRow" just needed to be set and have a value > 3 to move past 1:25:41. Once again, I can't thank you all enough for this great presentation and sorry for my miscommunication (it's really early in the morning! LOL!)
Hello Thank you so much for this tutorial How I can give each item a quantity of stock so when i add the item to the order list i can increases the quantity until its reach the available stock?
When you select the Purchase option items will be added to stock. When you select Sale option, items will be deducted from the stock> 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
Sir one video for financial services Account payable Wages Food expenses Fuel Accomodations expenses Salary payable Promotion expenses Advance against expenses
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Hey Randy, i always admire your work and just the way you explain things in such a good way is brilliant. One thing though that i'd like mentioning here is that when i was making the POS with inventory while watching this video, i faced a lot of VBA errors while doing so. i just don't know how to fix these bugs. Can you please help me? Hoping to get a reply soon!
Hi Dylan, thanks for your comment and glad you like the training. I have created a Facebook group with 40,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast. Also, if you are new to VBA, 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/
@@ExcelForFreelancers Thanks Randy! my issue got resolved just the way you told me and i have also joined your group. By the way, do we need to 'memorize' the whole code? because for me it's kind of difficult to pick up things a bit faster, I'm 16 years old and i'm also not from this domain. I've recently started these trainings and so far so good but i believe being able to master this thing would take quite a bit of time. Plus being impatient never helps! haha
Love the videos! I’ve already created my POS with excel, however I would love to create something that would automatically take the product, we sold in store off our website instantly! Any recommendations on how I could accomplish that?
Hi and thanks Corey, yes i have some ideas, if your website is Wordpress, through woocommerce API (I am only familiar with those), however you should be able to do that via webhooks and integromat to basically send to your website. I have on my "To Do" list something like that in which the Excel application syncs with your website. I hope to get that done soon. Thanks so much for your following and idea Corey.
Thank you Sir for your training on this interesting topic. I like it. One thing I want to mention here, if I dont have stock in OrderItems or not purchase yet the porduct, It should restrict the sale for those particular Product/s.
Hi and thanks very much. Sure that would be a nice feature to have. Please feel free to download this application and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Great tutorial video for training to show how to "recreate" the POS system was created . I have downloaded source file and have briefly tested. I have a question for you. Can this source code be used ( after own customization) for real life retail shop ?? Appreciate it Thanks
Absolutely Amazing!! I have a suggestion, would it be possible to create vendor database? I searched all over TH-cam and nothing interesting is really there. Keep up the fantastic work. Thanks
@@ExcelForFreelancers Thanks that could work, although it is a different idea. The vendor database/ supplier database will be a combination of multiple videos that you have done. Such as " Excel equipment rental" and "Point of Sale". The idea is to initially have a form to enter, amend, and delete supplier contact details similar to the "equipment rental". Then there is the user-friendly dashboard, which is similar to the icons from "point of sales". So when click for example on "Furniture" all suppliers registered under the furniture category should appear in a list. Because I'm bad at VBA, I was looking forward to learning step by step how to do it from you!! but I will try to replicate your steps and see how it will look like. Thanks again and looking forward for your next video :)
Hi and thanks very much. This would be a large application so you may want to hire a developer to create this for you. Since people do not like or watch the large, multi-part videos i will only do 1 or 2 part videos max in the future. I hope this helps and thanks so much.
Hi Randy, nice applicastion let us say iam interested to buy it since i want to use for my small shop and i have no vba experiance. can i adjust it the way i want without the need for vba?
Hi and thanks so much. Making any changes to this template does require VBA experience, however if you need help with this you can request a PAID JOB 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.
Excelent video! I am using this to manage my entire new food business a restaurant of onigiri products. How can I create a product that when I sell it I can have a recipe modify the quantities of each ingredient in the inventory? I need to sell products made up of small quantities of individual ingredients that I buy and store in inventory.
HI Mario, that makes perfect sense. What you want to do is create a BOM (Bill Of Materials) in which it combines ingredients to make one full part. Then when you sell this full part, it deducts from the individual ingredients. I have a specific training on that here: th-cam.com/video/dfMchM3sTm4/w-d-xo.html I hope this helps and thanks so much.
Hi , Is its possible can we set the discount on quantity based ? forexample if the customer buy 3 coke drink the price is quantity based and if he buy 1 the price is different ?
Hi and thanks for your comment. Yes for sure its possible. It requires a grid to display quantities & prices. I have written your idea down and will try to get to it in an upcoming training. Thank you for your Likes, Shares & Comments. It really helps.
I would really like to learn how to do everything.Is there a full video video of how you set up the other stuff like order items ,products and is the a downloaded I could get instead of doing it all my self
Hi and thanks, you can download this file, or any file from any video, using the links in the description under the word DOWNLOAD. if you want to watch videos in which I start from scratch, feel free to check out my 'From Scratch' playlist here : th-cam.com/play/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb.html I hope this helps and thanks.
with your POS are you able to make one that can take the ingredents away from your inventory as you sell an item? like say a loaf of bread? so it would take flour 1kg,salt15g,yeast50g,etc...
Hi and thanks. Yes the POS with Inventory can do that as well. Also you can consider using a Bill Of Materials for that as seen here: th-cam.com/video/dfMchM3sTm4/w-d-xo.html
Hi Todd, thanks for your message, 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
Amazing thank you so much! Can this be copied from one PC to another. Mine is having problems don't want to loose all inventory and have to start over making this POS from scratch. Hiw do I transfer it to my new pc? Thank you for everything.
Hi and thanks, yes sure it can, you can just copy the file from one computer to another with a USB stick or any other way. All of the data will be transferred as well
Hello, thank you so much for the video, it is so great and I am following it step by step, I had to figure out few things you did not explain in the video ( this is my first time using excel, so I am super beginner, I don't even know the simplest of things ), but there is one thing I still didn't figure out, at 36:00 how did the dollar sign appear automatically when u wrote the price ?
Hi and thanks so much. You can format the cell using with the currency format. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount
Thank you for that wonderful gift you give to the community. You will give huge value to the community, it would be great if the material were free. You'll get more than 77 dollars in return!
HI and thanks Alam. You can use a Sumif formula to sum all sales based on any specific day, where the date is the current date Today() or any other date. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
HI and thanks so much. You can use this application on a desktop computer with Excel, however you can sync it with mobile or tablet using this training: th-cam.com/video/t4PvToFc1OU/w-d-xo.html Thank you for your Likes, Shares & Comments. It really helps.
Hello Randy. I want to point out that stock gets to negative number which in real life doesn't happen. I suggest there should be restriction for example when stock if 0 the program should pop up a message "OUT OF STOCK" and refuse to add product. Thank you for your effort.
Hi Idris, yes that is a great idea. There are so many features i would have loved to add to this template if i had the time. Please feel free to download it and customize it however you like. I hope this helps and thanks so much.
Hi Farhan, 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.
Another great video! I was hopeful that you would get to covering adding items to drop down list on the fly, with pop up form. Do you cover adding items to a drop down list in any of your other videos? I’ve watched all of them I think but don’t recall seeing it.
Hi Brent, thanks so much. I do appreciate that. Concerning adding items on the fly to a list, I cover that in this video th-cam.com/video/ToXa_3Gk0lc/w-d-xo.html I hope this helps and thanks so much.
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. however if you want 200 of my templates you can purchase them from here: www.excelforfreelancers.com/product/200-of-my-best-excel-workbooks
Very nice Tutorial, learnt quite a lot of new stuff here. Thank you very much for this amazing training ! I just have a few questions: I don't quite understand the difference between writting .Range or writting Range And i don't undstand the difference between writting for example : X = Range("A1").value and X = Range("A1")
Hi and thanks for your comment. When writing code on a specific sheet (and not in a module) there is no need to refer to a specific sheet if the sheet you are referring to is the same sheet. For example if you are writing code on sheet1 and referring to sheet1 you can use Range("A1").value = 1 However if you are in a modules and referring to sheet1 then you will want to reference the specific sheet you are working on like this With Sheet1 .Range("A1").value = 1 End with When you want to refer to a specific value in a sheet you will use the ".value" however if you want to refer just to the specific Range you can use Range("A1") 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 hope this helps and thanks so much.
Hello Randy, I hope this message finds you well. I am currently working with a charity as a volunteer and have come across this excellent Excel POS system that I would like to incorporate. However, I was wondering if it would be possible to replace the $ Dollar sign with £ GBP, as we are based in the UK. Thank you very much for your help.
HI and thanks so much. I am glad you enjoyed the training. Yes you can change the currency symbol using Excel's Format Cell option in which you can select any currency. I hope this helps and thanks so much.
Hello Randy I appreciate you for being steadfast in building a generation of professional programmers. I have a like issue with POS with inventory "Advanced filter". I ran into a bug that reads "The extract range has a missing or illegal field name" when I try to load an order using the "order I'd". Please kindly help me out. Thank you Buddy.
Hi Idris, thanks so much, this bug means that either your criteria headers or your results headers do not match the original data or the ranges are incorrect in your VBA code. Please make sure to copy and paste the headers from the original data and also check the code. 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
![Learn How To Create This Amazing Excel Invoice While I Build It From Scratch [Full Training]](http://i.ytimg.com/vi/99xVbVMABJ0/mqdefault.jpg)
![[DRIP] ‘CLIK CLAK’ PREVIEW](http://i.ytimg.com/vi/bcxkcOSbpac/mqdefault.jpg)
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
Hey Randy, you’re amazingly awesome in Excel. I can’t get tired of watching your TH-cam videos. They are incredible. Thanks for the effort 🙏
Thank you so very much, I really appreciate that Pap :)
@@ExcelForFreelancers
Please I cannot accept your pay and please help me to download your VBA as free.
This is greatest content in making app in excel that i have ever seen on youtube so far. This channel deserves million subscribers! Thank you very much for sharing!
Thank you so very much, I really appreciate that Hoang. Cam On Ban
Thanks for this. I didn't realize Excel could do all this.
For sure, you are very welcome and happy to help Huma
Can't you price you enough, amazing as always, a true wizard at this. 🙂
Thank you so very much, I really appreciate that and I am happy to help and share
amazingly awesome in Excel. I can’t get tired of watching your TH-cam videos. They are incredible. Thanks for the effort 🙏
Thank you so very much, I really appreciate that.
I am working on a quarterly Audit reporting program for a non profit organisation and some of the things I learned here will help me alot... cheers....
That is great to hear and glad you enjoyed the video.
@@ExcelForFreelancers Since two days, I am working on daily time sheet of auditors and once again this video helped me alot in developing best possible features in the time sheet program... Sir... with due respect I admire your skills....
This will add value to something I am working on. The reminder is set already. Powerful creations as always.
Thanks so much Sammy. I really appreciate that. Have your coffee ready for this one :)
the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system.
Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!
Thank you so very much, I really appreciate that. Please also check out my Restaurant POS here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
I hope this helps and thanks so much.
Tutorial was long but worth while and takes care of practical options
Comprehensively
Once again thanks
Thank you so very much, I really appreciate that Vimal
I am new in the Mentorship program and I am really enjoying the training. Thank you Randy
Thanks so much Arlene. Great to have you in the program as well. I am glad you are enjoying all the training.
Finally What i was dreaming has come true...Randy you have done a lot for me...Once upon a time youtube introduced me to Randy and Randy introduced me to Success.
Thank you so much sir am short of better words.
That is awesome, thanks so much Admalu. I really do appreciate that and look forward to create many more. Thank you for your Likes, Shares & Comments. It really helps.
pls which of the office did u use I me an office 2016 or what
wow !!! you are really good ...( map ret tann li kou tè sèk ki bezwen la pli.) i cannot wait to see and learn from your application,..,.. ou fèm fou Excel.( you make me crazy for Excel.
Thank you so very much, I really appreciate that and I can't wait for you to see this application.
Sir. I'm new to this channel. There's no doubt that you're an excel expert. Do you have any exercises with answers for beginners?. Thanks.
HI and thanks so much. 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/
Ggggggggg
I downloaded the workbook-thank you for making this available! Do you have a video that explains how to use the worksheet itself, once it's completed? I watched the video to see how I can change out the product, vendor, etc. information but since it primarily focuses on how to build the worksheet, I'm not sure how to proceed and be able to use the worksheet itself. Thanks again!
Hi and thanks so much. This is the only video I have however I will try to create something in the future on how to use it. Thank you for your Likes, Shares & Comments. It really helps.
This is awesome!! I would like to see this but add a feature to route specific items, once ordered to a kitchen view. Basically I’m thinking of building this for a small restaurant/food truck.
HI Justin, thanks so much. You can combine this with the Restaurant POS that does have a 'kitchen view' for an excellent POS for a restaurant. You can watch that one here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
Thank you for this, Helped me take my Spreadsheets to the next level.
Many thanks from South Africa
For sure, you are very welcome and I am happy to help and share
I respect your brain. I hats off to you. Big master.
Thank you so very much, I really appreciate your continued support. Thank you for your Likes, Shares & Comments. It really helps.
Thanks a lot this is amazing!
i have added a column "Active" in the products page (people managing the product catalog put Y if Active, N if Not)- and added this column to the criteria list. This enables to filter out from the Product choice on POS products that are no longer active or on sale. This also garantees that the old inactive products are still in the products database in order to retrieve orders that included it. Again a big thanks for sharing your knowledge and super useful templates.
Thanks so much for your comment. Adding the active feature is a great idea, since you can still save data for all items, however the list of available/ active items is smaller than the complete list. A great idea no doubt. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hello, there seems to be a bug i cannot explain in that part of the code:
Sub Orders_CustomerVendorFilter()
POS.Range("D5:F999").ClearContents 'Clear any previous results
With Orders
.Range("L3").Value = "*" & POS.Range("J3").Value & "*"
LastRow = Range("A99999").End(xlUp).Row
If LastRow < 3 Then Exit Sub
For some reasons, the lastrow found seems to return 20 (i have try it on your original workbook after entering more than 25 order and all customers entered after 20 cannot be found generating a "no results found" message.... weird, any idea what could be causing this? many thanks in advance
@@ExcelForFreelancers Found a way, i reclarified the page before the range:
With Orders
.Range("L3").Value = "*" & POS.Range("J3").Value & "*"
LastRow = Orders.Range("A99999").End(xlUp).Row
Ok great, glad you found and fixed the issue :) very well done
Absolutely amazing video as always!! For restaurant applications if this had a customizable dining room layout that would show which tables were occupied, the start and end times for each customer that sat at them and which tables were available and utilized the drag and drop functionality of one of your previous applications it would have basically everything for a restaurant POS system.
Thank you!! As always you inspire me to push the limits with what I do in Excel every day!!
HI and thanks so much. You can combine two of my other applications and videos which contain restaurant and table designs
here: th-cam.com/video/gx2R_H_mRO0/w-d-xo.html
and here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
I hope this helps. Should you have any additional questions, please do not hesitate to ask.
absolutely all thumbs up for the most passionate teacher on the planet earth 👍
Thank you so very much, I really appreciate that Tammy. So glad you enjoy the training
Hi Randy. I love your videos and your techniques on how you approach a problem solving. Your results are absolutely inspiring to me and have helped me many times.
However, it would also be interesting to me if there was a "reset button" per Excel folder that would empty the folder contents with one click when a new year, new month, etc. begins.
It would also be interesting to know how to create a dynamic invoice with Excel, which can then be printed out for the client.
Best regards from Germany, NRW, Joko
Hi and thanks so much. I am really glad you enjoy the training. I do a lot of work with files and folders in my "File Manager" series so you can check that out on my channel.
I also have a printable Invoice application and training video right here: th-cam.com/video/99xVbVMABJ0/w-d-xo.html
I hope this helps and thanks so much.
I think setting the file as a template could help, so you have it cleaned up for every month
Hi Randy... this training was really amazing and helpful. thank you for continuous mentoring. Just want to ask if where can I download this file it will be very big help in my small business. thanks and more power to you.
Hi, you can download this file using the links in the description under the word DOWNLOAD.
You can also get this file along with many other POS templates in my 300 workbook download bit.ly/300WkBks_Randy
I hope this helps and thanks so much.
Hello Randy, Thanks for the video. Question: Do you have a similar template that can work best for a laundry business? Also, do you do customer templates which may satisfy specific startup business like laundry services?
HI and thanks so much. This application would work great for a laundry business with some small customizations.
If you need help with that you can post your requests in 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.
wow after 3 month i create & understand this great training.....THANK YOU SIR
For sure, you are very welcome, I am so glad I can help. Thank you for your Likes, Shares & Comments. It really helps.
Thank you randy! You have unleashed the power of excel. I missed the premier of this video but this is an absolutely amazing starting point, I'm gonna learn and customize this pos and inventory to my hearts content.
Thanks so much Clei, you are very welcome and I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers man i want to learn a lot from you in 2022. Thanks Merry Christmas and happy new year 💞
Thanks so much for the training. I was looking for a POS with out monthly Subscription and I came across this 09/02/2024. I will like to know how can I track sale’s monthly? Also will this template be created every month?Does it fit into a Grocery Store?
Thanks for your response
Hi and thanks, yes for sure you can track sales or add any reports to this template, even for monthly. If you need help with this, please post a PAID JOB 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 had to deal with a few POS systems. Important for us was always: Import/export Customers and products (including modifiers). Export of sales reports and various sales statistics is a must. When dealing with food very important were food modifiers. If you have a made-to-measure salad it needs a variety of modifiers. Type of salad, Protein selection, dressing selection, vegetable selection, and so on. If you consider a restaurant, you can have eat-in, take-out, and catering orders. All can have different menu items that have the same name but are prepared differently. For example, a Geen salad for a catering order is 6 person minimum and individual order is just one portion. Yet the name is the same. To create the perfect POS is very challenging and it has to be PCI compliant. If you can't charge the c/c directly from the POS application it is kind of pointless to create one in my opinion. But it's a great training topic for sure. Can' wait to see the difference from your previous version.
Very interesting and thanks so much for sharing. So many possibilities with Excel. That is the issue with most developers. We try to create something for everyone and end up either not creating anything at all or creating something for nobody. It is better to create a simple, straight-forward application that is great for some, instead of trying to add every possibility, feature and option to accommodate everyone.
Keep It Simple and you will have a huge amount of success.
Hi Randy Hope Fine
I saw many videos in excel but I must say you are a genius really or a magician of excel, i also say thanks to you for making a awesome content in excel , Randy please make something for mobile phone business , sale purchase link with auto IMEI number matching with accessories inventory , transfer data to another sheet based on value & print bill when we apply command to print.....Think about it
Stay Blessed ............
Thanks so much Shafaq, I really appreciate that. Feel free to download this application, or any of the other POS and customize it however you like, based on your own requirements.
I hope this helps and thanks so much.
Great Video very informative…thanks Randy. I was just wondering how to modify the same to use for QSR segment, where based on the recipe the Inventory can be updated….basically in purchase I input the raw material and for sales I input the final item and based on the yield and recipe details inventory position can be derived
Hi Shantanu, thanks for your comment. I have a another video which focuses on Build Of Materials which will help you with this here th-cam.com/video/dfMchM3sTm4/w-d-xo.html
I hope this helps and thanks so much.
I enjoyed the training thank you very much Randy. Brilliant excel training. I fell in love with the video when I saw it, I said I would like do develop applications like these with training. I have a question, every time you click on a cell it get's highlighted and shows a green boarder around the cell. I would like to know how I can remove that so that when I click it looks like a plane screen without cells inside. I would like to have a feel of a proper application where no one would guest that it's an excel application. I hope you understood and I hope you will help. Thanks in advance.🙏
Hi and thanks, you would want to click on the View menu then uncheck the gridlines which will remove the grid. You can also add custom backgrounds too. Another option if you would like it to look like an application would be to use a userform. Yesterday I just released a Point Of Sale in a Userform in which I think you would like here: th-cam.com/video/9biCBLwEngM/w-d-xo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers thank you so much 🙏
HI Randy, would you able to start a beginners and intermediate series and teach newbies. I know there are so many videos on TH-cam but im sure there are so many people including myself who would love to learn it from you.
Hi and thanks so much. Perhaps in the future I will do that, but like you said, so many great teachers are teaching basic and intermediate already. I hope this helps and thanks so much.
hi
sir You are great tutor & your video is really helpful & so easy for beginners Sir I have one quarry there is no discount option If you would make a video on discount option like ( In rupees And In Percentage) choosing option many-many thanks for this .
Hi and thanks very much. I do have another POS version that has a discount option here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
You can also set the currency to anything you like
I hope this helps and thanks so much.
Good day, Randy, great training, much appreciate your time and effort, I have a question, how difficult would not be to have two different currency payment USD and Euro which have an exchange rate ar present of 1 USG is 1.17 Euro and have a way of tracking client that has a 30 credit. Thank you
Hi Sandy, thanks so much for your comment. I am glad you liked the training. It would not be very difficult. In fact I have a currency convert training and template in which you can find right here: th-cam.com/video/jPGQVUZfnHM/w-d-xo.html
I hope this helps and thanks so much.
Thank you for this amazing training and for your kindness, patience and dedication.
For sure, you are very welcome. I am happy to help and share :)
Hi, do you have an inventory/warehouse management system that also includes expiry dates of product batches?
HI and thanks I do not however you are welcome to download and customize any of my applications for free.
I hope this helps and thanks so much.
Tap in on telegram stevescooth0802
Create Invoice Online Free Unlimited -> invoicepedia.com
It is an excellent program. I got a question, can this program help to print barcode tags?
Hi Naser, yes certainly it can. You can use my Label Creator application to help you with that (4 part series) here: th-cam.com/play/PLIBeRriXvKzA8UaXrndVnM0TyfZ8WHrtu.html
I hope this helps and thanks so much.
This one will be a home run!
Thank you so much. This one is a MUST see as it combines so many great tricks, trips and techniques and rolls them up into an incredible and useful application.
Hi, I love this training and I downloaded this file and made some modifications to fit to my small business. I love that it accommodated my business needs. My problem though is I wanted to convert it to Google Spreedsheets so I can conveniently use it with other devices that do not have excel but it does not function just like the way it did in excel. Is there a way it could be converted to Google spreedsheets?
Hi and thanks very much. Google and Excel are very different platforms with different code. It is much better to have Excel on the other devices or if it is a mobile or tablet you can use my mobile POS training to help you with that here: th-cam.com/video/55yg9ZmLCEw/w-d-xo.html
I hope this helps and thanks so much.
Love the training as usual. Would be great to see customer loyalty program as well. 1 point per $ spent (suggestion). Show balance and be able to redeem points toward purchase as a tender. The concept could also be used for electronic gift cards. Thanks for all the hard work that you put into these videos!
Hi Darren, thanks for your comment and suggestion. That is a nice idea. I will add that to my list of possible videos in the near future. You are also free to download this application and customize it however you like.
if I purchase the workbooks off your website, does this include the completed final excel programs? Or do I still have to go thru the process and program the app I want? Interested in the inventory and pos stuff.. I am looking at purchasing the 200 package. please let me know. Thanks
Hi and thanks. These workbooks are the same exact ones in the videos I create. These are templates and not complete applications. I create these in just a few days for training purposes so you would want to customize and secure them for your own requirements, or have a qualified developer take care of that for you.
I hope this helps and thanks so much.
Another beautiful training Randy. Thank you! In the Order_ItemRemove macro, wouldn't it be better that permissions are checked on the very first line?
HI Albert, thanks so much. Yes certainly the permissions check can be place anywhere as long as no data is updated or added if the user does not have the appropriate permissions.
Thank you for your Likes, Shares & Comments. It really helps.
Thank you very much Randy, long training but worth every second!! I made some adjustments to suit my particular case, nothing too drastic, and thought I was almost at the finish line. Now my issue is I don't know how to protect everything from users that could change formats, unhide hidden columns / sheets, view / change code, etc. I love excel, but still have to get to grips with VBA and intend to do your VBA training. I've tried a few pieces of code I found but none worked. I wonder if there is a video or code which could help me? I'm probably not the first person to encounter this issue. Many thanks.
Hi and thanks very much. I am glad you enjoyed the content. I do have a video on protecting your workbook here: th-cam.com/video/NXNA2uyCyJo/w-d-xo.html
I hope this helps and thanks so much.
@ExcelForFreelancers Absolute legend Randy, thank you very much for the video link and a very quick response, you're a gent!!
Please include the format for receipt printer using 3" paper roll with tax and logo of restaurant.
Hi and thanks very much for your comment. You are welcome to download this and customize it however you like. I hope this helps and thanks so much.
Thanks a lot I just want to ask if I want to add category in more than 6 what addtl formula should I add.
Hi and thanks. You can update the Formulas, Named Ranges and VBA code to add more than 6 categories.
Please make sure to watch the entire video to see how to do this.
If you run into any issues, please post your screenshot and issue 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.
timestamps would be awesome in your next videos.
Thanks very much for the idea. I will try to do that, however it is a considerable more work that is required and only a few people have requested it.
hi Randy, I'm so glad to see you again with inventory and POS in a single video, one request can add an online order, if we can add a Shipping Button, that can help to add shipping details with advance payment with tracking ID, I think it can add Sale Purchase Button, because Purchase don't need that much, but online order is need everyday, thanks brother,
Hi and thanks so much. Yes certainly. I show you how to sync online orders in this Website Order Sync. training: th-cam.com/video/egzNg7AL7uY/w-d-xo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers thank you for your valuable reply, I just ask about add few information on a button, no need other apps, hope you can understand manage each software for each issues
@@ExcelForFreelancers I've a Cycle accessories shop in Bangladesh, I've service center also, i want to make membership with keep clients info for give offer who take parts and service, please add this
Yes for sure. Feel free to download any template and customize this yourself. If you need help with this, please feel free to join my Mentorship course here
www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
I hope this helps and thanks so much.
@@ExcelForFreelancers thank you boss, appreciate your work 🤝
Hi the video is too good and what hold me is your approach towards every Comment. I've never seen a youtuber who replies to almost all the queries. You are not only good but "THE BEST".
God Bless you.
Thank you so very much, I really appreciate that. Each morning I respond to every comment. I am happy to help and share
Instant Sub. I decided to dedicate my Labor Day weekend to your video project and WOOHOO!!! I'm alright with Excel, but I got stumped on one part that now, I think is an error and I'd like to bring it to your attention. At 1:25:41, you began creating a conditional statement base on a variable that, although defined, had not yet been set. Executing the code at this point would not produce the desired effect because there is no "LastResultRow" value (null, right? or just nothing). That aside, this is a true gem and I can't believe work like yours exists in a public forum. Bravo friend, Bravo.
Hi CavalierNSN, 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.
@@ExcelForFreelancers Hello again! Thank you for the reply! I didn't mean to report a bug because I'm not able to download your reference file (long story, not at home, not a lot of space, family everywhere, etc). I like to decompress with thought exercises, and I was so impressed by your video that I decided to just see if I could follow you from a blank workbook as an exercise over the long holiday weekend and I'm a glutton for punishment (lots of pausing... and typing). I got past my issue with raspberry iced tea and by using the "LastRow" formula for the "LastResultRow" variable. From there, I just redirected it to the filtered order results. Boom! I'm back on track. You guys did a great thing here and I'm grateful! So, no issue to report; "LastResultRow" just needed to be set and have a value > 3 to move past 1:25:41. Once again, I can't thank you all enough for this great presentation and sorry for my miscommunication (it's really early in the morning! LOL!)
Its no problem, I am happy to help and share CavalierNSN
Hello
Thank you so much for this tutorial
How I can give each item a quantity of stock so when i add the item to the order list i can increases the quantity until its reach the available stock?
When you select the Purchase option items will be added to stock. When you select Sale option, items will be deducted from the stock>
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 this would be a great help, but wondering is applicable for a pharmacy setting? Thanks 😊
Hi Jhoo, yes certainly, you can use this for any type of product. I hope this helps and thanks so much.
I can buy this exact pos from your website?
What would I need to buy exactly to get this from you? Thanks!
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Sir one video for financial services
Account payable
Wages
Food expenses
Fuel
Accomodations expenses
Salary payable
Promotion expenses
Advance against expenses
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
Great program for any mom n pop …. Better than the first !!
Thanks so much Joe. I do appreciate that
Dude, I need to know which Excel program or how much Windows to use to make the whole software work properly. Please.
I am using Excel 2010. Any version of Excel or Windows should work just fine for the applications I develop. I hope this helps and thanks so much.
an amazing video and tutorial. Could you make the inventory have a record of stock available in the products sheet for easier reference
Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
Just great!! Congratulations on your master work!
Thank you so very much, I really appreciate that
Terimakasih atas video nya saya bisa belajar dari video ini bagi2 ilmu bermanfaat sama orang banyak lanjut👍👍👍
For sure, you are very welcome, I appreciate that.
Hey Randy, i always admire your work and just the way you explain things in such a good way is brilliant. One thing though that i'd like mentioning here is that when i was making the POS with inventory while watching this video, i faced a lot of VBA errors while doing so. i just don't know how to fix these bugs. Can you please help me? Hoping to get a reply soon!
Hi Dylan, thanks for your comment and glad you like the training. I have created a Facebook group with 40,000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
Also, if you are new to VBA, 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/
@@ExcelForFreelancers Thanks Randy! my issue got resolved just the way you told me and i have also joined your group. By the way, do we need to 'memorize' the whole code? because for me it's kind of difficult to pick up things a bit faster, I'm 16 years old and i'm also not from this domain. I've recently started these trainings and so far so good but i believe being able to master this thing would take quite a bit of time. Plus being impatient never helps! haha
I'm learning advanced excel. Your channel helps me a lot. Subscribed! :) Thank you!
Will this also work with Libreoffice Calc?
For sure, you are very welcome and this will work only for Excel. I hope this helps and thanks so much.
Love the videos! I’ve already created my POS with excel, however I would love to create something that would automatically take the product, we sold in store off our website instantly! Any recommendations on how I could accomplish that?
Hi and thanks Corey, yes i have some ideas, if your website is Wordpress, through woocommerce API (I am only familiar with those), however you should be able to do that via webhooks and integromat to basically send to your website. I have on my "To Do" list something like that in which the Excel application syncs with your website. I hope to get that done soon. Thanks so much for your following and idea Corey.
Installed, everything works, thanks!
Great to hear and Thank you for your Likes, Shares & Comments. It really helps.
Thank you Sir for your training on this interesting topic. I like it. One thing I want to mention here, if I dont have stock in OrderItems or not purchase yet the porduct, It should restrict the sale for those particular Product/s.
Hi and thanks very much. Sure that would be a nice feature to have. Please feel free to download this application and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Great tutorial video for training to show how to "recreate" the POS system was created .
I have downloaded source file and have briefly tested.
I have a question for you. Can this source code be used ( after own customization) for real life retail shop ??
Appreciate it
Thanks
Hi and thanks so much. Yes this template can be customized, secured and used as a real-life application. I hope this helps and thanks so much.
Absolutely Amazing!! I have a suggestion, would it be possible to create vendor database? I searched all over TH-cam and nothing interesting is really there. Keep up the fantastic work. Thanks
HI and thanks very much. Yes certainly you can. I have something like that in my Purchase Order application: th-cam.com/video/3BrscsEln7k/w-d-xo.html
@@ExcelForFreelancers Thanks that could work, although it is a different idea. The vendor database/ supplier database will be a combination of multiple videos that you have done. Such as " Excel equipment rental" and "Point of Sale". The idea is to initially have a form to enter, amend, and delete supplier contact details similar to the "equipment rental". Then there is the user-friendly dashboard, which is similar to the icons from "point of sales". So when click for example on "Furniture" all suppliers registered under the furniture category should appear in a list. Because I'm bad at VBA, I was looking forward to learning step by step how to do it from you!! but I will try to replicate your steps and see how it will look like. Thanks again and looking forward for your next video :)
Hi and thanks very much. This would be a large application so you may want to hire a developer to create this for you. Since people do not like or watch the large, multi-part videos i will only do 1 or 2 part videos max in the future.
I hope this helps and thanks so much.
Hi Randy, nice applicastion let us say iam interested to buy it since i want to use for my small shop and i have no vba experiance. can i adjust it the way i want without the need for vba?
Hi and thanks so much. Making any changes to this template does require VBA experience, however if you need help with this you can request a PAID JOB 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.
Excelent video! I am using this to manage my entire new food business a restaurant of onigiri products. How can I create a product that when I sell it I can have a recipe modify the quantities of each ingredient in the inventory? I need to sell products made up of small quantities of individual ingredients that I buy and store in inventory.
HI Mario, that makes perfect sense. What you want to do is create a BOM (Bill Of Materials) in which it combines ingredients to make one full part. Then when you sell this full part, it deducts from the individual ingredients. I have a specific training on that here: th-cam.com/video/dfMchM3sTm4/w-d-xo.html
I hope this helps and thanks so much.
Hi , Is its possible can we set the discount on quantity based ? forexample if the customer buy 3 coke drink the price is quantity based and if he buy 1 the price is different ?
Hi and thanks for your comment. Yes for sure its possible. It requires a grid to display quantities & prices. I have written your idea down and will try to get to it in an upcoming training. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, thanks for your many helped, I'm very appreciate learned from you.
For sure, you are very welcome and I am happy to help and share
I would really like to learn how to do everything.Is there a full video video of how you set up the other stuff like order items ,products and is the a downloaded I could get instead of doing it all my self
Hi and thanks, you can download this file, or any file from any video, using the links in the description under the word DOWNLOAD.
if you want to watch videos in which I start from scratch, feel free to check out my 'From Scratch' playlist here : th-cam.com/play/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb.html
I hope this helps and thanks.
Thank you for your all efforts. Keep it up please 👏
For sure, you are very welcome, I am happy to help and share
im learning a lot on your class!!
Great thanks so much for your comment. I am very happy you are learning so much
with your POS are you able to make one that can take the ingredents away from your inventory as you sell an item? like say a loaf of bread? so it would take flour 1kg,salt15g,yeast50g,etc...
Hi and thanks. Yes the POS with Inventory can do that as well. Also you can consider using a Bill Of Materials for that as seen here: th-cam.com/video/dfMchM3sTm4/w-d-xo.html
Sir you do everything amazing
Thank you so very much, I really appreciate that
Do you have a video on how to create the admin tab, orders, order items, customers, vendors , products and users?
Hi Todd, thanks for your message, 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
Thank you Mr, Randy. Awesome video. Do you have about FEFO , FIFO, video, please share 🙏
Hi and thanks so much. Yes i do, you can watch the Inventory Costing Methods training right here: th-cam.com/video/0aOVX2F2Ffk/w-d-xo.html
I really appreciate your help, thank you very much! In this video how can I get OPEN Total & PAID Total for purchase & Sale Separately?
Hi and thanks so much. You can use the SumIf formula based on the status. I hope this helps and thanks so much.
You are always awesome. I like your every work always. You are a legend.
I love you boss.
Stay safe and healthy 💖💖💖
Thanks so much. I do appreciate that.
Absolutely amazing ❤️❤️❤️
Thank you so very much, I really appreciate that Roy :) :)
Amazing thank you so much! Can this be copied from one PC to another. Mine is having problems don't want to loose all inventory and have to start over making this POS from scratch. Hiw do I transfer it to my new pc? Thank you for everything.
Hi and thanks, yes sure it can, you can just copy the file from one computer to another with a USB stick or any other way. All of the data will be transferred as well
WOW, almost 4 hours, thank you sooooo much!
For sure, you are very welcome. This was my longest video :)
Hello, thank you so much for the video, it is so great and I am following it step by step, I had to figure out few things you did not explain in the video ( this is my first time using excel, so I am super beginner, I don't even know the simplest of things ), but there is one thing I still didn't figure out, at 36:00 how did the dollar sign appear automatically when u wrote the price ?
Hi and thanks so much. You can format the cell using with the currency format. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount
Absolutely amazing advice
Thank you so very much, I really appreciate that Chumki
This is a very good educational video. Is it possible to download a free version of this POS template/code to try out?
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Thank you for that wonderful gift you give to the community. You will give huge value to the community, it would be great if the material were free. You'll get more than 77 dollars in return!
Thank you so very much, I really appreciate that. Cam on ban
Very interesting presentation. Thanks, Randy.
For sure, you are very welcome Michael. I am glad you enjoyed the training. Always nice to see your comments.
Hi sir can I insert end of day to make sure daily sales also separate payment for End of day to find out my exact sales & method?
HI and thanks Alam. You can use a Sumif formula to sum all sales based on any specific day, where the date is the current date Today() or any other date. 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 educative,can this application be used on a tablet or phone?
HI and thanks so much. You can use this application on a desktop computer with Excel, however you can sync it with mobile or tablet using this training: th-cam.com/video/t4PvToFc1OU/w-d-xo.html
Thank you for your Likes, Shares & Comments. It really helps.
Hello Randy. I want to point out that stock gets to negative number which in real life doesn't happen. I suggest there should be restriction for example when stock if 0 the program should pop up a message "OUT OF STOCK" and refuse to add product.
Thank you for your effort.
Hi Idris, yes that is a great idea. There are so many features i would have loved to add to this template if i had the time. Please feel free to download it and customize it however you like. I hope this helps and thanks so much.
Todo el público,necesitamos el servicio de TH-cam.qracias.
For sure, you are very welcome
Thank you so much for your excellent knowledge sharing.
My pleasure and happy to help Yahya
Hello dear, Is it possible to purchase this Inventory system and if yes the please let me know the price.
Hi Farhan, 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.
This is absolutely amazing advice
Thank you so very much, I really appreciate that Mahabub
Another great video! I was hopeful that you would get to covering adding items to drop down list on the fly, with pop up form. Do you cover adding items to a drop down list in any of your other videos? I’ve watched all of them I think but don’t recall seeing it.
Hi Brent, thanks so much. I do appreciate that. Concerning adding items on the fly to a list, I cover that in this video
th-cam.com/video/ToXa_3Gk0lc/w-d-xo.html
I hope this helps and thanks so much.
Hi! I was wondering I got could buy this specific software program.
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.
however if you want 200 of my templates you can purchase them from here: www.excelforfreelancers.com/product/200-of-my-best-excel-workbooks
Absolutely amazing video ❤️❤️❤️
Thank you so much Roy. I am glad you enjoyed it.
Have confession that I do appreciate a good jon done in Excel!! Thanks for this vid
For sure, you are very welcome and I am so happy I could help.
Very nice Tutorial, learnt quite a lot of new stuff here. Thank you very much for this amazing training !
I just have a few questions:
I don't quite understand the difference between writting .Range or writting Range
And i don't undstand the difference between writting for example : X = Range("A1").value and X = Range("A1")
Hi and thanks for your comment. When writing code on a specific sheet (and not in a module) there is no need to refer to a specific sheet if the sheet you are referring to is the same sheet. For example if you are writing code on sheet1 and referring to sheet1 you can use
Range("A1").value = 1
However if you are in a modules and referring to sheet1 then you will want to reference the specific sheet you are working on like this
With Sheet1
.Range("A1").value = 1
End with
When you want to refer to a specific value in a sheet you will use the ".value" however if you want to refer just to the specific Range you can use Range("A1")
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 hope this helps and thanks so much.
@@ExcelForFreelancers Thanks for your answer, it helped a lot !
Hello Randy, I hope this message finds you well. I am currently working with a charity as a volunteer and have come across this excellent Excel POS system that I would like to incorporate. However, I was wondering if it would be possible to replace the $ Dollar sign with £ GBP, as we are based in the UK. Thank you very much for your help.
HI and thanks so much. I am glad you enjoyed the training. Yes you can change the currency symbol using Excel's Format Cell option in which you can select any currency. I hope this helps and thanks so much.
Hello Randy I appreciate you for being steadfast in building a generation of professional programmers.
I have a like issue with POS with inventory "Advanced filter". I ran into a bug that reads "The extract range has a missing or illegal field name" when I try to load an order using the "order I'd". Please kindly help me out.
Thank you Buddy.
Hi Idris, thanks so much, this bug means that either your criteria headers or your results headers do not match the original data or the ranges are incorrect in your VBA code. Please make sure to copy and paste the headers from the original data and also check the code.
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