How To Create A Powerful Point Of Sale (POS) Application In Excel [Full Training & Free Download]
HTML-код
- Опубликовано: 12 июл 2024
- 😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN RUclips MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
Watch a BRAND NEW POS WITH INVENTORY Masterclass Here: • How To Make A Point Of...
In this week’s training, I will show you how to create an amazing Point Of Sale application.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/PointOfSale_Wb
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
3:45 - Worksheet Design
40:13 - Add Item
53:38 - Change Event Worksheet
56:10 - Selection Change Event
1:06:06 - Enter Number Button
1:09:28 - Clear Item Button
1:11:50 - Enter Decimal Button
1:13:19 - Enter Payment Cell
1:15:25 - Enter Pay Type
1:18:30 - Print Receipt
1:28:02 - Save and Clear
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #pos #pointofsale #excelpos
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► rebrand.ly/FreelancersAcademy_YTPinnedCom
Nice one
Just passed by and suddenly hook in. It is a great learning experience, thank you sir for sharing your knowledge.
Looking forward to learn more and apply your how to videos, me instant sub 🙋♂️
Welcome aboard and great to have you. Also check out my newest Touchscreen POS here: ruclips.net/video/1xyvioUP8Ls/видео.html
I am a junior programmer and I didn't even dreamt that you can create something like this in Excel, Jesus Christ 😯
Thanks so much. I hope that my videos and applications inspire you. I am doing a live chat in 13 hours and each Tuesday. Here is the newest one coming soon: ruclips.net/video/iQirWGGck9Q/видео.html
Same! I use to make this using C# or C++
This step-by-step guide to creating a POS application in Excel is fantastic! The detailed instructions and the free downloadable resources make it accessible for everyone to follow along. It's impressive how you break down each step, from formatting to coding, making the complex process easier to understand. Thanks for providing such valuable content, Randy.
Thank you so very much, I really appreciate that
This is absolutely smashing!!
We install retail systems, and this solution of yours deeply demystifies the solution design.
The best 100 minutes that I have spent on RUclips.
Thank you Randy.
Fantastic! Thanks so much Bikash. I am so glad you enjoyed it.
When RUclips feed recommendation work well
I am so glad this has helped. Please make sure to like, share and subscribe so RUclips can suggest more of my videos to you. Much appreciated Q
I know, right?
@@ExcelForFreelancers 123
@@Fuck_Snowflakes
Thanks
U r ryt brother, i love utube suggestion.....😂🙏
I just came across with this video by accident.
I work with excel around 25+ years and I already developed a POS application too with this tool.
In spite of it, you still impressed me with a few techniques that never crossed my mind.
I'm very (gladly) surprised.
You've got a new subscriber.
Thank you so very much, I really appreciate that.
Mr. Austin, this is absolutely amazing! I've followed your whole tutorial and recreated every tiny bit of your program. This is art! Thank you so so much for this incredible training! Please never stop creating these, keep it up! Best regards, Maurice
Thank you so very much, I really appreciate that Maurice
Feel free to check out our other POS here: ruclips.net/video/SbjBgqzbA3w/видео.html
Wes from Kenya,i have followed every step from minute one to 1hour and 39mins and 52sec...i have alot from the Macros and this is a lifetime lesson...next time highlight how to insert picture links...i hustled alot till i made it..Thanks for the knowledge.Much appreciated.
You are very welcome and I am happy to help Wesley. Feel free to download this and customize it however you like. Thanks so much.
Wow. I've taught myself Excel at work and I thought I was pretty good but you have just showed me there is SO much more to learn. 🙂
Thanks so much Jamie, I am very happy I can help and share. Thank you for your Likes, Shares & Comments. It really helps.
I work in the realm of EPOS and this was an excellent tutorial into how things work in the background. Also, before watching this I would have given myself a 7/10 on excel... looks like I need to recalibrate that to a 3/10.. excellent content. Delivered well and better than most of the content available on netflix atm..
Thank you so much. I really appreciate that and I am so glad I can help you with this. Thank you for your Likes, Shares & Comments. It really helps.
Finished the whole video, worth watching and such a great learning experience.
Open Excel and started copying what you are doing step by step, very nice job on this sir.
Thank you so very much, I really appreciate that Katie.
Several years back I took a course of VBA but was not in practice. the way you have taught in this tutorial has given me an intent to update my knowledge of VBA so that I could get max benefit from EXCEL. The time I spent to watch this video was extremely worthwhile. This video actual broaden ones ability to use EXCEL beyond a spreadsheet.
Thank you so very much, I really appreciate that Jamal
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
this has such a finesse. c'mon, it's so great. Shout from Brazil man.
Thanks so much Dan. I really appreciate that. Nice to have you here from Brazil. Thank you.
@@ExcelForFreelancers Bitte
BRASILZÃO COMO SEMPRE REPRESENTANDO, BORAAAAAAAAAAAAAAAAAA
Thank You So Much Sir , Absolutely Perfect Training.
Thank you very much. I do appreciate that Sabeel
This is AWESOME for people like me who doesn't have a background on VBA, I can somehow understand how some of the code works because of the detailed explanation. Keep this up!
Thanks so much I am really glad you enjoyed the training, even without a strong background in VBA I am sure you can learn it very fast.
I've just made this and it works! Thank you so much for the long training! I actually have deep interest in excel, but I just don't know how to add my skill beside making excel formula. Now I think I have the first step to learn further about macro, thank you so much!
Hi Amelia, thanks so much. You are going to love the brand new POS I have coming out this Tuesday. Thanks again.
Heloo can i have your contacts @amelia B
Thank you for the tutor, after watching this video, there is so much more I need to improve and learn. Thumbs up for this video 👍
For sure, you are very welcome. I am happy to help.
Thanks for this awesome exercise✌🏽, I did not think I was going to last an hour and 40 minutes but it’s one of the best learning sessions I’ve had in while. Cheers from Ethiopia
Thank you so much EB, I am so glad you liked the trainings.
Brilliance in action.
Great! I had some minor problems finding the Developer Tab and Selection Pane but once I added them to my tool bar the rest was easy to follow. To be honest, I do not fully understand what was done but with some practice on VBA everything will make more sense. Thank you for this training. It opened my eyes to a huge new area of excel to explore.
For sure, you are very welcome I am happy to help. 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 I will look into it. Excel got exciting again!
Ыобщл8лгтгтр
This is a blessing for me to see great contests like this on RUclips. Keep it up thank you.
Thank you very much Eric. I appreciate that.
Daaaaaaaamn! An hour and 40 minutes! Worth every seconds of it. Just like your every other tutorial man! Learned a bunch from you. Thank you! Keep it up! Love you man!
Awesome, thank you Muhammad. I am glad you enjoyed the training. Much appreciated.
This is one awesome tutorial Randy. Is this something that can be uploaded unto the server and used by multiple people like in shops? ... thank you. You really a genius :-)
Hi Neren, Yes for sure it can. In fact if you use my 'Sharing & Sync' system multiple users around the world can work on this application at the same time. More details on there here: ruclips.net/video/aKV5seZmiBs/видео.html
I'm a programmer and I didn't know excel had such advanced functionalities, I'm impressed! Thank you for sharing
Thanks so much. Excel is very powerful. Have a look at the accounting application I just completed in Excel here: ruclips.net/video/xFH3ozT57yI/видео.html
Wow! great detail, useful finished product that can be modified for different types of applications. New Subscriber... You're one of the very few that responds pleasantly to each comment, Thank you.
Thanks and welcome Paul I really appreciate that.
Ninive... jesus..ket key came able..
I can't imagine we can use ms excel to develop applications for small scale businesses.
You're awesome!
Thank you so very much, I really appreciate that.
@@ExcelForFreelancers I can't see the download link can you send?
Great , a comprehensive lecture of a perfect teacher, very impressive
Many thanks Asad. 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
Great tutorial Sir, followed it and my POS works great. I must say, I had a few hiccups but worked through them. Thanks for the time you put into this. I am about to try and tackle the POS with inventory now. Fun fun !!
For sure, you are very welcome Isha. I am so glad you have enjoyed the training and certainly the POS with Inventory will be fun. Thanks again
Thanks for sharing. I had to watch it in three sessions! :( I am not an expert, just an old retired guy that likes Excel. I like how you incorporated VBA and the various functions. Surprisingly, I followed along and didn't get lost. Very nice training project.
Thanks so much Michael. I am really glad you enjoyed the training. I have many projects that are built from scratch so I hope you check out others. Thanks again.
This is amazing. I almost got everything working 100% except for some reason when I change the qty and price in the system, it won't change on the receipt. Can't find the mistake. But realistically, it's not the end of the world
Hi and thanks so much for your comment. Make sure your formula is correct in the total area. Also please check out the newest Touchscreen POS which automatically updates the total when you select the same item, here: ruclips.net/video/1xyvioUP8Ls/видео.html
Not a waste of time I learn new things again in MS Excel. Thank you so much for the training.
For sure, you are very welcome I am happy to help Janimar
I was passing by and got this amazing resource. Thank you for sharing!
Glad it was helpful! and thanks so much.
Yes, can't wait to learn from this tutorial.
Hope it can track daily sales and monthly sales. hope it can also track inventory level.
From the Screen shot, can only see scan item but not select item and also hope there will be sales return.
Waiting patiently for the this tutorial.
Thanks so much. The application is fully customizable so you can create any type of report based on sales.
I was passing by but i ended up staying the whole vid.
Wow that is great. I know my videos are very long, however since I am creating these applications from a blank sheet, they take a bit longer. I really appreciate that you have enjoyed and stayed for the entire video. Thanks so much.
me too.... being an active wep app dev, i love this tutorial..
exactly.. his explanation was mesmerising
A mind once expanded never returns to its original dimension. Thank you so much for opening this door for me, Randy you are the man Thanks again.
I love that quote Arthur, thanks so much for sharing. I am happy to help and share. I think you will really love the new series I am creating called School Manager series right here: bit.ly/SchoolManagerSeries
Thank you for your Likes, Shares & Comments. It really helps.
Bravo Randy, I love these full length lessons.
Thank you Graham. I am so glad you like it. I know this was a super long one, but I tried my best to move along. I always appreciate your comments and continued support.
Damn best visual excel guy on the internet!
Thanks so much, I really do appreciate that.
Although I don't need the POS functionality I learnt some VBA that I need for other very different areas of work. And thanks for being comprehensive and going in-depth. Good teaching.
For sure, you are very welcome and glad I could help. Thanks again
Amazing work! One of the rare video that I watched completely though its pretty long
Thanks you so much Nitesh. I really appreciate that Nitesh.
I am a programmer and I developed POS in C# / SQL ... but I was amazed in this POS made in excel ...
Thank you so very much, I really appreciate that.
I didn't even knew that exist in Excel Lol😆.
Great Explanation!
Thank you very much. I do appreciate that.
Thank God... Finally I find the teacher now.. how many years I have wasted!!
Very nice teaching...
I made it with two days..
Thank you Sir..
Great job! and thanks so much. I am glad you enjoy the application training.
I am a high school student from Taiwan and this video teach me so well, thanks!
Great and thanks so much. I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.
This has been tremendously helpful! Thank you so much, looking forward to learning more from you! Quick question: if some of the items we have are not taxed, is there an easy way to only apply tax to certain items?
Hi Paul, thanks so much for your comment and I am glad you liked the training. If you add one additional 'taxable' column with a checkbox, you can then use a SumIf along with a helper column for the tax amounts that only sums those rows in which the check box is checked. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers Brilliant!
Thank you very much for this great training. This is my first time to explore macros on Excel. Although it is a bit hard for me to follow but I liked it very much. You actually encouraged me to learn more. I forgot to mention that I am retired and I am 66 years old. Thank you again for the great effort.
Thanks so very much. I am really glad you enjoy the content. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy
You and your loved ones should be blessed for this humanly effort that benefits lot of unknowns in need 🙏 world needs more people like you
Thank you so very much, I really appreciate that :)
What a nice lecture. I enjoyed it so much and watched it until the end.
Thank you for sharing.
Glad you enjoyed it and thanks so much Ojama
I love this video. Please simply forget the length. LOL I would watch it even if it was 10 hours long.
i love the video. this is the very first actual watched from this channel and am hooked to it. WATCHED YOU FROM *GHANA*
Thank you so very much, I really appreciate that and I am so glad you enjoyed it.
just what i was looking for, subscribed, i have feeling alot of your cideos are gonna be usefull, great audio too btw
Thank you so very much, I really appreciate that and happy to have you here. We also have a Facebook support group you may like here: bit.ly/groupexcel
Thank you for your Likes, Shares & Comments. It really helps.
The teacher is very easy to understand. The teacher can guide to implement the number input button instead of typing on the keyboard (to use the touch screen). Thank you teacher!
HI and thanks, Yes i will be having a new POS with Inventory coming next week. I also have this Touchscreen POS training here: ruclips.net/video/1xyvioUP8Ls/видео.html
I hope this helps and thanks so much.
This is awesome work. You really doing a service! Might it be possible for you to create a tutorial about pivot tables? As to data with names and dates can be manipulated to create one click reports.
Thank you again
Hi Ahmed, there are so many tutorials already on pivot tables I probably will not be creating any tutorials on that. You would find hundreds of courses and videos on that already.
Waiting for thissssss.....
Thanks very much Anand :)
Nice to see how Excel can work as POS. I would say this is one great tutorial for excel. But for live system I think it has little use as there are already completely free and opensource POS like Floreant POS or Lemon POS. They are much more powerful and provides database integrity and security.
Thanks for sharing, I am glad you liked the video. The idea of an application like this is the ability to customize it for specific customer requirements as opposed to an over-the-counter solution which cannot be customized. Thank you for your Likes, Shares & Comments. It really helps.
before learning this i hate coading , But now I LOVE for Coading.. Thank you very much sir.., I buld POS System for my own business .. Thank You Again....!!
Thanks so much. I am really glad you enjoyed it and I will make more just like it. Much apprecated.
Hi Sir, you had my 100 percent focus and I really appreciate the detailed and carefully paced training. Thank you from Kenya!
Hi Mohammed, thanks so much. I am very happy you enjoyed the training.
Wow, that was VERY in depth. Thank you for showing us how to do that.
For sure, you are very welcome Lee. I have another POS with Inventory you will also like here: ruclips.net/video/SbjBgqzbA3w/видео.html
This is really the first channel I got excited to subscribe to. you are really amazing in explaining everything clearly, in details and in a wonderful exciting way. thank you so much for all your help and effort.
Thank you so very much, I really appreciate that Said.
@@ExcelForFreelancers it's the truth, you're really teaching in an awsome way. Thank you so much.
You r great. You need to add some features like 1)customer saving amount
2) time
3) date
4) mrp
Hi and thanks there are hundreds of features I would love to add to this however its hard to fit all of those in a single training. You can download this file using the links in the description above with either your email or Facebook Messenger and add any features you make like. I hope this helps and thanks.
I've been following your videos for quite some time. It has helped me a lot with my personal project. Love your great work. One suggestion: It would be really useful if you add some time labels to the video. For example I clicked this video to look how you implemented the print macro. Would be so much easier if you had labelled the timing for that.
Hi and thanks so much Aleksander. I will try to have someone take care of that for me, With 160 videos it would take time for me to do that but its a great idea and will do my best to get it done. Thanks again.
bro you are the best. I've never seen someone teach fast yet easy to understand and delivered in a friendly way. Your way of teaching encourages me to learn more about excel!
Thank you so very much, I really appreciate that Ace. :)
All thumbs up 👍 for the most creative instructor on Earth. Thanks milions for your hard work and strong passion to teach us Randy
Thanks so much Tammy. I always appreciate your kind comments
This is amazing!
Thank you for this priceless tutorial.
Could you do a front desk software for hotel reception?
HI and thanks so much. I do have a hotel application you might like here: ruclips.net/video/ioro9kzW3t8/видео.html
Really nice tutorial, thank you. Just some suggestions: There's some kind of bug about change, in the video you can see (at the very end - 1:39:22) that in the receipt it says "Change 20.". Other Suggestion (this time "functional"): I would save on "Print" and Clear on "next". Saving on Next, you can loose content if you exit after the last customer (without a next). On the other side, you should be sure not to print 2 times the same receipt (or better, not to save same items the second time you print).
Anyway ,really good job man!
Hi Francesco thanks so much for the suggestions. The Change formula was updated after the video was completed. Also there are a TON of features and updates I would love to have done with this application however I have just created the Minimum Viable Product for the video to show it can be done. Feel free to download the application using the links in the description and customize it according to your exact requirements. Thanks so much.
I never thought Excel can be utilized to such purpose. Very creative!
Thank you so very much, I really appreciate that so much.
grate teacher i have met all the time.......about excel...
Thank you so very much, I really appreciate that.
A discount value would be a good thing to include. Also, maybe a list for all the items instead of typing code. But great video
Thanks so much for your suggestion. I appreciate that and will try to add that in the near future. Thank you for your Likes, Shares & Comments. It really helps.
Awesome POS and video! Is there away to add a “charge account” to the POS sheet for customers who have a house/charge account and want to pay at the end of every month?
Hi and thanks so much. Yes you can do this by adding additional recurring payments table. I hope this helps and thanks so much.
As a Web developer it seems to be great that offline application can also be made.
Thank you so much from India.
For sure, you are very welcome I am happy I can help
This is so good. My students in junior high will learn more than enough to pass the exam. Thanks a lot. You are the real professor.
That is so great to hear, I am really happy about that. I think your students will really love my new series right here: 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
@@ExcelForFreelancers thank you.
This is by far the most awesome tutorial I've ever seen. Very detailed and so informative. I only noticed at the end when it is being tested, I think it would be great if the running total is displayed while adding items not only during the time of printing the receipt. Would you consider sharing how to show the running total sir?
HI and thanks so much. On the running total, I just added that and a whole lot more in my newest POS With Inventory here: ruclips.net/video/SbjBgqzbA3w/видео.html
Doesn’t matter what you do in life
Learn MS Excel.
I agree Praveen. Thanks so much.
I never intend to use this information but you sir are a legend. I never knew excel could do this
Thank you so very much, I really appreciate that Hassan
this is actually what I want to learn advance Microsoft excel with applications
thank you so much for this helpful tutorial
Stay blessed and upload new and advance excel applications
For sure, you are very welcome. I am happy to help and share.
Is there a way to combine same items into 1 line. Thank you very much for the video
Hi Ivan, sure there is, You can just run a search using the Find command in VBA, determine the row, and update the existing qty instead of adding a new line. Feel free to download the application and customize it to your requirements. Nice idea and thanks so much.
@@ExcelForFreelancers Thank you for the fast response!
lovely content
Thanks a lot. I do appreciate that and glad you loved the video.
Yes
@@ExcelForFreelancers i am unable to get excel file
Watching this video today on 29th October 2020 and i am speechless. You explained it very well. This is the only video about which i have notany question to ask. I am not good at VB codes but the VB codes you used in this video are just awesome. This video helped me a lot to improve my other sheets. I replaced many long macro with your awesome shorter macro. Thanks a ton for sharing this wonderful content. Stay blessed.
Thanks so much Khalid. I really appreciate that and I am so happy that it has helped you. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Pardon me for this stupid question.
I have prepared the bill for 7 items. The customer is short on cash and the customer wants to drop the item# 2 from the bill. Is there any way to eliminate the item #2 from the receipt.
Your kind guidance in this regard would be highly appreciated.
Edit:- I can simply delete that row for item #2 but it affects the alignment of buttons. I was seeking for a dynamic delete option.
Hi you can clear the items within that row using clearcontents and just move all of the other items up via VBA. 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
Thank you so much for this. I love it from Zimbabwe
For sure, you are very welcome and thanks so much Michael
Thank you, this is awesome. if the user( cashier) made a mistake in qty's for example and after saving( NEXT button), is there any edit button for admin? , is there a button to cancel the order after saving if the customer changes his mind?, as an admin, how to track the canceled orders to Avoid user thefts? additionally, could you add a total of qty's in the sales receipt.. is it possible to change the currency symbol? I recommend you to create an admin control panel for variables such as currency symbol, add a show or hide for any button to make the dashboard less crowded.
Hi Sufian, those are all great ideas and features that would be very helpful. You can download the application and add any features you want or customize this to your own requirements. Thanks so much.
@@ExcelForFreelancers how do i download the application
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.
How do you get the auto complete when typing?
Hi thanks for the great question. I have a complete video on that here: ruclips.net/video/PVEzHbdHf1Y/видео.html
It's worth the watch. This will help me on my store soon. Thank you sir for your generosity. God bless you more❤
For sure, you are very welcome Hazel. I am happy to help.
This is an amazing tutorial, and I just knew that excel can do this. Looking forward to learning more tutorials
Great, thanks so much. I am happy to help and share
Thank you very much for this
But i want to replace the word" tax" with" gst "
How can i?
Hi and thanks Devesh, The workbook is open and not locked. You are welcome to customize it however you like. Please watch the entire training so you can learn how to customize it. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers sir plz send a link to download
Sir i finished this tutorial about two days ago. i would like to know how to save the receipt at 1:26:51 based on the receipt no. in cell M5
Hi and thanks so much. I am glad you enjoyed this training. I will create another in the near future and show you how to save the receipts and look up past receipts. Thank you for your Likes, Shares & Comments. It really helps.
This is my best day i found you as my mentor
Thanks so much. I really appreciate that and glad you found my channel.
Managed to locate the problem Sir. Your procedure of getting the highlighted row on the receipt into cell A6 is indeed working. Cheers
Great Sammy, I am glad you got it working. Thank you for your Likes, Shares & Comments. It really helps.
I couldn't download it. Can you put the download link here?
Hi Asma, If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Run-time-error
.Shapes("ItemPic").Delete
What to do??
the shape may not exists please wrap with error trapping (just as i showed in the video like this)
On Error Resume Next
.Shapes("ItemPic").Delete
On Error Goto 0
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
I'm lovin 'it. I am from Peru and I started to study Excel a lot. Thanks for your class.
Great to hear! I am happy to help and share Klk
This is really amazing. Looks like i still have a lot to learn about excel. I thought i knew excel but with this I think I need to start from basic and I hope your channel has it. Thank for this great video
Thank you so very much, I really appreciate that.
You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy
Hey, I really enjoy your work a ton, but I'm having an issue getting the barcode to appear. I just get a 4 digit number at the bottom of the receipt instead of a bar code, Any suggestions?
Hi and thanks for your comment Nick. Make sure you have a bar code font installed on your machine. Then instead of the standard font for your shape you can change it to the bar code font. 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
=OFFSET(Items!$A$2,1,,COUNTA(Items!$A$2:$A$99999)-1,1) he give me an error why?
Please make sure you have a sheet name called "Items"
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
=DECALER(Items!$A$2;1;;NBVAL(Items!$A$2:$A$99999)-1;1)
I also face the same problem.. Tab out and tab in he said to ensur that data is selected.. What is it?
You are the best teacher of 🌎. Saludos desde ,💛💙❤️
Wow, thank you very much Andres
Excel is always surprising me. I met an architect who did design since the 90's in excel & saw a Japanese man who used Excel to create paintings (google it)!!!
I saw that video too. It was amazing. You should also check out excelunusual.com
Thank you for your Likes, Shares & Comments. It really helps.
तपाईको शिक्षण प्रबिधिलाई सारै मन पर्यो ।तपाईको अलि कति छिटो भासण र माउसको गति छिटो भयर बुज्न थोरै असहज भयो ।जे होसधन्यबाद!🇳🇵🇳🇵🇳🇵🇳🇵
नमस्ते र धेरै धेरै धन्यवाद। मैले नयाँ भिडियोहरूमा ढिलो गर्ने प्रयास गरेको छु र पक्कै पनि, प्रत्येक भिडियोमा सबटाइटलहरू छन्। मलाई आशा छ कि यसले मद्दत गर्दछ र धेरै धेरै धन्यवाद।
@@ExcelForFreelancers धेरै धन्यबाद ! महासय
EXCELLENT video! Thank you for doing this! This is exactly what I’ve been looking for! Now a subscriber and look forward to deep diving into them all!
Glad it was helpful. Thank you very much, I really appreciate that BrewMill Candle Company
Ooh cool, it's always exciting to learn more about and work with POS systems.
Thanks so much. I do appreciate that. :)
Congrates for all those amazine products. I really appreciate your work which is improving myself in Excel coding. A lot of concept and ideas. Thanks a lot and good day from France !
Thank you so very much, I really appreciate that Sebastien :)
WoW this is really awesome perfect for the small businesses ❤️❤️❤️❤️
Thank you so very much, I really appreciate that Larry. Thank you for your Likes, Shares & Comments. It really helps.
Honestly never thought u could do such cool stuff with Excel
Thank you so very much, I really appreciate that.
You are the best teacher. I love you so much
Thank you so very much, I really appreciate that Sychan