Inventory Management form in Excel | Step by step complete tutorial
Вставка
- Опубліковано 14 жов 2024
- #Userform #ExcelVBA
Hello Friends, an Excel VBA based Inventory Management User Form. This form can maintain the Sale/Purchase transaction also. Data of this form is stored in the same excel file only. This is step by step complete user form tutorial.
Please download the practice file from below given link:
www.pk-anexcel...
Subscribe our new UA-cam Channel:
/ @neotechnavigators
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...
AMAZING HOW REMOTELY FROM KENYA I ACCESSED YOUR CONTENT AND NOW TRYING T DEVELOP A WASTE MANAGEMENT AND DUTY ROSTER SYSTEM FOR A YOUTH PROGRAMME IN DANDORA,GOD BLESS YOU
Hello,
How did it go?
the very best part of your lesson is you speak very good English i am really impressed
Hello PK, I am a beneficiary of your tutorials most especially the Sales/Purchase Inventory Management. I even tried it. I will rate it ⭐⭐⭐⭐
From Tanzania, Following the training!!! Its well explained
Thanks for your valuable feedback
Hello Pk, I just want to tell you that you are a great teacher and a selfless one: I am not an excel expert, but I have seen significant development in my excel skills, thanks to you. Your lessons are easy to understand, the pace is ideal, your delivery is Great and you share a considerable amount of information on vba programming.
Thank you :)
Thanks for your valuable feedback
I want to buy this application or software.... Can we discuss face to face about this
@PKAnExcelExpert hello sir, I found a problem in the "Show Transaction" section.
After I followed your video tutorial, the "Sub show_sale_purchase_data" section why can't it appear in the Show Transactions "listbox" how to solve it. Thank You
The BEST Tutorial with a detailed step by step error free explanation. Thanks PK. Really appreciate it.
Thanks for your valuable feedback🙏
I made it as like you and my teacher is appreciate me so great !!!!
Thanks for your valuable feedback
From Libya perfect 👌 explanation... thank you for that accurate detailed tutorial....
Thanks for your valuable feedback🙏
Such an amazing tutorials and good explanation method. even a baby can understand. we Missed a Teacher like you. Hats off PK Sir. From Sri Lanka. Keep doing such tutorials..
Thanks for your valuable feedback
Please I need your assistance
Antonmursid
🇮🇩🙏🙏🙏🙏🙏
Thanka for the comments Chaminda Vaas
I run the product master codes but it gives me product is already add. However, it did not appear on the excel sheet
The best Excel tutorials, I have seen in the last 5 years. Excellent. Keep it up.
Thanks a lot 🙏
I am from Brazilian, Cuiabá.
Fantastic. I improved a lot and my repertoire in VBA Code . It was a sophisticated code to me.
ei im too
krl mlk tendi foi porra nenhuma q esse maluco falo ingles dele ta pior q o meu kkk
ua-cam.com/video/tUqscx5GrIo/v-deo.html
You are a great teacher. keep the good work and God will bless you.
Thanks for your valuable feedback🙏
Dear Sir,
Thank you for the amazing lesson. It has took me a whole week to learn from zero. Hat off to you!
Thank you for taking the time to teach the inventory mgt. As a new business, this is what I was looking for to help me understand how to do booking. I look forward to learning more.
Glad it was helpful!
Help me error 91 problem aap solve kar dijiye ga kya!!!
Pos With Stock management System Download Link: ua-cam.com/video/gFfxOtsUMEc/v-deo.html
Really awesome tutorial. Thank you.
For inventory management, is it possible to write a macro that updates stock based on use of ingredients for a dish. For example: if I input "cake" in the sales section, it will subtract all the individual ingredients from the inventory
in my whole life of excel career you are by far the best of giving free (premium type) stuff. love you bro.
Hello sir, how can I solve error 438 saying object doesn’t support property or method please I need ur help
@@Anuzblogmedia which version of ms office are u using
how to copy and paste the calendar image into the userform
I have appreciated your huge and fantastic work.
Congratulations
Thank you very much!
I am from Zambia. This is great works, impressive. Are you able to add the Opening Balance in terms of value based on the date selected for each item selected for adding or update?
Respected PK Sir, Thank you for all these sharing . I gained lot of excel skill through your above channel. Our Warm Regards to U Sir.
Nicely explained video, please my request is how we can get invoice when we sale the item, as we have to provide invoice to the customer too. Have a good day
Sir ap ek behtreen Teacher hai
Thanks for your valuable feedback
@@PKAnExcelExpert Sir ek issue araha hai mere sath inventory display wala code jb mai show karwa raha hou User form initialize , add button and update button mai aur jb run kar raha hou tw Error 1004 araha hai application defined or object define ka
kia karu ab Sir
Dear Sir,
Really It’s nice. i wanna know that, how can entry manually sale rate??
pls pls...
I wish to know this too.....
Boss you are UA-cam best Excel king
Thanks for your valuable feedback
Hey like it but was really inquiring on how to delete record from product master form. Thats the major challenge and would appreciate if you guided on it Waiting on the feedback kindly
You can do this manually by unhiding the sheets. Otherwise just create a button on the form and target the item master number to delete the row to update.
@@scientist100 how??????????????????????
thank u pk it is wonderful teaching . I hope those who want to learn vba will earn a lot !!!!!
What a hard and great job! Really appreciated, Many thanks
Thanks for your valuable feedback
@@PKAnExcelExpert sir how to add expense tab
@@PKAnExcelExpert Why the below line is coming up while clicking the Calendar Image icon , i am stuck here, please help..
Private Sub Image6_BeforeDragOver(ByVal Cancel As MSForms.ReturnBoolean, ByVal Data As MSForms.DataObject, ByVal X As Single, ByVal Y As Single, ByVal DragState As MSForms.fmDragState, ByVal Effect As MSForms.ReturnEffect, ByVal Shift As Integer)
End Sub
your code is showing "Private Sub Image6_Click()..but mine is different.
hello sir I am from India and I want this axle seat and your video is very helpful please send me its download link please
helps a lot brother specially to my small business, thank you!
Happy to help!
Pos With Stock management System Download Link: ua-cam.com/video/gFfxOtsUMEc/v-deo.html
I've been waiting for such a video for so long, thank u
Thanks for your valuable feedback
Good PK.
Such a long video on Sales Inventory Managememt System.
@@sharvari.s.vichare Hello. I am microsoft. Great PK
Mension thanks
Good PK
Just Fantastic video sir. Lot to learn from you
Thanks PK
Your video is self explanatory
Most welcome🙏
Hello sir, congratulations for your efforts & 100k.
Many many thanks
Hi
Sir kindly tell me that how i can add things with the help of barcode scanner in this software . Am waiting for you good answer. Thanks
ये तो आपने इतना अच्छा बनाया है कि जितनी तारीफ की जाय उतनी कम, धन्यवाद इसके लिए
Thanks for your valuable feedback
Thank you for the clear explanation, Pleaseseee, do you post Excel tutorials from beginner to Advanced videos
Stay Safe
PK, this is your number 1 student in Ghana. Thanks for the great and innovative approach. Please how do i copy and paste the calendar image in the vba?
Thank you for the polite request to put a project link in all your excel videos
Excellent !! great teaching skills and you have explained it so well . Keep up the good work
Glad it was helpful!
Great program to follow. I was wondering what are the characters infront of "validation, "check duplicate", "add data", and "clear boxes". Thank you.
Thank You for this tutorial. More Power God Bless
Thank you🙏
I am from Bangladesh love u sir
Respect sir I have watched this video hundred times to learn everything in deeply even I have downloaded this video in my mobile I have learnt this video I wanna learn how to maintain sales purchase outstanding bill no wise could you please make video like this?
You are the best Sir. 🎊🎊🎊
Please keep making videos
Thanks for your valuable feedback
It's an amaziang tutorial. Very useful for me.
I have a question. ❓
Stock can't be negative, right? So is there any code to pupup a massage when stock is less then 0?
Thanks again.
This is very nice! thanks a lot.
i would like to ask if there is a possibility to delete a record, and how can i avoid duplications?
thanks in advance!
Nice man i got best explanation of this topic only from ur channel,keep doing explaination on such types of topics
Thanks for your valuable feedback
I am a new subscriber for the sake of this amazing tutorial, which i was searching is the 48hrs. Thanks alot
Very good program. Is it possible to add customers and vendors to track certain transactions? I will buy it if you would like to add those two buttons.
i was so amazed. very very detailed. hope you add also Delete Item Button. God Bless and hoping for more educational videos.
Thanks. Please watch the next part of this video:
ua-cam.com/video/x8EMcmGltWA/v-deo.html
Hello PK, thank you so much for the shared knowledge you have. It is so wonderful, please keep it up.
It's my pleasure
Congratulations for your effort love from Nepal 🇳🇵 ❤
Thanks for your valuable feedback
Great video, this is really very professional tutorial, thank you Brother
Glad it was helpful!
Pos With Stock management System Download Link: ua-cam.com/video/gFfxOtsUMEc/v-deo.html
it's beneficial for us thanks a lot, I do have a suggestion can you put a remarks dialog box so we can track every item that should be located? like, shelve 1, 2, and so on.
Good day I'm Edmar fan of your tuturial can a ask questions how can I change the logo on the top of the inventory system?
Very great video, it helps me to create another project, thank you 🙏🙏🙏🙏 sir
Very good software, Dear if you add expense tab and then calculate profit then its too good.
Awesome,very informative,kindly include delete button,thank you
Great video thank you development team really you make my job is very easy thank you again.
Thanks for your valuable feedback
Hello PK! Can we monitor the product's expiry dates in this project? And also the top selling products in the dashboard? And also can we integrate the barcode scanner and the thermal printers as well as the other printers for report printings?
Amazing Sir ... Unbeliveable work ❤
Thank you so much 😀
Hello PK Sir thank you so much for helping us and this great job without any kind of charges you teach everyone.
Sir, i request to you please make payroll workbook with employees and multiple employees selection wise searching report fully automatic without VBA
We will try to create such tool
its very very useful for me thanks dear if i have any question for this then
sometimes it was hard to understand but i did it........... thank you
Thanks for your valuable feedback
Your work is very simple yet very informative and helpful....
Thanks for your valuable feedback
you are great your videos are so amazing. M very impress
Glad you like them!
Mr PK as always i love your video, and it helps me a lot. Mr. PK how about putting delete bottom also?
This is the best video on this topic. I appreciate your hardwork and efforts. Sir also please clear one doubt, i dont want fixed sale/purchase price, this should vary every time. What to do sir? I am eagerly waiting for your response. Thanks
Thanks! From Tanzania
Hello, thank you for the video and sharing your knowledge. I got a question, does this excel work for customers who purchase multiples of various products?
The best tutorial on youtube. sir is it possible add a option to delete product from the list?
Thanks brother, Master of VBA
Always welcome
Amazing project wonderful ☺️ keep growing
Thanks a lot 😊
@@PKAnExcelExpert Sir I want to ask something?
Thanks PK. I am from Mozambique. I loved the design of the system. I took two days to complete the lesson. :)
Thanks for your valuable feedback
Hello sir think you somuch for this wonderfull project....I have knowledge about vba so had a question .. as I wanna use this project for my shop.. so how can I remove the sales rate and purchase rate auto update as it may keep changing and enter it manually plz help
Very informative
Thanks🙏
Hello Pk, thanks for sharing this amazing job of yours.
A little request, is it possible to allow naming of product with only numbers such as "20023" because I get an error in the VlookUp line where the price is found.
hello your teachings are so helpful thank you
Most welcome
@@PKAnExcelExpert thank you but you will be my friend or?
I am VBA learner from your Channel.. Great Boss..
Thanks for your valuable feedback
Hi Pk. A very useful training. Can we get this project source code or sample file?
I'm glad you found the training useful. Yes, you can download the project source code or sample file from the link provided in the video's description box. Alternatively, you can visit our website www.PK-AnExcelExpert.com to access it. Happy learning!
This is so helpful. Almost perfect..... possible to add remark entry and editable sales price ?
Yes editable sales price is required. Thanks
@@sharifulisl2084 what i did now is edit the product master price everytime if need to change the sales price
Wow wonderful PK thank you. How can i delete entries?
good effort , good job , but i want to know price change it from time to time , purchase price , and sale price according to market , and is the update of price will be affect transaction from the date of update or , will affect all previous transaction , because if affect all transaction , the data will not accurate , at the end you do good effort and i learn from your knowledge
It 's a great tutorial.
Thank you sir...
Most welcome
Great video.thanks
Most welcome🙏
I just made different one following you works good love it Thanks a lot.
Fantastic!
Hi Sir, This Is a wonderful Tutorial, Pls Give the training of sales( related Cash & Credit)
Will do soon
Pos With Stock management System Download Link: ua-cam.com/video/gFfxOtsUMEc/v-deo.html
i love way u teach
Thanks for your valuable feedback
Superb Explanation...
We will support u sir...
Thanks for your valuable feedback
I am from the Philippines I really like this video especially we have a project to create an inventory. I just one little problem how to delete the products and its info in list box after you saved it or add in the inventory?
I would really appreciate your honest reply to this concern and thank you again for this video.
Thank you so much! You are the best! 😊😊😊
Thanks for your valuable feedback🙏
Thanks so much for this explanation
You're very welcome!
Really great Job..!! it Helped me a lot Learning..
Thanks for your valuable feedback🙏
Pos With Stock management System Download Link: ua-cam.com/video/gFfxOtsUMEc/v-deo.html
I loved and enjoyed it...You are great !!!! hope to see much more new program mes.......I am Manohar and wishing you anice evening.....
Thanks for your valuable feedback
Wow beautiful video ❣
Thanks🙏
Excelent work. Well done and thank you for your work. One question pls. Although I do some experimental purchase and sales, the Purchase, Sale and Profit boxes do not change their values and they all show "zero" values. Any idea why is this happening ? All the remaining boxes i.e. inventory amt and quantity are changing correctly. Thank you again .
Thank you for your sharing. Very nice work. It will be very nice if you add the Customer Section to this system
Nice work sir
Sir in this application you will not add print button by sale/purchase and inventory mean if any person want to print separatly record like inventory then what should he do please sir tell about button option JazakAllah
Thanks so much for your video! It makes me recall a project I was working on to track my stocks. I stopped with the problem that, when I sell partial quantity and then rebuy again from the same stock, how to calculate the cost? e.g. I first buy 10 shares of Apple at $100$ then buy again 6 shares at $110. The average cost now is $103.75, then I sell 3 shares at $120 and after that, the cost for the rest 7 shares is still $103.75. Then I rebuy 5 shares at $110, how to automatically calculate the cost for the stock now? The method I'm using is the weighted average cost of the share.
Do you have any idea how to work that out? Thanks and looking forward to your reply.
Thanks its simple and great... useful 👍
hi PK how are you, thank you for your giving us the best knowledge I am from Pakistan, and I have a problem, there are a lot of videos for stock inventory, but I never find Stock inventory for manufacturing units, From raw materials to finish Goods, For example, I have 3 employees I am giving them raw material and they are giving me finish product how can we deduct raw material by finish goods when they give it back, and how to maintain my stock inventory left with my employee and in my warehouse hope you will resolve my issue i am much needed this time
🙏Thank you for amazing and helpful video. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Most welcome 😊
Pos With Stock management System Download Link: ua-cam.com/video/gFfxOtsUMEc/v-deo.html
@PK:AnExcelExpert
Sir I have watched second part inventory management.
Sir I request you for average rate of product as the product would not be same during purchase or sale. So kindly do the needful.
Thank you 🙏🙏🙏🙏🙏
I also practiced the same.
Hats off to your hard work.
Thank you 🙏🙏
@@PKAnExcelExpert sir found similar to your video...!
ua-cam.com/video/LBAII2kGVRM/v-deo.html
Excuse me, this software seems suitable for my small store. Can I purchase it and could you please provide me with the price?