Create This AMAZING Excel Application that Tracks Purchases, Sales AND Inventory [Part 1]
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- 🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_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 TH-cam MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create a POWERFUL Inventory Manager.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/InvMgrPt1_Wb
📍Watch Part 2 Here: • Create This AMAZING Ex...
🤑 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 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_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
0:36 - Worksheet Design
18:45 - Move Button
39:42 - Conditional Formatting
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 #inventorymanager #inventorytracker #salestracking - แนวปฏิบัติและการใช้ชีวิต
![Create This AMAZING Excel Application that Tracks Purchases, Sales AND Inventory [Part 2]](http://i.ytimg.com/vi/GodLw1LfTj4/mqdefault.jpg)
![Create This AMAZING Excel Application that Tracks Purchases, Sales AND Inventory [Part 2]](/img/tr.png)
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
Incredible! This video alone could cover 2 to 3 years of learning at school easily. It's not only entertaining, it's resourceful. Thank you sir! I have no background in excel and in the verse of self-taught. From learning functions to VBA and I thought it's sufficient for my use already but when I'm seeing this video, it's just like a gold mine of infomation. It'll take me months to get familiar with all the steps, tools, and functions that you used in this video. Again, thank you sir! Please keep it coming.🙏
Thank you so much Tera, I really appreciate that and work hard each week to create unique, fun and useful applications. I see Excel as a blank canvas in which we can apply our art. Thank you so much for the valuable feedback.
Thanks my friend you're one of the best instructors I ever follow
Thanks so much Carlos, I really appreciate that.
You can do so much with Excel. Thank you for this 🙏🏾
Thank you so much. Please do not miss this Tuesday, I will show you how to share and sync your macro-enabled workbook with anyone in the world: th-cam.com/video/3E6ExWYscHQ/w-d-xo.html
I'm constantly bursting out 'AMAZING!' Wow. I didn't even know all this was even possible. But it was. It's just the genius way of putting it all together! AMAZING!
Wow, thank you!, Very kind of you Imran.
Amazing tutorial.. very helpfull for my self
Hello, you sure are one of the wonderful instructors, I have come across in a while. You know your subject very well, it reflects on your presentation. You made things so simple and easy that in one shot, I could gather more than 90% of your process. It is remarkable, awesome and wonderful. I am in love with Excel and its capabilities because of you. Thank you and Stay Blessed!!!!
Thank you so much Shailon, I am so glad you enjoyed the training. I look forward to making videos to help inspire and teach people around the world. Thanks so much.
A truly work of art! Thank you for sharing your knowledge Randy! God Bless You!
For sure, you are very welcome Lemuel.
Thanks Randy. Love the slider idea with the IncrementLeft parameter and the hide/show row icons. Looking forward to the conclusion.
Thanks so much. I appreciate that. The idea of tracking inventory in Excel is nothing new however I wanted to add some new styles and ideas to an old concept. Thanks so much.
I wrote the exactly same code for slider though it gives run time error "-2147024809 (80070057)"
Kindly assisst.
Thanks Sir Randy, I learned a lot! I really wanted to purchase your bundle pack but so far I don't have enough budget (lol) but promise to purchased soon.. thank u so much...God Bless you!
Hi and thanks so much. I do understand and appreciate your continued support.
Great tutorial and really useful for a project I'm looking at completing.
Do you have a step by step project guide that you follow when creating something like this, that you could then use for every project? So you don't miss anything out?
Hi Steven, thanks so much. I do have a Mentorship course in which I walk students step by step out to create their own applications for the marketplace, while I build an entire accounting application in Excel, that includes weekly lessons, at 90 Minutes each. You can find out more about this program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Thanks for the Video man. Im going on 4 months on excel, and I think my progression is good considering that I have no resources other than online course's and youtube videos like this one. I've been trying to do the same thing but on my own. Only experience I have is running an office pool for family and friends. I thought my original way of working was good enough until I learned that I can have Excel do most of the work for me. I am linking so many cells together, but you've enlightened me on the mapping part. Thats what I need to do.... anyways, you have motivated me to start my VBA course. Thank you!
That is really great to hear Richard. I am so happy to hear that. Keep learning and pushing and I know you will do great.
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.
I love this kind of videos as it shows the each step to create such a tool in Excel! I've been using stock and inventory tool/template on Google sheets and I'm more than happy with that tool. Thanks for the video!
Great to hear! I am happy to help and share Kevin
th-cam.com/video/H3kQHjQZp48/w-d-xo.html
Thanks for the great tutorial. The toggle button is really cool and nifty! In my case, the name of the shape had to be different from the name of the macro to work.
Hi Christopher. that was my mistake. On some versions of Excel, this is an issue. I should have named them differently (the download version I have fixed this already) Thanks so much for following.
@@ExcelForFreelancers thanks, renaming it..solved my problem.
@@Rockandroll29 are not h no h
Hello! I went through this video step by step by copying everything being done on my own Excel file. The points I found tough to duplicate were naming the shapes as Excel kept going back to the original name. I was able to use Alt F10 which brings up a menu that allows you to change the name of shapes and groups easily. The other part that was difficult was using the Name Manager to create the mapping piece. This is because I have never used this function and not understanding the formulas made it harder to copy them as they were done (a lot of going back in the video and pausing to get it right). All that said, I now have a spreadsheet setup which is very similar to the one done in this video. Yes the colors are off a bit, but the function of it to this point is right on. This was a four plus hour project for me doing it at my own pace while watching and playing back the video as needed. I learned so much from this and want to thank you for putting the video out. Using Excel daily for work I get used to doing the same things over and over but this opened my eyes to new and exciting options this powerful tool has to offer. I look forward to going on to part 2 and finishing my spreadsheet. Then I will work towards modifying it to fit my business needs. A++ on the video and time taken to go through this for public use. Thank you again!
Hi Justin, Thanks so much for going through, watching the videos and creating the application yourself. That is the best way to learn and you should be commended. IF there is any duplication in shape names, or grouped, they might need to be renamed using the selection panel. The Name Manager can also be a bit complex when it comes to Dynamic Ranges but for sure you will do great. When you are ready to create powerful reports and dashboards you can check out my Advanced Excel Dashboard Reports Masterclass here: bit.ly/AmazingDashboardCourse
Also I am on part 15 of our Employee Manager which is an amazing and massive project and great way to learn as well. Thanks so much for your comment and continued support.
Hi Justin ! Can u send me your file.... I can't make it easily bro....plz
@@ExcelForFreelancers I am running into the same issue, Sorry if I am dense, but where is the "selection Panel"?
Best instructional video I've seen here in any TH-cam videos. Thanks so much for your time and training
For sure, you are very welcome Nass. I am happy to help
Thank you for making this available. This works great for purchasing/selling and adding one item at a time. What do you do if you purchase/sell more than one item in a single transaction?
Hi Paul, thanks for your comment. For more than one product you can follow my Invoice From Scratch training here: th-cam.com/video/99xVbVMABJ0/w-d-xo.html
Hi, thanks for this, as everyone else has said, it is fantastic. I am having a problem with a syntax error on the button The error is on the '.Shapes("MoveBtn").Value="Purchase"Then' line. Can you please assist me with this?
Hi and thanks so much for your comment Adrian,. When I originally made this I should have used a different macro name and shape name (they are both called MoveBtn) as some systems will have an error with that. If you change the name on one of them, then change the shape name (if needed) it will work fine.
Also make sure there is a space between "IncrementLeft" and "30"
If you still have issues please feel free to download my application for free using the links in the description.
I hope this helps and thanks so much.
Really Awesome video
Thanks so much Alwasim, much appreciated
Awesome video.. Just got done following along and I didn't miss a step... Thanks for such detailed work. Can't wait for part two... Thanks Again. Is there going to be a user form to enter the Customer and Vender names into the work sheet? or Will it be saved from the Transaction sheet? Same with the Products will there be a user form for adding and editing products?
Hi, thanks very much for your comment. Part 2 will dive into the VBA of the application that you see. Customer & Vendor userforms are pretty simple and have covered that a few times before (See the previous weeks 'Data Entry Form', so in this video I just kept them as simple lists so I could focus on the Sales, Purchases & Inventory Aspect.
This is a very basic solution. As you know Inventory can have TONS of feature. I plan to create a FULL Inventory application along with a Paid course that would be comprehensive and cover all aspects. Thanks so much for your comment and support.
I just found your channels and I am glad that I found You are so good in work I went through your videos pls also make video about the basics of exercise and advance Excel love it keep the good work.
Thanks so much, I really appreciate that and will add it to my list of videos to create. Thank you for your Likes, Shares & Comments. It really helps.
Dose this work on gold jewelry management? I got confused how can I customize this for gold jewelry as rate changes and each item is totally different. How do I create stock and automate it 🤔😣🆘
Yes it does, however it would require customizations. IF you would like help with this please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 30,000 Members who would love to help you with this. Thanks so much.
Hi, im so amazed that we could do alot in excel. I hope theres a video on inventories for in and out with certain location.. just like meat inventories the in and out in the freezer. Hope you could help me on this.. thank u....
HI Mary, thanks so much for your comment. In my Accounting Application I will be creating a complete Inventory system, including locations, and I am teaching how to create this full application in my Mentorship program which was just launched. You can learn more about there here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hi and thanks for this excellent tutorial. I've come across an issue where when highlighting any one of the transactions where the conditional formatting gives it the highlighted focus, the fact of changing from Purchase to Sales using your very savvy button function also changes the Trans. Type of that entry. That should not happen as this changes the initial entry transaction type. This happens every time you switch back and forth and whichever one you have selected before moving on to other activities, it will keep the last information as per the position of this switch (ie: Purcase or Sales)
Hi and thanks for your comment. (I see you posted in the group too) In my version when switching transactions based on a selection of the transaction below, the transaction type, color and button move accordingly so please make sure to download my version (Inventory Mgr. Part 2) using the links in the description of that video. Also check your code, conditional formatting rules, along with the order those rules are placed and the conditions to make sure they are all correct.
Sir thank you for your help this was really needed and also you are the best instructor ready to watch every video of this series.
Thank you very much. I do appreciate that Kinzo
I've put my email in at the link above several times but I'm not getting anything sent to me. I'm just wanting the data to use.
HI James, very sorry about that, sometimes its flagged as spam. Did you try the facebook link? That usually works pretty well.
You can also download the application with this link: bit.ly/InvMgrPt2_WbDl
Such a good effort. Really impressed. May Allah reward you
Thanks so much. I am really glad you like it.
Thanks so much for your Videos Part1 & 2. I have learned enough,
Thanks so much. I -am really glad you are learning so much.
Hello , I went through all your work I found it wonderful thank you.
Thank you very much. I do appreciate that Saeed.
I was getting an Error code as soon as I tried to run the macro. I've added an End With to close the With line but when my button moves to the right it disappears! I suspect underneath the background shape.....
HI Windward, its hard to know the exact cause of the issue however to get help with your question, 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
That error is related to the oval shape not properly getting renamed to "MoveBtn". fix that and all should work perfect
@@papiheeh3132 hey how did you renamed the name, as I am not able to do it..
@@nitinparab2542 Please type MoveBtn and enter. Don't try to save by ctrl S.
@@sharonvarghese6320 doesn't work for me i keep getting message no object to move.
Excellent Video
Thanks so much I do appreciate that.
Aprendí a usar EXCEL desde cero, en tan solo un mes logré aprender las funciones avanzadas de excel y gracias a esto logré ascender de puesto en mi empresa donde trabajo
Seguro que eres muy bienvenido. Feliz puedo ayudar
WOW I'm learning, Thanks for sharing !!
You are very welcome, glad I can help
I have followed this video step by step, when I assigned macro (movebtn) its not moving at all😔, can you help me plz
Hi thanks one slight issue in some versions of Excel when the button name is the same as the macro name "movebtn" it can cause some issues. Just change the name of the macro to something else and it should work. The other issue i have seen is to make sure there is a space between IncrementLeft and 30 , or IncrementLeft and -30
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 I've tried that a few times, but still no luck😕
I face run time error; that message was 2147024809(80070057) and the item with the specified name wasn't found. Please guide through you tube video.
It is difficult to know the bug without seeing the application and screenshot. 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
Same here did you get a solution
HI Edward, I am sure we can fix this in just a few minutes. Can you upload your screenshot and details in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
Thanks so much.
hi @vivek pal
i encountered the same problem but found a work-around... basically what happened is that when you entered a name for the shape (Oval) then software didnt accept it, recall that when you created the Macro you are naming the same based on the name that you are assigning on the excel window. All i did was to go back to the macro and inserted the actual shape name (Oval 2) in both instances and the macro then worked, i have no idea as to why excel didnt accept the name that we are supposed to enter for the shape.
Hope this will solve your problem as it worked for me
Thank you so much for your feedback and help. I do appreciate that. The problem could be that in some versions of Excel the Macro Name "MoveBtn" and the Shape Name "MoveBtn" are the same. Perhaps in some versions of Excel this is causing an issue. I have made corrections and updated both Part 1 and Part 2 so when you download the sample workbooks the fix is there (but you could easily fix this yourself by renaming the shape "MoveBtn1" then also changing this in both instances in the code. Thanks very much for your feedback
Thank you! It's exactly what I need and you delivered it wonderfully! I apprecite you!
For sure, you are very welcome and I am happy to help.
Thank you for your Likes, Shares & Comments. It really helps.
Just found this channel and this is giving me a ton of ideas. I need to track and inventory of assets and users in my company, and working on a file like this one will save so much time.
Thanks so much. I am really glad you enjoy the training.
sir how to odd even rows colors this formula not work in my excel sheet.
Hi you can add this formula to conditional format formula: =Mod(Row(),2)=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
Please make also inventory of in and out items
*new items (delivery arrive)
*issuances
*returns
Thanks you so much
Thank you for the suggestion. We will be building an entire accounting system, with inventory, in our Mentorship Program coming up in a few weeks. Make sure you are on our email list: www.ExcelForFreelancers.com I will also make sure to include your suggestions as well in this application. Much appreciated
@@ExcelForFreelancers please let us know when the tutorial is ready on the accounting system. Thank you for all your videos!
your videos are great man thanks for the knowledge
Thanks so much and glad you like them
You are a highly skilled Excel teacher. Thanks. 👍
Thank you very much. I do appreciate that KD. Feel free to check out the new touchscreen POS video I released yesterday here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
Anyone else paused this video a million times to catch up?😅 Thanks man🙏 This is amazing
Thanks so much. You can also slow it down a bit too by changing the speed. Thank you for your Likes, Shares & Comments. It really helps.
A Million Times is putting it Nicely... Lol
Incredible Information... Excellent!
EXCELLENT EXCELLENT EXCELLENT TUTORIALS.... THANK YOU!
I don't know what kind of demon magic you possess. I wasn't even aware this was possible in Excel.
Haha thanks so much Colin, Sometimes i don't know either i just push the limits every chance I get. Thanks so much for your comment.
Ha ha ha took the words right out of my mouth lol
Lolol. @demon magic.
LMAO!
hahahahahah"DEMON MAGIQUE" hahahahahah
Thank you friends, your instructions are very good and very useful, I immediately subscribed, waiting for the next part
Thanks for the sub!
You are amazing man. I never thought that excel could be usable for anything.
Thanks so much Roeben, I really appreciate that.
@@ExcelForFreelancers i've been using excel for just solving some complex mathematical problems. I didn't expect this work. Dp you have some more of this?
Hi thanks I have over 100 videos on my TH-cam channel. Each comes with a free workbook to download (you can just click the links in the description to download them)
I Love Excel So Much...
Thank you so much. I am really glad you like it.
Too much playing in appearance design. More focuse on the core, that is the formula and the database linkage
Hi Aprila, thanks very much for your feedback. I do appreciate that.
Bonjour je profite des vacances de noel pour voir des videos que je n'ai pas encore vu !!!! à vrai dire elles sont vraiment très complètes, du très bon boulot, je vais toutes les visionner, un très grand merci pour cette première partie enrichissante :) merry chrismass
Merci beaucoup Rom. Après ce gestionnaire d'employés, je créerai plus de vidéos à partir d'un classeur vide, comme celui-ci. J'apprécie toujours tes commentaires
@@ExcelForFreelancers . Magnifique, je vous ai découvrir sur youtube il y a pas très longtemps et je suis ravi, je vais essayer de récupérer vos tutos, vidéo et classeur xls et xlsm pour m'améliorer, il y a quand même des petites différences entre excel anglais et français, bravo 😄
Thank you very much Rom
Don't know why 313 people dislike this. May they just don't appreciate the hard work and the help this work book can contribute to the people who really needs it
Thank you so very much, I really appreciate that.
The reason may be the cash problem. If it was free zip file it will be highly appreciative ..... I m thankful for the hard work behind the tutorial.
But
If someone send me through email for free I will be much thank full.
kuwazir786@gmail.com
I guess this video is specially for professionals not for the beginners. All the steps are too fast with less explanation. Thanks anyway !
Mz
Hi thanks yes my lessons tend to be for Advanced Excel users since there are already hundreds of great channels that cover Excel Basics. Try the channel Excel is Fun for amazing learning of Excel fundamentals
This is great info, but for the love of God, please slow down, you're obviously awesome at excel, but the rest of us who are trying to follow along are not.
Hi Thanks RMT, I will do my best to slow down. It is never an easy balance between those people who want you to move faster and those who want you to move slower. Thanks for your patience and understanding.
You can slow down the speed too, if that helps. I have to do it on some of the videos I watch.
Alot of thanks and appreciation to you Dr.. Its really an awesome tutorial that any business or shop can wish for. I'm just having a compile error in the line of code that is subtracting the SUMIFS functions. I typed in all the same code but excel is complaining from the word ",Trans_Type," .So i really wish if you can help me solve this. Please. Thanks in advance
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 30,000 Members who would love to help you with this. Thanks so much.
HI Randy - I just finished watching both your Inventory Manager videos. They were very helpful. I'm not real handing with excel but was able to follow you. I used your process to develop my own inventory spreadsheet for my very small Maple Syrup business. The only problem I have is that I have Maple Syrup inventory in 3 locations. Do you have a video that I could watch so that I can build into my existing inventory manager where the inventory is located and track when it changes locations? Thanks
Hi Nancy, thanks so much. I do appreciate that. Yes, I do have an Inventory application, called the 'Warehouse Manager, in which I address locations here
th-cam.com/video/hagIuUPDCq0/w-d-xo.html
If you are new to Excel VBA, 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
I hope this helps and thanks so much.
45:28 for data mapping. thank you for making this video. it help me learn 😊 thank you very much.
You are very welcome and I am happy to help.
new subscriber is here.. thank you for sharing this video. more power and God bless!!!
Thanks so much Jesnathan, so happy to have you here. I look forward to creating amazing videos and training each week
Amazing trick, Great explanation,easy to understand eventough i am such a beginner in excel. Excellent. Thank you so much for the video. I hope you stay healthy always
Thank you so very much, I really appreciate that
Thanks for the great tutorial! Will I encounter issues if I were to upload the template that I created to google sheet so that it can be accessed by various users?
You can use Excel for that actually using my Sharing and Sync. feature here: th-cam.com/video/aKV5seZmiBs/w-d-xo.html
I am following your model building very well... Thank you Very much. I just don't quite get the last bit how you had all the transaction rows reflected on the above form. Can you explain please.
Hi Velentie, Since i have done 150 of these trainings I can't remember also the code in this application, however basically when you select an item from the table below we want to display those details in the form above. Feel free to download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
No words to say. This is great video no doubt Randy :)
Thanks so much. I really do appreciate your nice words.
Wow ! Thank you! You are an Master of Excel Manipulation.
Thanks so much Fong, I am glad you liked it
Hi Randy, I Just Have One Heart And You Are Just Wining it Again And Again A Big Thanks To You For This Learning Lot Of Things👍
Thank you so much Prashant. I really appreciate that.
Appreciate Your work much. Thank You.
Thank you so much Janith, I am really glad you like it.
This is an amazing guide! Thank you so much! Good Job!
Thanks so much I am glad you liked it.
This is LIT! Thanks for this!
Thanks so much. I am so glad you enjoyed this training. You won't want to miss tomorrows training on a Touchscreen POS right here: th-cam.com/video/1xyvioUP8Ls/w-d-xo.html
Hi, thanks a lot for this useful video and amazing program, I really learnt a lot from you.
And I have a question, that how I can prevent editing for specific cells which relate to product information and other cells which have formulas
with out affecting running codes.
HI thanks for your comment. You would need to protect only those cells with formulas, and unprotect the others. Then protect the sheet with a password. I hope this helps. Thanks for your support.
Thank you so much for this video. It is really a big help for my project
For sure, you are very welcome , happy to help.
You really are a gift to us sir. Thank you for sharing this talent.
Thank you so very much, I really appreciate that Joshua.
Thank you so much for this video! It's really helpful 🙂 I did have a question; I'm trying to finish the Macro for the button that changes from Purchases to Sales, however, each time I put the code in its promoting me to debug one of the commands in the macro. If possible, I wanted to know how to correctly put in this function in order proceed with the next steps. 🙂
Hi Danielle, thanks so much for your comment. Make sure the name of the macro, and the name of the button are different. This is an issue on some versions of Excel. Also feel free to download my free version using the links in the description in which I use separate names for them. 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 Thank you so much 🙂 This really helped me out! I will defintely be sure to download the free version as well.
@@ExcelForFreelancers I'm having the exact same issue. I don't have the Visual Basic tab so I'm right-clicking and going to assign code, etc. At first it was giving me the debug error now it doesn't do anything. Is there another video that goes over this issue?
@@kimwetenkamp7420 did you ever figure out a fix?
this is the intelligent way to understand everyone .thanks friend
For sure, you are very welcome Mohamed
I just watched another video that did the same thing you did but slower, I don't get the same menu when I right click as either of you..? different versions?
Hi i am not sure what the other video used so it would be hard to know. I used Excel 2010 on a PC to create this. I hope this helps.
Awesome sir....Your The Best...Loved our Tutorials....
Thank you so much Hafiz, I am really glad you like this.
Thank you so much, really it's an interesting one.
Thank you so very much, I really appreciate that.
Thank you so much for a great tutorial. I have a quick question for you. If I want to insert latest transaction always at the D18 row. Every existing transaction will be pushing down after click "save transaction" button. So, the transaction table will have oldest transaction in the bottom and latest one on the top. This way, I don't have to scroll down to see the latest insert transaction. How would you change your code to accomplish this task? Please let me know. i am pretty sure this is a feature that other people wanted as well. It would be great if you can make another video for this series. I really appreciate your help.
Hi and thanks, yes this makes sense, so that the newest entry is always at the top. You can use VBA to determine the last row, such as
.Range("A99999").end (xlup).row
then copy and pastespecial.pastevalues on the 2nd row from the first row>
This will free up the top row in which to add your new item.
I hope this helps and thanks so much.
Creative and professional, thanks
Thank you very much Goory, Much appreciated.
Hi, I loved your tutorial and I am trying my best to follow you. I believe that I missed at the very end of this tutorial how the customer, product #, etc. got filled out automatically when you selected row 21. Could you please help me out? Best regards
Hi Sonya, thanks so much. I did that through the load item macro. If you download the workbook (through the links in the description) you can follow the code to see exactly how that was done. I hope this helps.
Thank you for this. I love learning new things about Excel. Very Curious... is there a way to produce a form like this with similar functions without the use of VBA/MACROS since the office I work in does not allow the use of MACROS in excel on the network. The MACROS will work on the local desktop, just not when placed on the network.
Hi Teresa, thanks so much for your feedback and glad you love the video. The answer is unfortunately No. The only way to get this kind of power from Excel is through macros. You may want to learn and practice this type of programming when you are away from work. I hope this helps and thanks
@@ExcelForFreelancers Thank you!!
Thanks for this video. just what i needed. where is part two though?
Hello Arthur, you are welcome. Part 2 can be found here: th-cam.com/video/GodLw1LfTj4/w-d-xo.html
Love your videos. Very informative. How would your coding look if you had the same part number from 2 different vendors with different costs? And be able to track/auto update inventory from invoicing based on the FIFO (First In First Out) concept? Thank you in advance.
Hi Dan, thanks very much for your comment and I am glad you like the video. In the case you mentioned with the same part #'s and two different vendors, I would still have one single inventory items, however I would have multiple Vendor & Price Fields (Even perhaps a small table if there were many vendors that carried the same product) So in the Individual Inventory Item I would have a table of Vendors who carry that item, their part # (if it is different) and their quantities & prices. This way when you purchase an item, this item will be visible on the purchase order. When you create a Purchase order, then select a specific vendor, it is that respective vendor's prices and quantities that will show up on the Purchase Order (I am a former General Contractor, so it makes perfect sense to have multiple vendors with the same product)
To track via LIFO/FIFO, you can create individual Purchase ID's for each part, then when they are sold, they can then be sold in the order that they were purchased.
Thank you for the quick response. Is there an email address that I can send the specifics to what I'm referring to? I would include snapshots of my Excel spreadsheets, invoicing, purchase invoice examples, etc to clarify. Then once a solution is figured, post a condensed version to the Facebook group for others who might have the same question.
HI Dan, you can email me here Randy@ExcelForFreelancers.com, however I am unable to offer any one on one support. The group is still the best place to get answers to your questions. Thanks so much.
Excellent. I use tally.erp9 software in India for maintaining accounts and inventory. But seeing this, I am amazed.
Thanks so much Sharmeem I am really glad you like it
the best teacher ever and ever. so much thanks
Thank you so very much, I really appreciate that Alma
Hi and thanks for all the valuable info you share with us. As I watch, one question pops up: "Why don't we use Tables?"
Hi Chris, thanks very much for your comment. I have always found tables to be restrictive with my data as there are certain rules to keep tables in tact, so I don't use tables that often. Thanks for your great question.
Amazing. I cannot wait for next program. Are there possibilities for online lessons or....?
Hi Zeljko I am so glad you enjoyed it. I will teach full Inventory, Accounting and Reporting in a Mentorship programming coming up next month. You can add your name and email to this list to be an Early Bird Member here: bit.ly/MentorshipProgram_EarlyAccess
Excellent, Thanks for sharing .
Thanks so much, I am really glad you liked it Talwinder
Hi, i liked your training and i created a similar application like this but I'm a bit concerned due to a limited list of customers and venders and we cannot add new customers directly and we have to add them in setup sheet first. If i have many new & anonymous customers like in online shopping etc. what should be the vba for that. If you can help me in this it will be really appreciated.
Hi and thanks for your comment. Please see my 'Customer Manager' application here on TH-cam for a way to easily add and manage customers. Thank you for your Likes, Shares & Comments. It really helps.
Really really like these videos. Going to use some concepts in my inventory program. Should help out our office people a lot.
What would a program like this cost if someone was to make it for us? I know it's specific to the job but an average range should expect to pay?? Thx so much
HI and thanks so much for your request. This really depends on the customizations, project scope and the person doing the work. It could be anywhere from a few hundred dollars to a few thousand dollars. Please feel free to 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.
Hello, On minute 57:44, What do you mean by Qty on Hand? Does it mean the qty I currently have in inventory? And by Purchase Quantity the quantity I need to buy In order to have the desired qty?
Hi Roberto, thanks for your comment and question. Qty on Hand is the Total Quantity Purchased of an item minus the Total Quantity Sold of an item. Feel free to customize this application to your own requirements. Thank you for your Likes, Shares & Comments. It really helps.
I would like to make some adjustments to the Inventory Manager.
1. this Inv.Man. will be used for tracking incoming wood product that goes to dry kiln
2. then comes out of Kiln to reman mill then back to inventory as a new product
3. Can I use the existing buttons or do I need to add more btn's
4. will this application actually work for what I am trying to do?
5. I there a way to make a flow chart for accomplishing what I want to do?
Any help would be much appreciated
HI Ed, Thank you for your comment.The applications can be used for any purpose but might need some customizations. You can download the application for free and you are welcome to customize this to fit your exact requirements, however they do require a high level of VBA to make changes and updates. If you would like some help with this, we have a group with 25,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
Hello! I came across your amazing video while searching for VBA video. Thank you so much for sharing this great tutorial video. I am having a problem with step 19:07 , i tried to change the name box for the shape into MoveBtn and it doesn't seems to change (i tried to change it several times and the shape's name is still Oval). Is there any step that i am missing? Thank you and have a great day!
HI Saffira, thanks so much for your comment and question. If you have multiple shapes with the same name it may cause an issue. Make sure you show the 'Selection Pane' which will show all shapes on the sheet. You can change names from there as well.
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
Excellent video, thank you very much for that. looking forward for the next episode :)
Thanks so much. Glad you liked it. Part 2 will be released in two days on Sept. 4th :)
Hi Excel for Freelance, thank you very much for your insightful video. I am getting the opposite results for the Sales/Purchase Transaction part using the IF function. For instance, when I enter =IF(B1="Purchase","PURCHASE TRANSACTION","SALES TRANSACTION"), it returns Sales Transaction, even when I have Purchase in cell B1. I don't know why this is the case. Can you please enlighten me? Thank you.
Hi and thanks for your question. Sometimes there can be a hidden space before or after the text "Purchase" so do check this, since your formula looks correct. I hope this helps and thanks so much.
Hey! I tried to follow what your doing in the video but when i came to the set up the formula you have compare mine is totally different. I tried it again and again I think almost 10 times but the out come is still the same.
Hi Pearly, you can download this file using the links in the description above with either your email or Facebook Messenger. This way you can compare mine, with yours. I hope this helps and thanks.
Great video! I have one question. Is it possible to count (add or issue) products in excel inventory in no time by using barcode scanner on mobile phone? Thanks!
Hi yes its possible, with a software that connects with Excel like Appsheet. i will try to do a video on this next month since I think it's important.
@@ExcelForFreelancers Thanks a lot!
Best channel on the subject...
One Q sir.. how do we make these applications available for anyone on the network
Hi and thanks very much. To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/f_1HsR9305I/w-d-xo.html
I'm just trying to make one for our school's welding inventory. so it tracks what got used by students, purchases and when stock is low.
Thanks very much. I am sure you will do great.
Please what excel version did you use
Thank you for great tutorial and I'm waiting for part two
Thanks so much. I am glad you liked it. Part 2 is out, you can find the link in the description.
@@ExcelForFreelancers part two is not in the description. please share. thanks.
Hi sorry about that. I have now added the link in the description you can see Part 2 Here: th-cam.com/video/GodLw1LfTj4/w-d-xo.html
Your video is very informative but there seems to be some disconnect with Excel for Mac. I spent some time trying to figure out how to give my document the gradient look only to realize this feature is not offered in the Mac version. Is there a tutorial that covers Mac? Thank you!
Hi and thanks for your comment and glad you like the video. Excel for Mac is very limited and only has a subset of features that Excel For PC have. You can find more information on Excel for Mac here: www.rondebruin.nl/mac.htm
I hope this helps and thanks so much.
This is an amazing guide! Thank you! Also, I'm creating a button with 3 choices but it isn't working correctly. (PURCHASE / SALES / RETURNS). I believe it is running a loop with 3 choices in the macro. How is writing that slider macro different?
Hi thanks so much. I am glad you like it. With a 3 Choice option it may be easier to use 3 separate macros. Also you want to make sure to know the existing position that it is currently in, so based on the user choice you know to move it right or left and by how much.
Its certainly possible. Give it a try then if you need help, please post your workbook and questions in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
Yes Sir plz make video on that topic also in which we can also maintain ecommerce returns data like this video.
I just suscribe myself to your channel, thank you for your time and help.
Thank you so much. So very glad to have you here.
Really appreciate your efforts sir. Keep teaching to us. Thankyou
It's my pleasure and thanks so much.
Thank you for this amazing tutorial!!
For sure, you are very welcome
Hello sir i want to know more about excel thank you for the shared knowledge and expertise. It is really helpful and timely. If i have questions hope i can reach you.
For sure, you are very welcome. For any questions please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 25,000 Members who would love to help you with this. Thanks so much.