How to Create A Mobile Barcode Scanning Point Of Sale Application (POS) In Excel [Free Download]

  Рет қаралды 182,858

Excel For Freelancers

Excel For Freelancers

Күн бұрын

Пікірлер: 284
@ExcelForFreelancers
@ExcelForFreelancers 13 күн бұрын
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
@barcodebyte
@barcodebyte 3 жыл бұрын
Awesome tutorial! To everyone who wants to learn more about Output templates shown at 1:37:20 we have a tutorial on the website 😉
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much. Great product indeed.
@bhavesh83740
@bhavesh83740 3 жыл бұрын
Your teaching style of coding in vba is amazing i have learnt lots of even i am not data science background.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much, I am glad i can share and help
@bhavesh83740
@bhavesh83740 3 жыл бұрын
Your Welcome 🙏
@michaelmaharlika8569
@michaelmaharlika8569 3 жыл бұрын
Nice Randy, your new style of presentation, the overall feel of the application is really polished- very cool!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much Michael, I really appreciate that.
@thirdcordtv8516
@thirdcordtv8516 3 жыл бұрын
We can only wait for this awesome session... Thanks Randy
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
I hope you enjoyed it and thanks so much
@sasifexcelsolutions4509
@sasifexcelsolutions4509 3 жыл бұрын
I think we cannot wait more than you do thanks a million, your the best from South Africa
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that Shamiel.
@paulpolizzi3421
@paulpolizzi3421 2 жыл бұрын
Amazing work, didn't know excel could do all this, you are a Master!!!!
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you so very much, I really appreciate that Paul and glad I could help
@WaymakerExcel
@WaymakerExcel 3 жыл бұрын
You're the idea man for the Job.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much and thank you for your Likes, Shares & Comments. It really helps.
@ertugrulguven4965
@ertugrulguven4965 2 ай бұрын
Dear Excel Master. Hello. First of all, I would like to thank you very much for preparing very useful tutorials and wish you continued success. If you don't mind, I would like to ask you questions about the topics I got stuck on while watching. First of all, I could not fully understand how we can change the pictures of the products that appear on the POS work page and the barcode event under the receipt. I would be happy if you could help me with these topics. Thank you.
@ExcelForFreelancers
@ExcelForFreelancers 2 ай бұрын
Hi and thanks so much. For Pictures, please check out my Basic VBA video training on pictures to help you with that kzbin.info/www/bejne/fKW0mGewd7Wpmdk I hope this helps and thanks so much.
@beningmasuud4239
@beningmasuud4239 Жыл бұрын
Thank you so much for this exclusive training, please how did you added the pictures?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks so much. I had a folder full of pictures, and I then mapped the folder, combined with the picture name, to create a full file path. Please make sure to watch the entire training video as I go over the details. I hope this helps and thanks so much.
@paulsimpson6290
@paulsimpson6290 3 жыл бұрын
Love your videos, really show what’s possible with Excel and VBA! One point, though, regarding your thumbnail - I know you mean “Point Of Sale”, but in a lot of places “POS” means something VERY different!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Yes Paul, thanks so much. I am from the USA so I do understand the POS acronym but its not my fault that POS is also a very popular acronym for Point Of Sale, so people are searching for it and I have to use it. Trust me its a great application and not a POS :) :)
@paulsimpson6290
@paulsimpson6290 3 жыл бұрын
@@ExcelForFreelancers I completely understand that you have to work with SEO, so Tags, Titles and Descriptions are super-important. I'm specifically referring to the thumbnail (graphic) which is mainly what people see and won't be involved in any algorithms. BTW, my comment was at least part tongue-in-cheek, but figured you might want to evaluate the thumbnail image. If I thought this, I'm sure others did too! Keep up the good work!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Hi Paul good point. We could spell it out on the thumbnail. I will have this changed. Thanks again.
@luci0006
@luci0006 3 жыл бұрын
Dude thats exactly what I was searching for
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Great, I am happy I could help and share.
@imso-xD
@imso-xD 3 жыл бұрын
sir you are an outstanding mentor and for the thanks I subscribed your channel
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks and welcome to the channel. Much apprecated.
@ants8639
@ants8639 3 жыл бұрын
Looks awesome. Will it allow double scans or mistakes to be removed or editable?
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Yes certainly you can remove and edit scans. I am sure you will enjoy the training.
@Unique_Entertainment
@Unique_Entertainment 3 жыл бұрын
Can you do a separate video explaining your journey as to how you became a world class expert in excel which is such a amazing talent.👌🙌
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Hi and thanks so much. I have a lot of that on my website in my Thursday Thoughts here: www.excelforfreelancers.com/category/thursday-thoughts/
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 3 жыл бұрын
Impressive work Randy. Thank you very much for this beautiful tutorial.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much Syed, I always appreciate that.
@mdyounus1698
@mdyounus1698 3 жыл бұрын
Beautiful
@abdiwaliadam6837
@abdiwaliadam6837 3 жыл бұрын
Wow 😱 I can't wait this lesson teacher thanks full
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much. I hope you enjoyed it
@travelwithudeshi
@travelwithudeshi 3 жыл бұрын
🔥 great booster!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@HybridSupport
@HybridSupport 4 ай бұрын
How can we add inventory management with this to check if there are still stocks left and will notify or not proceed checkout if out of stock?
@ExcelForFreelancers
@ExcelForFreelancers 4 ай бұрын
Hi and thanks so much for your comment. You can find that inventory management solution here: kzbin.info/www/bejne/g5mclHuljcZ1q8k
@Mohammed-zq1cm
@Mohammed-zq1cm Жыл бұрын
great tutorial, Is it possible however to add an inventory sheet to this?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi Mohammed, yes certainly it is possible. I have many trainings on Inventory. You are welcome to download and customize this however you like. Thank you for your Likes, Shares & Comments. It really helps.
@vyle-tt
@vyle-tt 3 жыл бұрын
OMG you are so amazing. Can't wait!!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that. Cam on ban Vy :)
@fireskycam9889
@fireskycam9889 3 жыл бұрын
Great clip. I noticed you spelt Olive Oil with two "LL"s in Olive. Hehehehe. I'm looking at purchasing your 200 package. I like these.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that. During the video I corrected that spelling, so feel free to watch it :)
@ddo_industrial
@ddo_industrial 2 жыл бұрын
Hey Randy just and ongoing question i keep asking myself, what version of excel are you using because my excel looks diferent, I know it wouldnt matter but I would find it easier so I can follow you exactly. Keep up the great work you are so inspiring :)
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi Sam, Thanks for your comment. I am using Excel 2010, purposely to show people that these applications can be built with nearly any version of Excel. I have the newest version and may use that in the future soon, but just want to make sure that I don't use any feature that are only exclusive to new versions.
@ddo_industrial
@ddo_industrial 2 жыл бұрын
@@ExcelForFreelancers Thank you so much this really will help :)
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
For sure, you are very welcome
@Samy-Makram
@Samy-Makram Жыл бұрын
Thank you so much i need to protect sheet can we make this ?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much. For sure you can protect it. I show you how to do this in this training here: kzbin.info/www/bejne/hImxcmWrrqisgNE I hope this helps and thanks so much.
@raymondokorodudu8884
@raymondokorodudu8884 6 ай бұрын
MR Randy fantastic video training ,i must confess but why is mobile barcode scanning pos not opening or playing for sometime now please talk to me
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@czechyorker
@czechyorker 3 жыл бұрын
This looks amazing. Unfortunately, I won’t have time to watch it this week. But it’s on my watch list. Thank you for the coupon code as well.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
For sure, you are very welcome and thanks for your continued support.
@roeungdon7320
@roeungdon7320 3 жыл бұрын
Wonderful and amazing share of education
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@mustafeosman1
@mustafeosman1 3 жыл бұрын
Thanks you Sir you’re the best. I can’t wait. 👍👍👍🇸🇴🇸🇴🇸🇴👌👌👌
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
So nice of you and thanks Mustafe
@austinmueller7298
@austinmueller7298 2 жыл бұрын
Hey Randy, I wanted to know if this template is practical. Can I change the admin categories and will they change throughout the sheet? If I have to become a Patron to utilize these functions I will. I am trying to build a POS for my mother’s business. Please notify me if you have a template like this that I can change information and it already updates.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi Austin, you can download this file using the links in the description above with either your email or Facebook Messenger and customize it however you like. Please make sure to follow the entire video so you can understand how to customize it. I hope this helps and thanks.
@perumalraja6755
@perumalraja6755 3 жыл бұрын
u r a Great genius sir...
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that Perumal
@joemanflyer2001
@joemanflyer2001 6 ай бұрын
Can you use this with the scanner on your iPhone?
@ExcelForFreelancers
@ExcelForFreelancers 6 ай бұрын
Yes for sure, it will work just fine. Thank you for your Likes, Shares & Comments. It really helps.
@davidsztrik5060
@davidsztrik5060 2 жыл бұрын
Is there any way I can get only the Sales Receipt part? Don't need any of the other things just that.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks you are welcome to download this for free using the links in the description, You can use all or any part of it that you want. I hope this helps and thanks so much.
@gamingzone1805
@gamingzone1805 3 жыл бұрын
A Nice Video . Thanks For Share Your Valuable Tips...
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
For sure, you are very welcome and happy to help.
@BerryvanderRijk
@BerryvanderRijk 3 жыл бұрын
Nice video and thanks for the Excel POS, but where can I download all the images that are used in the Excel file, since in tab "Products" there are pictures mentioned but they are not included in the download.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
HI Berry, thanks so much for your comment. I have all of the pictures, icons and resources available to my videos each and every week through our Patreon account here, along with a lot more benefits such as PDF codebooks, updated workbooks and additional training www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
@BerryvanderRijk
@BerryvanderRijk 3 жыл бұрын
@@ExcelForFreelancers ok, good to know.
@DailyTutorial
@DailyTutorial 3 жыл бұрын
amazing bro keep it up always
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that :)
@mohammedbasher7083
@mohammedbasher7083 2 жыл бұрын
Thank you so much Randy🙌
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
You are so welcome Ihmaida and I am glad I could help
@MathsFaciles_siy
@MathsFaciles_siy 3 жыл бұрын
the best is always the best
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much :)
@koushikkumardey6069
@koushikkumardey6069 3 жыл бұрын
Thumbs up sir It would be really interesting
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that :)
@HideAli-is2lf
@HideAli-is2lf 8 ай бұрын
Please create a cashier's invoice within Userform using VBA Excel instead of creating it in Sheet. Thank you and I am happy to learn from you
@ExcelForFreelancers
@ExcelForFreelancers 8 ай бұрын
Hi and thanks so much. I do have that already, in a userform, here: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.
@ismaelsemango5706
@ismaelsemango5706 Ай бұрын
Can i buy this with my own specifications?
@ExcelForFreelancers
@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? Randy@ExcelForFreelancers.com Thanks so much.
@ericvogt5460
@ericvogt5460 3 жыл бұрын
Do you have an POS with Inventory? So for example you have 20 Tomatoes and by scanning one the amount in the inventory changes and on the end of the day you can see when you run short on something in the inventory.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
HI and thanks Eric. Yes i do here: kzbin.info/www/bejne/iZPNc5qnr8d0adk Also feel free to search my channel for any other videos you may want to watch. I hope this helps and thanks so much.
@franklinmalicay9306
@franklinmalicay9306 10 ай бұрын
Awesome❤
@ExcelForFreelancers
@ExcelForFreelancers 10 ай бұрын
Thank you so very much, I really appreciate that Frank
@Abc-sl1nf
@Abc-sl1nf Жыл бұрын
Does this track who sold the items and their total for the day?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
HI and thanks, Yes it does, however you are welcome to download it and customize it however you like. I have another here as well kzbin.info/www/bejne/iZPNc5qnr8d0adk I hope this helps and thanks so much.
@Abc-sl1nf
@Abc-sl1nf Жыл бұрын
@@ExcelForFreelancers so it seems this is not for free? Which one of your packages has the POS (Point of Sale)?
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks, every single template is for free. I get thousands of downloads a day for free using the links in the video description under DOWNLOAD. However if you would like to download 100 or 250 of my templates at one time, then you can pay for that here www.excelforfreelancers.com/product/250-of-my-best-excel-workbooks/ I hope this helps and thanks so much.
@abdullahalmahmud2889
@abdullahalmahmud2889 3 жыл бұрын
Good video 👍
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks i appreciate that.
@izuchukwuhenry2922
@izuchukwuhenry2922 3 жыл бұрын
Good, lesson, I want to learn more
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that. I have over 200 videos right here on KZbin. Thank you for your Likes, Shares & Comments. It really helps.
@sohealsingh
@sohealsingh 3 жыл бұрын
Excellent application.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
@osiroid1
@osiroid1 2 жыл бұрын
Wrote on FB but it disappeared. Tried copying the add item macro for scanning product numbers. Some numbers on my list are not found and all are at the bottom of my product list. Looked at the named range, and despite the formula going to 9999, it only shows me the first 1000 or so, and the green highlight on the product ID column doesn't go all the way down. Any suggestions as to how to fix this? It enters most of the SKUs to my invoice fine.
@osiroid1
@osiroid1 2 жыл бұрын
Needed to sleep on it ... figured out a row was subtracted from the bottom of the column for each empty cell in the column. Duh! Sorry ...
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi Geoffrey, 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.
@TúThanh-e2k
@TúThanh-e2k Жыл бұрын
Software that adds sales statistics is great
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much. I have done that with my latest release here: kzbin.info/www/bejne/fnaQmGV4dqhogdUsi=DDmUvptrdVq6wK3z I hope this helps and thanks so much.
@TúThanh-e2k
@TúThanh-e2k Жыл бұрын
@@ExcelForFreelancers That's so great. Thank you for your sharing. Wishing you good health and continued success. Once again, thank you for your sharing
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
For sure, you are very welcome
@funnyplace496
@funnyplace496 Жыл бұрын
Sir which command use for print butoon
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks you can use ActiveSheet.Print I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
@funnyplace496
@funnyplace496 Жыл бұрын
@@ExcelForFreelancers sir full vba code of print button please provide
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Hi and thanks feel free to downlaod this template, customiz it, add print features and if you have any issues please post your questions 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. 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
@oliveiraadalberto3351
@oliveiraadalberto3351 3 жыл бұрын
great presentations
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Glad you like it and thanks so much for your comment Oliveira.
@bekashbarmon4177
@bekashbarmon4177 3 жыл бұрын
Nice ❤❤❤
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Many many thanks Bekash
@prasanthkumar7590
@prasanthkumar7590 3 жыл бұрын
Very very thanks ......💐💐💐
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
For sure, you are very welcome Kumar
@neakniporn4121
@neakniporn4121 3 жыл бұрын
Is that included on sale 200 Workbook Zip File?
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
HI yes this is part of the 200 workbooks download. I hope this helps and thanks so much.
@faysalahmad6313
@faysalahmad6313 3 жыл бұрын
Good video
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Glad you enjoyed and thanks so much.
@terthoananya2138
@terthoananya2138 2 жыл бұрын
Beautiful
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you! Cheers! :)
@MdRaj-vd6ij
@MdRaj-vd6ij 3 жыл бұрын
Nice vedio
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much Raj
@MdRaj-vd6ij
@MdRaj-vd6ij 3 жыл бұрын
@@ExcelForFreelancers wlc
@bestscenes1469
@bestscenes1469 3 жыл бұрын
Awesome!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks! so much :)
@nethmina_official
@nethmina_official 9 ай бұрын
Bro... How to get your visual basic codes
@ExcelForFreelancers
@ExcelForFreelancers 9 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@mdyounus1698
@mdyounus1698 3 жыл бұрын
Good videos
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Glad you like them and thanks :)
@yaser.taherkhani
@yaser.taherkhani 3 жыл бұрын
Thank you 🌹
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
You’re welcome 😊 Yaser :)
@keithmoindi2109
@keithmoindi2109 9 ай бұрын
There is no macro for printing but i tried to create it the problem is the barcode when i print it doesn't move downward please help
@ExcelForFreelancers
@ExcelForFreelancers 9 ай бұрын
Hi Keith, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@jasondada5705
@jasondada5705 3 жыл бұрын
Excellent
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks so much Jason
@MdAkter-ln4vv
@MdAkter-ln4vv 3 жыл бұрын
Good job
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you very much. :)
@rahimbadsha7800
@rahimbadsha7800 3 жыл бұрын
Super
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that Rahim.
@เอยกับมะปรางรีวิว
@เอยกับมะปรางรีวิว 3 жыл бұрын
สุดยอดมากกกกครับ
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Kap Khun Ma Krub :) Thank you
@kanwalkhan4311
@kanwalkhan4311 3 жыл бұрын
Amazing
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@osiroid1
@osiroid1 2 жыл бұрын
Found a bug I'm pretty sure. When I delete the last row in the receipt it doesn't delete the row from the Order Items DB, but this only happens when deleting from a loaded receipt, not a new one. If I delete a row which isn't the last row in the receipt, everything works fine. At first I thought I had screwed up, but I chcked with the original download and I get the same problem. Anyone else notice this?
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks you can move the Delete line of code down so that it is not skipped in that case 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
@osiroid1
@osiroid1 2 жыл бұрын
Yes - that works. In the sub OrderItem_Delete, the line containing "EntireRow.Delete" needs to be moved down below the "End If" belonging to "If ItemRow LastItemRow" or it won't delete the last row of a saved invoice. There's also a 'LastRow' that seems to be undefined and should probably be 'LastItemRow'. Took a while to get my head around this when there were bugs in the original file ...
@osiroid1
@osiroid1 2 жыл бұрын
Hmm - after testing I can say that doesn't work either - when I move the line down, it won't delete new or unsaved items as there is no ItemDBRow.
@osiroid1
@osiroid1 2 жыл бұрын
I think I figured out the bug. The row has to be moved down as stated above, but in needs to be within an if: If ItemDBRow Empty Then InvoiceItemDB.Range(ItemDBRow & ":" & ItemDBRow).EntireRow.Delete End If
@osiroid1
@osiroid1 2 жыл бұрын
Still won't delete the last row. Major pain ... No provision in code for deleting the last row.
@sai1766
@sai1766 3 жыл бұрын
Sir please make civil store dynamic data of all departments like civil materials plumbing materials electrical materials etc please do need ful
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Hi and thanks so much for your feedback and request. For your application I suggest you post a PAID JOB 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.
@mazarulislam111
@mazarulislam111 3 жыл бұрын
Nice
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks very much
@Tonylima1
@Tonylima1 11 ай бұрын
@ExcelForFreelancers ? Was the 'print' button disabled on purpose? 🤑🤑
@ExcelForFreelancers
@ExcelForFreelancers 11 ай бұрын
Hi and thanks for your comment. This training was a few years ago so I can't remember if/why the print button wasn't used. You can easily set the print area and assign the button to a print macro such as Sub PrintOut Activesheet.Printout End Sub I hope this helps and thanks so much.
@sammytuger247
@sammytuger247 Жыл бұрын
Infact you are incledible
@ExcelForFreelancers
@ExcelForFreelancers Жыл бұрын
Thanks so much. I really appreciate it. I have an updated POS training I think you will love here: kzbin.info/www/bejne/d2magZerobNsrq8 Thank you for your Likes, Shares & Comments. It really helps.
@superbest5059
@superbest5059 3 жыл бұрын
How I download this project plz send me this source code and files
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
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.
@superbest5059
@superbest5059 3 жыл бұрын
@@ExcelForFreelancers hii sir I download this project files but not working image not showing and barcode not scanning
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Please make sure to watch the entire video so you understand how this application works and how the macros work. 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. 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
@simont733
@simont733 3 жыл бұрын
how do i do if i want QR code instade of Barcode
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Hi and thanks, This App also works with QR codes as well so it is no problem
@jigneshshah9881
@jigneshshah9881 3 жыл бұрын
thanks sir
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
For sure, you are very welcome
@piyushagrawal6143
@piyushagrawal6143 2 жыл бұрын
SIR Please reupload this workbook on email Because there is nothing (no icon no image). When I clicked on dairy and any other category it always showing complier error. Please download the workbook and fix these error . Love from India ❤️❤️
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
HI and thanks Tanya, when you initially open this application there would be no images. You would need to have the same imagines and map the file path of those images. Please make sure to watch the training video in order to understand how to make images appear and fix any issues. 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
@amitgainarup
@amitgainarup 2 жыл бұрын
Please download link share, i can not find download link.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi Amit, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@keithmoindi2109
@keithmoindi2109 9 ай бұрын
Ok in the template the printing button is not working
@ExcelForFreelancers
@ExcelForFreelancers 9 ай бұрын
Hi and thanks very much. I do add that functionality on my Patreon platform here www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
@alcifrerdewich2323
@alcifrerdewich2323 3 жыл бұрын
The best
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@منيربارحمة
@منيربارحمة 2 жыл бұрын
ممكن رابط التحميل. لوسمحت
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
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.
@mauricioreguete466
@mauricioreguete466 3 жыл бұрын
Tem link para download?
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Hi Reguete, 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.
@mauricioreguete466
@mauricioreguete466 3 жыл бұрын
@@ExcelForFreelancers me manda no meu email essa planilha How to Create A Mobile Barcode Scanning Point Of Sale Application (POS) In Excel
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
HI please click the links in the description of this video. You can download it from there.
@mauricioreguete466
@mauricioreguete466 3 жыл бұрын
@@ExcelForFreelancers thank you me desculpa verifiquei nos meus email e estava a planilha..Thank you...
@harun-or-roshid6287
@harun-or-roshid6287 3 жыл бұрын
Awesome
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that Harun :)
@allinonereview158
@allinonereview158 3 жыл бұрын
Download link is not working randy sir
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Hi 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.
@musandow2583
@musandow2583 3 жыл бұрын
Will like to know more fromyou
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
thanks so much. :)
@AFAMKA
@AFAMKA 2 жыл бұрын
I'm never can find direct link to download this App, please provide direct link, thanks.
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi and thanks you can find download instructions in the video description. We do not provide direct links, however you can get 250 of my templates in a single zip file using this link www.excelforfreelancers.com/product/200-of-my-best-excel-workbooks I hope this helps and thanks so much.
@superswift2839
@superswift2839 2 жыл бұрын
Can you share this app plz ?
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
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.
@mdzinarulislamabdullah1838
@mdzinarulislamabdullah1838 3 жыл бұрын
nice.
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you! Cheers!
@mdarif-lx6nv
@mdarif-lx6nv 3 жыл бұрын
Nc vido
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@samiulhoque9101
@samiulhoque9101 3 жыл бұрын
fine!!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that Samiul
@Xd4LEM4ObX
@Xd4LEM4ObX 3 жыл бұрын
A monospaced font for the code would be more easy to understand
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
thanks very much for the comment and feedback. Much appreciated.
@shafalinetwork9175
@shafalinetwork9175 3 жыл бұрын
nice
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks very much
@devipriya3029
@devipriya3029 3 жыл бұрын
Sir android mobile VBA macro not working
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
HI Devi, thanks for your comment. VBA is not allowed in mobile devices. I hope this helps and thanks so much.
@aajhavemia9441
@aajhavemia9441 3 жыл бұрын
নাইহ ভিডিও
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@neakniporn4121
@neakniporn4121 3 жыл бұрын
Hi, how can we assign the macro to print the receipt?
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Hi and thanks. You are welcome to customize this application however you like and assign macros to any button. Just right click and Assign Macro. Thanks again.
@TheJaebeomPark
@TheJaebeomPark 3 жыл бұрын
I root up for you!
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@murat.ondasyn
@murat.ondasyn 3 жыл бұрын
Cool
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that Mypat
@mdsadek437
@mdsadek437 3 жыл бұрын
Nicer
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks very much Sadek
@knoxdreyar4391
@knoxdreyar4391 2 жыл бұрын
where is the free download
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Hi Knox, 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.
@sumonvai9260
@sumonvai9260 2 жыл бұрын
nich
@ExcelForFreelancers
@ExcelForFreelancers 2 жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@mdkamruzzaman9198
@mdkamruzzaman9198 3 жыл бұрын
Wow
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
@mdangur4988
@mdangur4988 3 жыл бұрын
Niccc
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thanks for liking
@prodipkhanprodipkhan9308
@prodipkhanprodipkhan9308 3 жыл бұрын
Nc
@ExcelForFreelancers
@ExcelForFreelancers 3 жыл бұрын
Thank you so very much, I really appreciate that.
Simon Sinek's Advice Will Leave You SPEECHLESS 2.0 (MUST WATCH)
20:43
Alpha Leaders
Рет қаралды 590 М.
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 145 МЛН
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
How to treat Acne💉
00:31
ISSEI / いっせい
Рет қаралды 100 МЛН
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
The Easy Way To Create A ChatGPT Function In Excel
36:49
Excel For Freelancers
Рет қаралды 3,3 М.
This Weekly Planner Uses The New Excel Checkbox Feature + Free Download
2:15:05
Excel For Freelancers
Рет қаралды 7 М.
How To Master Drag & Drop Shapes In Excel VBA From Scratch
57:51
Excel For Freelancers
Рет қаралды 9 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 942 М.
No Black Box Machine Learning Course - Learn Without Libraries
3:51:31
freeCodeCamp.org
Рет қаралды 1,8 МЛН
How To Speak Fluently In English About Almost Anything
1:49:55
EnglishAnyone
Рет қаралды 3 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 267 М.
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 145 МЛН