How To Make A Point Of Sale (POS) Application With Inventory In Excel [Masterclass & Free Download]

[@ExcelForFreelancers]

🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom

[@wayando]

Thanks for this. I didn't realize Excel could do all this.

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help Huma

[@HoangNguyen_TH]

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!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Hoang. Cam On Ban

[@papnyanamah2748]

Hey Randy, you’re amazingly awesome in Excel. I can’t get tired of watching your KZbin videos. They are incredible. Thanks for the effort 🙏

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Pap :)

[@iloveyou1980]

@@ExcelForFreelancers Please I cannot accept your pay and please help me to download your VBA as free.

[@admalutechnologieszambia2903]

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.

[@ExcelForFreelancers]

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.

[@afamchukwu2997]

pls which of the office did u use I me an office 2016 or what

[@ai_dividend_daily_1]

amazingly awesome in Excel. I can’t get tired of watching your KZbin videos. They are incredible. Thanks for the effort 🙏

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@slminc]

This will add value to something I am working on. The reminder is set already. Powerful creations as always.

[@ExcelForFreelancers]

Thanks so much Sammy. I really appreciate that. Have your coffee ready for this one :)

[@VS-rh8rq]

Tutorial was long but worth while and takes care of practical options Comprehensively Once again thanks

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Vimal

[@coldbluemptybottle]

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.

[@ExcelForFreelancers]

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.

[@Amrgheith2]

@@ExcelForFreelancers man i want to learn a lot from you in 2022. Thanks Merry Christmas and happy new year 💞

[@arlenegriffin4523]

I am new in the Mentorship program and I am really enjoying the training. Thank you Randy

[@ExcelForFreelancers]

Thanks so much Arlene. Great to have you in the program as well. I am glad you are enjoying all the training.

[@justinsmith9878]

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.

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/Z6ncp5ylirVrgtU

[@mokterail123]

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!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Please also check out my Restaurant POS here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU I hope this helps and thanks so much.

[@sevenclipclop]

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.

[@ExcelForFreelancers]

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/

[@rashmimohite1853]

Ggggggggg

[@taimoorkhan8203]

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]

That is great to hear and glad you enjoyed the video.

[@taimoorkhan8203]

@@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....

[@breakingbad582]

I respect your brain. I hats off to you. Big master.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate your continued support. Thank you for your Likes, Shares & Comments. It really helps.

[@yaga7406]

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.

[@ExcelForFreelancers]

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.

[@yaga7406]

@@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

[@yaga7406]

@@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

[@ExcelForFreelancers]

Ok great, glad you found and fixed the issue :) very well done

[@big1975E]

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!!

[@ExcelForFreelancers]

HI and thanks so much. You can combine two of my other applications and videos which contain restaurant and table designs here: kzbin.info/www/bejne/namVg5J-lNKFhZI and here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU I hope this helps. Should you have any additional questions, please do not hesitate to ask.

[@knfer9138]

Thank you for this, Helped me take my Spreadsheets to the next level. Many thanks from South Africa

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@wrsmcode8725]

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

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/b2rbh5WMgqZ1gJI I hope this helps and thanks so much.

[@Oyomikon]

I think setting the file as a template could help, so you have it cleaned up for every month

[@Jojosmith342]

absolutely all thumbs up for the most passionate teacher on the planet earth 👍

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Tammy. So glad you enjoy the training

[@ginodiashantanu]

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

[@ExcelForFreelancers]

Hi Shantanu, thanks for your comment. I have a another video which focuses on Build Of Materials which will help you with this here kzbin.info/www/bejne/mpewlJuDaNiHo5Y I hope this helps and thanks so much.

[@remaraisbrunel5808]

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.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and I can't wait for you to see this application.

[@bricenomiguel4354]

This one will be a home run!

[@ExcelForFreelancers]

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.

[@abs9891]

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.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Each morning I respond to every comment. I am happy to help and share

[@ped2710]

HI Randy, would you able to start a beginners and intermediate series and teach newbies. I know there are so many videos on KZbin but im sure there are so many people including myself who would love to learn it from you.

[@ExcelForFreelancers]

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.

[@prathampatelofficial]

hi

[@BilalAhmed-wc4nl]

wow after 3 month i create & understand this great training.....THANK YOU SIR

[@ExcelForFreelancers]

For sure, you are very welcome, I am so glad I can help. Thank you for your Likes, Shares & Comments. It really helps.

[@thomasamuzu3351]

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?

[@ExcelForFreelancers]

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.

[@officialPGT]

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 ............

[@ExcelForFreelancers]

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.

[@djs2220]

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!

[@ExcelForFreelancers]

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.

[@olafmagri8424]

Thank you for this amazing training and for your kindness, patience and dedication.

[@ExcelForFreelancers]

For sure, you are very welcome. I am happy to help and share :)

[@czechyorker]

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.

[@ExcelForFreelancers]

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.

[@joemanflyer2001]

Great program for any mom n pop …. Better than the first !!

[@ExcelForFreelancers]

Thanks so much Joe. I do appreciate that

[@giovaniaevangelinehalim411]

Hi, do you have an inventory/warehouse management system that also includes expiry dates of product batches?

[@ExcelForFreelancers]

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.

[@marysmith5434]

Tap in on telegram stevescooth0802

[@enamhasan7593]

Create Invoice Online Free Unlimited -> invoicepedia.com

[@tringhi4491]

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!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Cam on ban

[@sandystoo4108]

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

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/oIGqgomLj8uhfq8 I hope this helps and thanks so much.

[@CavalierNSN]

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.

[@ExcelForFreelancers]

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.

[@CavalierNSN]

@@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!)

[@ExcelForFreelancers]

Its no problem, I am happy to help and share CavalierNSN

[@rommelsantiago3219]

Please include the format for receipt printer using 3" paper roll with tax and logo of restaurant.

[@ExcelForFreelancers]

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.

[@ZiaurRahman79]

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.

[@ExcelForFreelancers]

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.

[@WasserTipps]

timestamps would be awesome in your next videos.

[@ExcelForFreelancers]

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.

[@sazibahmed4563]

You are always awesome. I like your every work always. You are a legend. I love you boss. Stay safe and healthy 💖💖💖

[@ExcelForFreelancers]

Thanks so much. I do appreciate that.

[@AlbertKitamirike]

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?

[@ExcelForFreelancers]

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.

[@bengkeltono5575]

Terimakasih atas video nya saya bisa belajar dari video ini bagi2 ilmu bermanfaat sama orang banyak lanjut👍👍👍

[@ExcelForFreelancers]

For sure, you are very welcome, I appreciate that.

[@kuldeepvishwakrma5761]

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 .

[@ExcelForFreelancers]

Hi and thanks very much. I do have another POS version that has a discount option here: kzbin.info/www/bejne/Z6ncp5ylirVrgtU You can also set the currency to anything you like I hope this helps and thanks so much.

[@conversationalai8320]

Have confession that I do appreciate a good jon done in Excel!! Thanks for this vid

[@ExcelForFreelancers]

For sure, you are very welcome and I am so happy I could help.

[@RussellGoura]

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,

[@ExcelForFreelancers]

Hi and thanks so much. Yes certainly. I show you how to sync online orders in this Website Order Sync. training: kzbin.info/www/bejne/m5jdf5ptdrFqq7s I hope this helps and thanks so much.

[@RussellGoura]

@@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

[@RussellGoura]

@@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

[@ExcelForFreelancers]

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.

[@RussellGoura]

@@ExcelForFreelancers thank you boss, appreciate your work 🤝

[@omidkamran6177]

Sir one video for financial services Account payable Wages Food expenses Fuel Accomodations expenses Salary payable Promotion expenses Advance against expenses

[@ExcelForFreelancers]

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? [e-mail] Thanks so much.

[@stanleybenz]

an amazing video and tutorial. Could you make the inventory have a record of stock available in the products sheet for easier reference

[@ExcelForFreelancers]

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? [e-mail] Thanks so much.

[@sergeiwoods1793]

You are a genius you should get a novel or something thank you aloooooooooot man

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Sergei

[@montehilding3677]

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!

[@ExcelForFreelancers]

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.

[@shankarpoudel4526]

In order item remove module " update order Items" there should be "itemrow" in "itemdbrow = .range("h" and selrow). Value" instead of "selrow" and above also so please correct it if any one get error when load order

[@ExcelForFreelancers]

Thanks so much for catching this. I have now updated the download file with this bug corrected. Much appreciated Shankar

[@kentmaxian7139]

Thanks a lot I just want to ask if I want to add category in more than 6 what addtl formula should I add.

[@ExcelForFreelancers]

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.

[@shferaw4471]

I really appreciate your help, thank you very much! In this video how can I get OPEN Total & PAID Total for purchase & Sale Separately?

[@ExcelForFreelancers]

Hi and thanks so much. You can use the SumIf formula based on the status. I hope this helps and thanks so much.

[@HaidarAlsagban]

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?

[@ExcelForFreelancers]

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

[@naisonchapata5855]

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.🙏

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.

[@naisonchapata5855]

@@ExcelForFreelancers thank you so much 🙏

[@nicksonlangat361]

Very interesting and insightful knowledge that add value to the very important need to make powerful use of Excel. Get blessed Sir

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. Thank you for your Likes, Shares & Comments. It really helps.

[@rukevweasiebelaye3164]

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

[@ExcelForFreelancers]

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.

[@dylangamingyt3136]

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!

[@ExcelForFreelancers]

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/

[@dylangamingyt3136]

@@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

[@rjaytermulo3627]

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.

[@ExcelForFreelancers]

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.

[@crustytt5189]

Hi Randy, thanks for your many helped, I'm very appreciate learned from you.

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@chandlerbing8314]

WOW, almost 4 hours, thank you sooooo much!

[@ExcelForFreelancers]

For sure, you are very welcome. This was my longest video :)

[@glennangay-angay5494]

placing the product or reference number in one cell continuously and by pressing enter it will placing in another cell by column down in "how do in excel"

[@ExcelForFreelancers]

HI i am not sure what you mean. Can you please post your detailed question, along with a screenshot, 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.

[@sebastianvazquezcortes430]

Todo el público,necesitamos el servicio de KZbin.qracias.

[@ExcelForFreelancers]

For sure, you are very welcome

[@mrCetus]

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

[@ExcelForFreelancers]

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.

[@toddmaggs9973]

Do you have a video on how to create the admin tab, orders, order items, customers, vendors , products and users?

[@ExcelForFreelancers]

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

[@sukhenduhazra8164]

Stock Inventory management & Billing, Data Save, in other sheet please one more video

[@ExcelForFreelancers]

HI and thanks so much, I will try to add this in the near future. Thank you for your Likes, Shares & Comments. It really helps.

[@bareqdarwish840]

Absolutely Amazing!! I have a suggestion, would it be possible to create vendor database? I searched all over KZbin and nothing interesting is really there. Keep up the fantastic work. Thanks

[@ExcelForFreelancers]

HI and thanks very much. Yes certainly you can. I have something like that in my Purchase Order application: kzbin.info/www/bejne/aXPVpJapetGhbc0

[@bareqdarwish840]

​@@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 :)

[@ExcelForFreelancers]

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.

[@MrAzarice]

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")

[@ExcelForFreelancers]

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.

[@MrAzarice]

@@ExcelForFreelancers Thanks for your answer, it helped a lot !

[@Lifes-a-project]

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

[@ExcelForFreelancers]

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 : kzbin.info/aero/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb I hope this helps and thanks.

[@marioandrescruz]

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.

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/mpewlJuDaNiHo5Y I hope this helps and thanks so much.

[@randysantos5848]

Q: how can we add date of purchase and purchase number for all the products? Co'z we want to make our product to first in first out design.

[@ExcelForFreelancers]

Hi and thanks so much. I have a specific training on that type of inventory (perishable inventory) here kzbin.info/www/bejne/pJqtpJiwZ96ZeZI I hope this helps and thanks so much.

[@SHADOTUBETZ]

Asante sana ( Thank you so much )🇹🇿

[@ExcelForFreelancers]

For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.

[@idrisabubakar4726]

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.

[@ExcelForFreelancers]

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

[@nasercholakkal1258]

It is an excellent program. I got a question, can this program help to print barcode tags?

[@ExcelForFreelancers]

Hi Naser, yes certainly it can. You can use my Label Creator application to help you with that (4 part series) here: kzbin.info/aero/PLIBeRriXvKzA8UaXrndVnM0TyfZ8WHrtu I hope this helps and thanks so much.

[@jhoosa8021]

hi this would be a great help, but wondering is applicable for a pharmacy setting? Thanks 😊

[@ExcelForFreelancers]

Hi Jhoo, yes certainly, you can use this for any type of product. I hope this helps and thanks so much.

[@PaulHBee-dc4kr]

Amazing job! You are truly an expert for excel. Tthank you, Randy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Paul

[@gelwood5601]

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.

[@ExcelForFreelancers]

Hi and thanks very much. I am glad you enjoyed the content. I do have a video on protecting your workbook here: kzbin.info/www/bejne/hImxcmWrrqisgNE I hope this helps and thanks so much.

[@gelwood5601]

@ExcelForFreelancers Absolute legend Randy, thank you very much for the video link and a very quick response, you're a gent!!

[@togrulqasimov640]

Thank you Mr, Randy. Awesome video. Do you have about FEFO , FIFO, video, please share 🙏

[@ExcelForFreelancers]

Hi and thanks so much. Yes i do, you can watch the Inventory Costing Methods training right here: kzbin.info/www/bejne/ZpKyh4toe5d5nM0

[@brenthalbach3645]

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.

[@ExcelForFreelancers]

Hi Brent, thanks so much. I do appreciate that. Concerning adding items on the fly to a list, I cover that in this video kzbin.info/www/bejne/iqC7kpJpfNBjosU I hope this helps and thanks so much.

[@ahmedmkacher4065]

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 ?

[@ExcelForFreelancers]

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

[@mdreviewlk]

Thank you very much sir you are great man ever...❤❤❤Your are amazing work with excel...

[@ExcelForFreelancers]

You are most welcome. Thank you for your Likes, Shares & Comments. It really helps.

[@dariomunoz8804]

Very good.not words.🤩🤩🤩🤩🤩👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼👏🏼💪🏻💪🏻💪🏻💪🏻💪🏻💪🏻🙏🙏🙏🙏🙏

[@nyronbissessar3573]

Good day, I started a small business and need a inventory, POS and Total sales (with Profit) work sheets all linked together like in your videos!!!

[@ExcelForFreelancers]

HI , thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? [e-mail] Thanks so much.

[@thelazymumtv375]

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?

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/a2bcmGyQorF2e9k I hope this helps and thanks so much.

[@xylon24]

Can you make also delivery receipt with logo company and other book is inventory? Thank you

[@ExcelForFreelancers]

HI and thanks for your comment. Please feel free to download this application and customize it however you like by adding your own company logo and inventory.

[@sadifiore1220]

Finally, been a long time coming.... Well done Randy

[@ExcelForFreelancers]

Thanks so much. Yes it took me a while to finally put this one together. I am sure glad I did. Thanks again Anime

[@user-xc5no3ro6z]

Installed, everything works, thanks!

[@ExcelForFreelancers]

Great to hear and Thank you for your Likes, Shares & Comments. It really helps.

[@jesusmesamarquez7252]

Just great!! Congratulations on your master work!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@Chirag429]

Hey thank you for this. When I hit print it prints right away. Is there a way to add away to select different print or print to pdf. Please help

[@ExcelForFreelancers]

HI and thanks for your comment. You can preview any printed image, which will allow you to set the printer, using ActiveSheet.PrintPreview I hope this helps and thanks so much.

[@prathmesh_5103]

Greatest video on the internet

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Prathmesh

[@paulpolizzi3421]

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...

[@ExcelForFreelancers]

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: kzbin.info/www/bejne/mpewlJuDaNiHo5Y

[@infomediaplus87]

Great work sir, thanks for this useful tutorial. I have different number of sub-categories in every column so what i do to add more or hide extra shapes. Please help

[@eityislam3979]

Tnx for watching

[@ExcelForFreelancers]

For sure, you are very welcome and thank you for your Likes, Shares & Comments. It really helps.

[@idrisabubakar4726]

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.

[@ExcelForFreelancers]

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.

[@ayeshivlogs09]

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 ?

[@ExcelForFreelancers]

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.

[@mertkars1463]

which of video that you made it about inventory , product tree are related with sales?

[@ExcelForFreelancers]

Hi and thanks you can check out this video kzbin.info/www/bejne/mpewlJuDaNiHo5Y I hope this helps and thanks so much.

[@sohaibsportstationery2905]

Sir you do everything amazing

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@R00KlE]

So I am following along, great video by the way. I am stuck on one part and google has not been my friend. You state in the video that the Customers Sorted (and Vendors Sorted) is done by a macro that you have, but you never explained it and I am not sure how to get that to work. Can anyone point me in the right direction?

[@ExcelForFreelancers]

HI and thanks so much. You can download this template using the links in the description. Once downloaded, you can open up the VBA editor and look for macros called "Customer_Sort" and "Vendor_Sort" inside the 'Customer_Vendors" Module. I hope this helps and thanks so much.

[@Mac325]

thnx sir for your help im from philippines

[@ExcelForFreelancers]

Happy to help and thanks so much.

[@bananarelaxationmelody4734]

hello i would like to know if this would work for 2 or more devices at the same time and update the system while one changes something?

[@ExcelForFreelancers]

Hi Rana, thanks so much for your comment. Yes, you can share and sync your macro-enabled workbook on multiple devices that run the full version of Excel using this training: kzbin.info/www/bejne/l3y5Zqabj9KceNU I hope this helps and thanks so much.

[@harrylomotey1]

Excellent work with perfect presentation. can do one for a group like club, where they pay in due/contributions and also you pay out some monies to the club members.

[@ExcelForFreelancers]

Hi and thanks. I do have something like that in a Membership application here: kzbin.info/www/bejne/g6fHpWuOmd2UqJY I hope this helps and thanks so much.