No video

Inventory Management form in Excel | Step by step complete tutorial

  Рет қаралды 1,641,579

PK: An Excel Expert

PK: An Excel Expert

Күн бұрын

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

Пікірлер: 1 700
@bilyokwaro8336
@bilyokwaro8336 Жыл бұрын
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
@nelsonmotivation
@nelsonmotivation Жыл бұрын
Hello, How did it go?
@clemaddo
@clemaddo 4 жыл бұрын
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 :)
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@mohammedazeezshaik5253
@mohammedazeezshaik5253 Жыл бұрын
I want to buy this application or software.... Can we discuss face to face about this
@gost734n5
@gost734n5 Ай бұрын
@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
@zakeerrg3010
@zakeerrg3010 Ай бұрын
The best Excel tutorials, I have seen in the last 5 years. Excellent. Keep it up.
@PKAnExcelExpert
@PKAnExcelExpert Ай бұрын
Thanks a lot 🙏
@expandaaccounts9982
@expandaaccounts9982 2 жыл бұрын
The BEST Tutorial with a detailed step by step error free explanation. Thanks PK. Really appreciate it.
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks for your valuable feedback🙏
@KingsleySundayOA
@KingsleySundayOA 3 жыл бұрын
Hello PK, I am a beneficiary of your tutorials most especially the Sales/Purchase Inventory Management. I even tried it. I will rate it ⭐⭐⭐⭐
@TheMRFOX7
@TheMRFOX7 4 жыл бұрын
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..
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@abdul-azizcockrahussein4155
@abdul-azizcockrahussein4155 3 жыл бұрын
Please I need your assistance
@antonmursid3505
@antonmursid3505 2 жыл бұрын
Antonmursid 🇮🇩🙏🙏🙏🙏🙏
@abdullahhasan1769
@abdullahhasan1769 2 жыл бұрын
Thanka for the comments Chaminda Vaas
@emmmanuelowusuyeboah4838
@emmmanuelowusuyeboah4838 Жыл бұрын
I run the product master codes but it gives me product is already add. However, it did not appear on the excel sheet
@leonardthomasleake833
@leonardthomasleake833 2 жыл бұрын
the very best part of your lesson is you speak very good English i am really impressed
@MwasamaniGunda
@MwasamaniGunda 2 жыл бұрын
From Tanzania, Following the training!!! Its well explained
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks for your valuable feedback
@paulocezardesouzasouza2044
@paulocezardesouzasouza2044 4 жыл бұрын
I am from Brazilian, Cuiabá. Fantastic. I improved a lot and my repertoire in VBA Code . It was a sophisticated code to me.
@papodireto
@papodireto 3 жыл бұрын
ei im too
@zaphkielbellofiore185
@zaphkielbellofiore185 2 жыл бұрын
krl mlk tendi foi porra nenhuma q esse maluco falo ingles dele ta pior q o meu kkk
@candycrushsagapk4185
@candycrushsagapk4185 Жыл бұрын
kzfaq.info/get/bejne/qruhpsapmq3WeaM.html
@heyha6029
@heyha6029 4 жыл бұрын
Dear Sir, Thank you for the amazing lesson. It has took me a whole week to learn from zero. Hat off to you!
@valeriecrawford7066
@valeriecrawford7066 2 жыл бұрын
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.
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Glad it was helpful!
@TMSPCOMPANY
@TMSPCOMPANY 2 жыл бұрын
Help me error 91 problem aap solve kar dijiye ga kya!!!
@technopabitra8576
@technopabitra8576 2 жыл бұрын
Pos With Stock management System Download Link: kzfaq.info/get/bejne/nayWq7Kl2LuxdZc.html
@BengArts
@BengArts Жыл бұрын
From Libya perfect 👌 explanation... thank you for that accurate detailed tutorial....
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@tsegayeminwagaw5833
@tsegayeminwagaw5833 2 жыл бұрын
I made it as like you and my teacher is appreciate me so great !!!!
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks for your valuable feedback
@muneebahkara6626
@muneebahkara6626 2 жыл бұрын
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
@yasincomps2056
@yasincomps2056 3 жыл бұрын
in my whole life of excel career you are by far the best of giving free (premium type) stuff. love you bro.
@Anuzblogmedia
@Anuzblogmedia 3 жыл бұрын
Hello sir, how can I solve error 438 saying object doesn’t support property or method please I need ur help
@yasincomps2056
@yasincomps2056 3 жыл бұрын
@@Anuzblogmedia which version of ms office are u using
@shivkumarmahoniya8246
@shivkumarmahoniya8246 3 жыл бұрын
ये तो आपने इतना अच्छा बनाया है कि जितनी तारीफ की जाय उतनी कम, धन्यवाद इसके लिए
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@christhuraj5109
@christhuraj5109 4 жыл бұрын
Hello sir, congratulations for your efforts & 100k.
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Many many thanks
@thewordoftechnology5401
@thewordoftechnology5401 2 жыл бұрын
Hi
@thewordoftechnology5401
@thewordoftechnology5401 2 жыл бұрын
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
@arieljauresnjoya903
@arieljauresnjoya903 3 жыл бұрын
how to copy and paste the calendar image into the userform
@rafee3333
@rafee3333 4 жыл бұрын
Wow! Thanks God that we have still such nice people in this world . Mr PK i want you from God to be happy, successful and live with long live because your live is not only for you its very important for us too
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback. Request you to please share this with your friends and colleagues
@GAJDEEP
@GAJDEEP Жыл бұрын
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.
@ruposhibanglatec6767
@ruposhibanglatec6767 4 жыл бұрын
I've been waiting for such a video for so long, thank u
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@sharvari.s.vichare
@sharvari.s.vichare 4 жыл бұрын
Good PK. Such a long video on Sales Inventory Managememt System.
@microsoftdestination6249
@microsoftdestination6249 4 жыл бұрын
@@sharvari.s.vichare Hello. I am microsoft. Great PK
@sharvari.s.vichare
@sharvari.s.vichare 4 жыл бұрын
Mension thanks
@sharvari.s.vichare
@sharvari.s.vichare 4 жыл бұрын
Good PK Just Fantastic video sir. Lot to learn from you
@gamerzroom6330
@gamerzroom6330 4 жыл бұрын
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
@borhanspromotions
@borhanspromotions 3 жыл бұрын
Boss you are KZfaq best Excel king
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@mauromiguelmartins5876
@mauromiguelmartins5876 4 жыл бұрын
Thanks PK. I am from Mozambique. I loved the design of the system. I took two days to complete the lesson. :)
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@KhalilAhmad74036
@KhalilAhmad74036 3 жыл бұрын
What a hard and great job! Really appreciated, Many thanks
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@ramnathmahatovideos6557
@ramnathmahatovideos6557 3 жыл бұрын
@@PKAnExcelExpert sir how to add expense tab
@Bickybag
@Bickybag 2 жыл бұрын
@@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.
@ishusawner
@ishusawner 10 ай бұрын
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
@mathiaslubingu6927
@mathiaslubingu6927 3 жыл бұрын
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?
@learnbymohsin880
@learnbymohsin880 3 жыл бұрын
Sir ap ek behtreen Teacher hai
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@learnbymohsin880
@learnbymohsin880 3 жыл бұрын
@@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
@abillajob6003
@abillajob6003 Жыл бұрын
You are a great teacher. keep the good work and God will bless you.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@sharifulisl2084
@sharifulisl2084 4 жыл бұрын
Dear Sir, Really It’s nice. i wanna know that, how can entry manually sale rate?? pls pls...
@alfredho5518
@alfredho5518 3 жыл бұрын
I wish to know this too.....
@tsidekenugideon416
@tsidekenugideon416 4 жыл бұрын
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
@scientist100
@scientist100 3 жыл бұрын
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.
@azibmahmood9319
@azibmahmood9319 3 жыл бұрын
@@scientist100 how??????????????????????
@DynamicExcelAcademy
@DynamicExcelAcademy 3 жыл бұрын
I am VBA learner from your Channel.. Great Boss..
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@sadiamutahir9771
@sadiamutahir9771 3 жыл бұрын
Nice man i got best explanation of this topic only from ur channel,keep doing explaination on such types of topics
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@abdirahmanmohamed2295
@abdirahmanmohamed2295 4 жыл бұрын
I am a new subscriber for the sake of this amazing tutorial, which i was searching is the 48hrs. Thanks alot
@godamuleta7817
@godamuleta7817 3 жыл бұрын
thank u pk it is wonderful teaching . I hope those who want to learn vba will earn a lot !!!!!
@techcapital360
@techcapital360 4 жыл бұрын
Hats off to you Pk Sir. it was just mind-blowing. I never seen this before. From now, I am a big fan of you. And thanks for that as free. Love you...
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@SurajSuraj-rm2xq
@SurajSuraj-rm2xq 3 жыл бұрын
Congratulations for your effort love from Nepal 🇳🇵 ❤
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@ErminioGoodwing
@ErminioGoodwing Жыл бұрын
I have appreciated your huge and fantastic work. Congratulations
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thank you very much!
@rzeznikkeynes5686
@rzeznikkeynes5686 4 жыл бұрын
Your work is very simple yet very informative and helpful....
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@caseyemmanuel8517
@caseyemmanuel8517 Жыл бұрын
Thanks PK Your video is self explanatory
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome🙏
@MuhammadArshad-hh8nn
@MuhammadArshad-hh8nn 4 жыл бұрын
I think two more fields must enter first sale person sales record second customer wise receivable amount third reorder level of stock then it will be more helpful to the end users
@paighamofficial-0
@paighamofficial-0 3 жыл бұрын
Thank you for the polite request to put a project link in all your excel videos
@lanceozom
@lanceozom 2 жыл бұрын
helps a lot brother specially to my small business, thank you!
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Happy to help!
@technopabitra8576
@technopabitra8576 2 жыл бұрын
Pos With Stock management System Download Link: kzfaq.info/get/bejne/nayWq7Kl2LuxdZc.html
@ramdashwant2024
@ramdashwant2024 3 жыл бұрын
You are the best Sir. 🎊🎊🎊 Please keep making videos
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@rajibahammed9336
@rajibahammed9336 3 жыл бұрын
sometimes it was hard to understand but i did it........... thank you
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@jelajahsebanten
@jelajahsebanten 2 жыл бұрын
Good sharing👍👍
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks🙏
@kellyoku
@kellyoku 4 жыл бұрын
Wow! this is wonderful. Masterclass. Thanks PK.
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
You're most welcome!
@lgatura
@lgatura Жыл бұрын
Excellent !! great teaching skills and you have explained it so well . Keep up the good work
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Glad it was helpful!
@milfredalcalde7336
@milfredalcalde7336 Жыл бұрын
Thank You for this tutorial. More Power God Bless
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thank you🙏
@md.alaminislammahin4782
@md.alaminislammahin4782 9 ай бұрын
I am from Bangladesh love u sir
@sagarprasad1917
@sagarprasad1917 2 жыл бұрын
Thanks brother, Master of VBA
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Always welcome
@alimengal7868
@alimengal7868 Жыл бұрын
Amazing Sir ... Unbeliveable work ❤
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thank you so much 😀
@AZ-jr4pn
@AZ-jr4pn Ай бұрын
Thank you for the clear explanation, Pleaseseee, do you post Excel tutorials from beginner to Advanced videos Stay Safe
@melwinloza
@melwinloza 2 жыл бұрын
i was so amazed. very very detailed. hope you add also Delete Item Button. God Bless and hoping for more educational videos.
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks. Please watch the next part of this video: kzfaq.info/get/bejne/rp51gMaerNLYh3U.html
@emmsekyi27
@emmsekyi27 Жыл бұрын
hello your teachings are so helpful thank you
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome
@emmsekyi27
@emmsekyi27 Жыл бұрын
@@PKAnExcelExpert thank you but you will be my friend or?
@Life.Unscripted
@Life.Unscripted 3 жыл бұрын
Great video thank you development team really you make my job is very easy thank you again.
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@ahassan3
@ahassan3 2 жыл бұрын
Great video, this is really very professional tutorial, thank you Brother
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Glad it was helpful!
@technopabitra8576
@technopabitra8576 2 жыл бұрын
Pos With Stock management System Download Link: kzfaq.info/get/bejne/nayWq7Kl2LuxdZc.html
@raslandacreations802
@raslandacreations802 3 жыл бұрын
Superb Explanation... We will support u sir...
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@muhamedalipb4380
@muhamedalipb4380 Жыл бұрын
Very informative
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks🙏
@eidsoliman2805
@eidsoliman2805 Жыл бұрын
Hello PK, thank you so much for the shared knowledge you have. It is so wonderful, please keep it up.
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
It's my pleasure
@imlyrajouri4079
@imlyrajouri4079 3 жыл бұрын
thanks for the beautiful teachings.I have been learning this vba for the last three days through your channel.plz keep us teaching like this.
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thank you, I will
@muhammadatifafzal8998
@muhammadatifafzal8998 2 жыл бұрын
Very good software, Dear if you add expense tab and then calculate profit then its too good.
@bithibithi4989
@bithibithi4989 2 жыл бұрын
Absolutely amazing vedio
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks a lot
@manohartimothy5825
@manohartimothy5825 3 жыл бұрын
I loved and enjoyed it...You are great !!!! hope to see much more new program mes.......I am Manohar and wishing you anice evening.....
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@gautamrawal4348
@gautamrawal4348 3 жыл бұрын
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?
@sethsavimc
@sethsavimc Жыл бұрын
It 's a great tutorial. Thank you sir...
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Most welcome
@moncia9835
@moncia9835 Жыл бұрын
Thank you so much! You are the best! 😊😊😊
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@jacobkavishe7428
@jacobkavishe7428 2 жыл бұрын
Thanks! From Tanzania
@computertech246
@computertech246 4 жыл бұрын
you are great your videos are so amazing. M very impress
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Glad you like them!
@ephraimasiya7994
@ephraimasiya7994 2 жыл бұрын
Thanks so much for this explanation
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
You're very welcome!
@excel168
@excel168 11 ай бұрын
Great video.thanks
@PKAnExcelExpert
@PKAnExcelExpert 11 ай бұрын
Most welcome🙏
@howtogetayeshaaashu5025
@howtogetayeshaaashu5025 2 жыл бұрын
Amazing project wonderful ☺️ keep growing
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks a lot 😊
@howtogetayeshaaashu5025
@howtogetayeshaaashu5025 2 жыл бұрын
@@PKAnExcelExpert Sir I want to ask something?
@ihcet
@ihcet 9 ай бұрын
you are the best
@PKAnExcelExpert
@PKAnExcelExpert 9 ай бұрын
Thanks🙏
@shahparvaiz7415
@shahparvaiz7415 3 жыл бұрын
I loved this idea but i need little changes into it. Like you have Notebook of many companies & have different rates etc. Also it should automatically generated average pricing if you have old stock. Also it shud let change prices both automatically as well as manually. Apart from it, it should allow to let purchase or sale on bill basis as we may have many items in bill n we mus b known what product we purchased/sales from/to the person.
@SharmaMusic-ui9bh
@SharmaMusic-ui9bh Жыл бұрын
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
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
We will try to create such tool
@AbdulkadirTATAR
@AbdulkadirTATAR 3 жыл бұрын
Thank you for your sharing. Very nice work. It will be very nice if you add the Customer Section to this system
@tahirmehmoodmughal2535
@tahirmehmoodmughal2535 2 жыл бұрын
Really great Job..!! it Helped me a lot Learning..
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks for your valuable feedback🙏
@technopabitra8576
@technopabitra8576 2 жыл бұрын
Pos With Stock management System Download Link: kzfaq.info/get/bejne/nayWq7Kl2LuxdZc.html
@jasper5712
@jasper5712 3 жыл бұрын
Awesome,very informative,kindly include delete button,thank you
@sanjeevjogi6445
@sanjeevjogi6445 4 жыл бұрын
i love way u teach
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@christophershaji847
@christophershaji847 2 жыл бұрын
Hi Sir, This Is a wonderful Tutorial, Pls Give the training of sales( related Cash & Credit)
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Will do soon
@technopabitra8576
@technopabitra8576 2 жыл бұрын
Pos With Stock management System Download Link: kzfaq.info/get/bejne/nayWq7Kl2LuxdZc.html
@zedlav1335
@zedlav1335 Жыл бұрын
Great program to follow. I was wondering what are the characters infront of "validation, "check duplicate", "add data", and "clear boxes". Thank you.
@mdsoibe6282
@mdsoibe6282 2 жыл бұрын
Wow beautiful video ❣
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks🙏
@sev2810
@sev2810 3 жыл бұрын
Very great video, it helps me to create another project, thank you 🙏🙏🙏🙏 sir
@annamilanamyownversion
@annamilanamyownversion Жыл бұрын
Hi PK, you are amazing..
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@thiernoahmadbah3928
@thiernoahmadbah3928 3 жыл бұрын
Thanks a bunch, I have enjoyed this amazing video very well. So Congratulations for your efforts to help people ❤❤❤😍😍😍😍🥰🥰🥰👍👍👍
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@thiernoahmadbah3928
@thiernoahmadbah3928 3 жыл бұрын
Please how can I add a receipt of sales on this inventory management system ?
@sitaramrathi7483
@sitaramrathi7483 2 жыл бұрын
अध्यापकजी नमस्कार आपके विडियो बहुत ही ज्ञानवर्धक एवं शिक्षाप्रद है सभी को बहुत कुछ सीखने को मिलता है परन्तु आजतक पारिवारिक सदस्यों के रिलेशनशिप सम्बन्ध का डायनोमीक हाईपर लिंक का कोई विडियो नही बना है । आपके पास बना हुवा हो तो बताये नही बना हो तो बनाकर बताये जिसमें आई डी हो, स्वयं हो , पत्नी हो, पति हो, पुत्र हो, पुत्री हो, माता हो, पिता हो, सीटी हो, कास्ट हो, और भी बहुत से कांलम हो सकते है परन्तु पारिवारिक रिलेशनशिप सम्बन्ध के लिंक का फोर्म इतने में बन जायेगा कोई बात समझ में न आये तो पूछ लेना
@MCB8585
@MCB8585 2 жыл бұрын
🙏Thank you for amazing and helpful video. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Most welcome 😊
@technopabitra8576
@technopabitra8576 2 жыл бұрын
Pos With Stock management System Download Link: kzfaq.info/get/bejne/nayWq7Kl2LuxdZc.html
@MCB8585
@MCB8585 2 жыл бұрын
@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 🙏🙏🙏🙏🙏
@MCB8585
@MCB8585 2 жыл бұрын
I also practiced the same. Hats off to your hard work. Thank you 🙏🙏
@MCB8585
@MCB8585 2 жыл бұрын
@@PKAnExcelExpert sir found similar to your video...! kzfaq.info/get/bejne/gqhxfKxj0K26goE.html
@hichemboudali6168
@hichemboudali6168 11 ай бұрын
Just thank you
@PKAnExcelExpert
@PKAnExcelExpert 11 ай бұрын
Most welcome🙏
@ashkumar8012
@ashkumar8012 2 жыл бұрын
I just made different one following you works good love it Thanks a lot.
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Fantastic!
@sitaramrathi7483
@sitaramrathi7483 2 жыл бұрын
अध्यापकजी नमस्कार आपके विडियो बहुत ही ज्ञानवर्धक एवं शिक्षाप्रद है सभी को बहुत कुछ सीखने को मिलता है परन्तु आजतक पारिवारिक सदस्यों का रिलेशनशिप सम्बन्ध के लिंक का एक्सल में एक्सैस में एचटीएमएल में कोई विडियो नही बना है अतःआप एक फार्म ऐसा बनाये जिसमें आई डी हो, स्वयं हो ,पत्नी हो, पति हो, पुत्र हो, पुत्री हो, माता हो, पिता हो, सीटी हो, कास्ट हो, और भी बहुत कुछ लिखा जा सकता है परन्तु अपन को पारिवारिक रिलेशनशिप सम्बन्ध लिंक बनाना है वो इतने में बन जायेगा कोई बात समझ में न आये तो पूछ लेना
@sachithralakshani3509
@sachithralakshani3509 2 жыл бұрын
Well explained ... thank you so much....
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks for your valuable feedback
@damniamdaone
@damniamdaone 3 жыл бұрын
Thank you for making this available. This works great for purchasing and adding one item at a time. What do you do if you purchase/sell more than one item in a single transaction?
@hp7557
@hp7557 3 жыл бұрын
Thanks once again.. Very useful infos........
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@AnoopEdits
@AnoopEdits 3 жыл бұрын
your software is very rare
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@Jesterthe
@Jesterthe 3 жыл бұрын
Very good! But two small problems there: 1. Stock amount can go one - so i mean -50 PCS etc. 2. No delete function for items?
@dominicadomako2379
@dominicadomako2379 2 жыл бұрын
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?
@kevinbautista3151
@kevinbautista3151 Жыл бұрын
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.
@suhelsk5000
@suhelsk5000 3 жыл бұрын
The best tutorial on youtube. sir is it possible add a option to delete product from the list?
@tokamedia4063
@tokamedia4063 4 жыл бұрын
wow amazing.. great content bro.. salam creator excel from indonesia
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@rsiddique1584
@rsiddique1584 Жыл бұрын
Really best video in the youtube
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@rsiddique1584
@rsiddique1584 Жыл бұрын
​@@PKAnExcelExpert please sir i requested you to make the video in the hindi language please sir as a same video
@exclusivenews3
@exclusivenews3 4 жыл бұрын
Hello Teacher Thanks Alot For This Amazing Tutorial,
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@exclusivenews3
@exclusivenews3 4 жыл бұрын
Really i saw many Tutorials videos in Udemy too But, you have a best explanation , Thanks Again Allah Bless you
@exclusivenews3
@exclusivenews3 4 жыл бұрын
And I discovered Some things missing Like Delete Button, if you have this project complete, I can purchase from you 👍
User level security in Excel Workbook for different worksheets
45:18
PK: An Excel Expert
Рет қаралды 107 М.
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
17:59
PK: An Excel Expert
Рет қаралды 507 М.
Lehanga 🤣 #comedy #funny
00:31
Micky Makeover
Рет қаралды 29 МЛН
小丑把天使丢游泳池里#short #angel #clown
00:15
Super Beauty team
Рет қаралды 42 МЛН
If Barbie came to life! 💝
00:37
Meow-some! Reacts
Рет қаралды 67 МЛН
Inventory Management | Excel Inventory Management (Super Easy)
16:43
Microsoft Office Tutorials
Рет қаралды 1,5 МЛН
How to Run UserForm without Showing Excel Window
12:44
TheDataLabs
Рет қаралды 109 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 511 М.
Excel : How to create a simple warehouse management
8:10
NETVN82
Рет қаралды 120 М.
SUPER EASY Excel Data Entry Form (NO VBA)
6:22
Leila Gharani
Рет қаралды 2 МЛН
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
35:41
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 79 М.
Lehanga 🤣 #comedy #funny
00:31
Micky Makeover
Рет қаралды 29 МЛН