Perfect information.. as per ur gauid line i created file as per my requirements... N its work. But have one problem when we closed file and reopen it than maicro can no run... N even didnt see in view mairco who we saved before..
Thanks bro Please save file as Excel Macro Enabled workbook. It will definitely work. Please watch the below video, at the end you will know it very well ua-cam.com/video/weBuCZWrcTM/v-deo.html
Yes sir definitely, you may watch our video Stock Management Part 2 in which I have created drop down of items list. Link is below: ua-cam.com/video/DaBFBE9t6KI/v-deo.html
Hi sir hope that u will be fine! Sir Please also include Total, Previous, Paid, Closing Balance for Sales Costumers and also include paid closing balance for purchase option in this system
Sir, Thanks for such an informative video, Just wanted to know, this is the case when, say i have a new establishment and i am entering the data 1 by 1, what if i already have a established shop, and i know the list of products that I have already mastered, can we create a dropdown list, for item name, if yes, how do we do that?
Yes you can create drop down list of your products. You may watch our video on drop down list by clicking on following link: ua-cam.com/video/YQEGlaghtBI/v-deo.html
@@PowerExbyJitendra I can say you Beta !, because I have been using Computer since 1970 !!.. From Card Punching IBM, then using PC of 20MB Memory !...Journey to FORTRAN, dBASE, Foxpro, Clipper, Lotus 123, Developed Many Programs, MS WIndows...a great invention of our time, then learning C, C++ at the age of 54, from Vijay Mukhi...taught C of Kanitkar, but...but... it is not possible to keep pace with Information Technology, trying now Excel, Applying it, gained expertise....so at 71+,....I have a right to bless you, so gave blessings. Keep it Up. HE who teaches, without any rewards, to one and all becomes real Shishya of Maa Sarswati to gain more and more blessings and knowledge from Her. I thought you will write some code for all buttons, but learnt new methods of using Hyper Link and Macro Recording from your Video...KEEP IT UP......and impart knowledge to many, all over the Globe ... Once more.... God Bless You !!..... Harshad Vegda.
You can definitely call me son. I am nothing in front of you. You have very log experience not only of computer but also of life. It is your greatness that you praised me. Otherwise I am nothing. I want to thank you with folded hands for your kindness and your blessings. I want you to stay connected with me forever. With Best Regards Jitendra
kuwait me dekh raha hoon tumhara viedo aur main start ker raha hoon new buiesnes kuwait me tumhara video mere liye bahout help full rahega please aisa video excel ka our viedo upload karo please
@@PowerExbyJitendra sir thank you for your reply.iam having a little problem ,hope you can help me out.till macro recording it worked good but when i enter data in purchase or sales it doesnt go further and show error.
hello, sir you did an amazing stock management!!! GREAT JOB... I follow all your steps but I still having problems .... when i save it and open the excel file again it does not let me !!! like when click ( purchase or sale) doesnt work!!!! can you please help me out...
i save it and when the next day i want to updated the ( purchase or sale ) does not click and says " the macro may not be available in this work book or all macro may be disable " !!!!! please help help help. thanks
awesome just wow i was looking for this type of tips since years.i wish you can show us how to get reports and purchased items for each project with credit or cash feature.
Very nice sir..ur way if explaining is tooo good sir...sir yahi formula manufacturing process ke liye bhi batao jahan raw material purchase hota hai aur product taiyar hone ke baad uska name change ho jata hai..saath hi raw material ka alag stock aur finished goods ka alag stock kaise mantain karein
Good explain I have query about entry submit after purchase or sales click by mouse any setting possibilities to press any special key to press purchase or sales.
Quick Book Accounting Software Complete Course Class 1 Total 29 videos Every week 2 videos will be uploaded Subscribe channel for complete course & press the bell icon Click on this link ua-cam.com/video/g5rWrOc4gM8/v-deo.html And for complete Accounting & Excel course subscribe channel
Easily explained in a professional way. Thank you very much 🤗👍
Thanks Brother
Wah Kya Baat. Kitni achchi tarike se sab kuchh step-by-step sikhaya. Thank You, Sir.
Green Purchase Button= Purchase Register; Orange Purchase Button= Purchase Entry
Green Sales Button = Sales Register; Orange Sales Button= Sales Entry
Green Stock Button= Stock Register
Perfect information sir ji,need more information ..
Thanks Sandip ji
Computer band hone ke bad micro kam nahi karta hai
आदरणीय, आपके द्वारा, निःशुल्क शिक्षा दान के लिये, आपका श्रद्धापुर्वक हार्दिक आभार/अभिनंदन।
Hi sir very advanced Nd professional VDO
But sir multiple item ki entry kaise karenge ek bill ho kyi sare item ho
ua-cam.com/video/PIdPczs8Xoo/v-deo.html
Salute you man....You helping More and more peoples.... God Bless you...Thanks a lot
I would like to thank you for your blessings and love.
very professional video.. otherhan other excel guru
Your teaching on data entry form without vba..is a great help for me..🙏🙏🙏
Thanks
Perfect information.. as per ur gauid line i created file as per my requirements... N its work. But have one problem when we closed file and reopen it than maicro can no run... N even didnt see in view mairco who we saved before..
Thanks bro
Please save file as Excel Macro Enabled workbook. It will definitely work.
Please watch the below video, at the end you will know it very well
ua-cam.com/video/weBuCZWrcTM/v-deo.html
@@PowerExbyJitendra sir how to create beautiful attendance sheet in excel
nice information
Bahut easy orr simple way me aapne samjhaya h
Thanks
can i input order details by selecting from drop down and same data i can transpose to respective sheet
Yes sir definitely, you may watch our video Stock Management Part 2 in which I have created drop down of items list.
Link is below:
ua-cam.com/video/DaBFBE9t6KI/v-deo.html
Very easy, not required basic excel knowledge, great video thanks 👍
Hi sir hope that u will be fine!
Sir Please also include Total, Previous, Paid, Closing Balance for Sales Costumers and also include paid closing balance for purchase option in this system
Thank you... Because of you I solved my Biggest problem. Thank you Sooo much. I'm glad that i watched your video.
Sir, Thanks for such an informative video, Just wanted to know, this is the case when, say i have a new establishment and i am entering the data 1 by 1, what if i already have a established shop, and i know the list of products that I have already mastered, can we create a dropdown list, for item name, if yes, how do we do that?
Yes you can create drop down list of your products. You may watch our video on drop down list by clicking on following link:
ua-cam.com/video/YQEGlaghtBI/v-deo.html
@@PowerExbyJitendra Sir how can I cancel or delete wrong entry
Very impressive sir ,I have made more advance with the help of your video thank u sirji ....
Again thank u
What a very short method explained for a very big job !!!. SIr, Congratulations. Many Thanks. God Bless You.
Thank you very much Harshad Bhai
God bless you
@@PowerExbyJitendra
I can say you Beta !, because I have been using Computer since 1970 !!..
From Card Punching IBM, then using PC of 20MB Memory !...Journey to FORTRAN, dBASE, Foxpro, Clipper, Lotus 123, Developed Many Programs, MS WIndows...a great invention of our time, then learning C, C++ at the age of 54, from Vijay Mukhi...taught C of Kanitkar, but...but... it is not possible to keep pace with Information Technology, trying now Excel, Applying it, gained expertise....so at 71+,....I have a right to bless you, so gave blessings. Keep it Up. HE who teaches, without any rewards, to one and all becomes real Shishya of Maa Sarswati to gain more and more blessings and knowledge from Her.
I thought you will write some code for all buttons, but learnt new methods of using Hyper Link and Macro Recording from your Video...KEEP IT UP......and impart knowledge to many, all over the Globe ... Once more.... God Bless You !!..... Harshad Vegda.
You can definitely call me son. I am nothing in front of you. You have very log experience not only of computer but also of life.
It is your greatness that you praised me. Otherwise I am nothing.
I want to thank you with folded hands for your kindness and your blessings.
I want you to stay connected with me forever.
With Best Regards
Jitendra
The most helpful video I have ever seen thank you so much sir❤
Thanks a lot
Monthly items wise sale purchase kaise dekha jate hai sir
Tumhari information good sir👍🙏
maine aaj kar ke dekhaya yeh same 😀
Ok thanks
@@PowerExbyJitendra or v excel ka video banaiye sir
Great
kuwait me dekh raha hoon tumhara viedo aur main start ker raha hoon new buiesnes kuwait me
tumhara video mere liye bahout help full rahega please aisa video excel ka our viedo upload karo please
Ok Abdul ji thoda bimar ho gaya tha isliye video upload nahi kar paya ab aap continue video dekhoge
Please continue your kind support
grt explanation. was searching for such a video.
Thanks
im From pakistan,wanted to make something like this for my clinic,im doing it with your video,its great.bundles of thanks
You are welcome sir
@@PowerExbyJitendra sir thank you for your reply.iam having a little problem ,hope you can help me out.till macro recording it worked good but when i enter data in purchase or sales it doesnt go further and show error.
Really nice information and useful for stock management
Thanks Kishor ji
👍demonstration is nice thank u
Excellent tutorial. So helpful. Thankyou verymuch.
Thanks🌹
Best tutorial...and best faculty...very easy in learning....thanks a lot sir....
Very much thanks
Very good explanation
Very useful trick and nice explain
Thanks Sir
hello, sir
you did an amazing stock management!!! GREAT JOB...
I follow all your steps but I still having problems .... when i save it and open the excel file again it does not let me !!! like when click ( purchase or sale) doesnt work!!!! can you please help me out...
i save it and when the next day i want to updated the ( purchase or sale ) does not click and says " the macro may not be available in this work book or all macro may be disable " !!!!! please help help help. thanks
Dear please save the file as Macro Enabled Workbook
Sir! How to save stock management excel document.
Please say.
Thank you!!❤️❤️❤️
Thanku So Much i like ur video i want learn all ur viedos
It is so kind of you abdul ji
Very impressive.
Sir, agar hum porani entries ko remove karna chahain tou woh kaisay karain agar delete kartay hain tou phir problem aanay lagti hai.
Sir mai apka fan ho gya hu sir
Thanks a lot Bharti ji
1 like from my side
Thanks Piyush
Thanks a lot make more video excel for freelancing
awesome just wow i was looking for this type of tips since years.i wish you can show us how to get reports and purchased items for each project with credit or cash feature.
Sir Bahut aachha hain Ye trick
Thanks Yadav ji
Excellent explanation fabulous, superb
Thanks Anjum ji
Very nice sir..ur way if explaining is tooo good sir...sir yahi formula manufacturing process ke liye bhi batao jahan raw material purchase hota hai aur product taiyar hone ke baad uska name change ho jata hai..saath hi raw material ka alag stock aur finished goods ka alag stock kaise mantain karein
Sir, Very Nice.
One Issue is that, how to hide Purchase, Store Sheet in Worksheet after Macro assign ?
Good explain
I have query about entry submit after purchase or sales click by mouse any setting possibilities to press any special key to press purchase or sales.
really appreciated video.....i was searching free stock software......but after ur video my searching is stopped
It is a privilege for me.
You are powerful idea for excel
Thanks ji
HI Jitender, you have explained, it very well and in easy words. Excellent job and keep up the great work... Big thanks
Sir really easily teach
May Allah Bless you Dear Brother. Excellent job done by You. Got 5 Starrrrrrrrrrrrrrrr.
Dear Naeem,
So much thanks for your wishes.
Thank you so much,this is very helpful for me .
Thanks 🙏
Great bhaii 🤘👍🤲
Thanks ji
Well done boos keep it up gain more knowledge thanks for your support
This is aslam
Thank you so much Aslam bhai
Wow sir thank you for this tutorial. I hope you can make a tutorial for customer profile , amount purchase and contact number with search bar..
Finally macro run krna aa gya or save v thank you so much 🙏🙏🙏
Mujhe bahut khushi hui Abhishek ji
Kamal ki trik hai sir good
Thanks
Thanks for help sir... It's useful for me to maintaining stock in company where I'm working 😊
Very good presentation
Thanks ji
Super se upar sir.
Thanks a lot
JB
Very nice presentation!
You are doing great!
Thank you so much❤
Really helpful 👌
Thanks
Very nice and informative. Thanks
Thanks bro
Beautifully explained.
Excellent.
There are thousands videos on Excel learning but this is wonderful.
It's your pleasure
Quick Book Accounting Software Complete Course Class 1
Total 29 videos Every week 2 videos will be uploaded Subscribe channel for complete course & press the bell icon
Click on this link
ua-cam.com/video/g5rWrOc4gM8/v-deo.html
And for complete Accounting & Excel course subscribe channel
Very good information....
Cafe ka stock maintain plz bataye
Thanks
Thank You sir when i write sumif criteria is hidden can u tell me the problem?
Curent Sale ka calculate or bill print ka bhi video de dijiye
👍Pleasant video
Thank you 💫💫💫💫💫
Thanks Abid bhai
Sir agar next day main fir sa entry Karu to ya same macro came karaga?
Very Helpful Video sir . Thanks
But how can i protect our files
V.nice Thank You Sir 🇮🇳🇮🇳🇮🇳
Phly ye column banana hai sales purchase ya ye automatic Bana hua hy
Great video sir ji
Nice work. Sir ya file save ni kr skty kia..?
very good teaching
Can you guide us if in a single purchase bill multiple items and same as in a single sale bill then how to make.
I TRY AND SUCCESSFUL FOR YOUR VIDEO
THANK YOU
Great👍
Hi it was really help for me and i did it for first time and my friends like it very mush appreciated me
Can you create Macro for Break event point
Kya isme product image add kar sakte hai please bataiye
I appreciate your efforts
Thanks Mirza ji
Sir I want suggestions for my Business Account's
Thankyou
Very important info
Welcome sir
Good explain bro
Thanks Shoban ji
Isme profit & loss bhi rhta to bhut achha rhta
Waise
Good information 👍👍
Thank you Nivash
can you make a video tutorial about multiple sales, 8 product sales entry for 1 customer.
Hi Jitender Thanks for your Tutorials Please write tutorials for Budget , Expense trackers and Banks Transactions ....
Thanks a lot
Have Good Day
Thanks a lot
Very helpful video. Thank you.
Thanks
Big thanx for this tutorial
Big thank for you🙏
Aur ha jo data transpose kr k copy kiya hai purchase aur sales sheet me wo remove karne k baad bhi kya uske upar wale row koi changes honge
The best way to teach
Thank you so much
Hiiii....hopefully you doing great....
I do step by step...but when I enter in stock in hand step....it shows zero...don't know why...please guide
Thank You Sir ALLAH apko kamyab kry
Aapko bhi Ramzan bhai tarakki aur kamyabi hansil ho
Nice tutorial sir but i have facing an issue that is Run time error 438 ...plz make a video fir debugging it
Can I prepared by using 2007 excel?
I'm from sri lanka.thankas bro
Thanks for watching
Plz make video for on bakery recipe and inventory
THANKU sIR aAJ dUA kARUGA aAPKE liYE BAHUT hI aMAZING
Mai bhi apke liye dua karta hu aap hamesha khush rahe
Very Nice And Professional Work
I Like Your NEW idea Vedio 👍
Thanks Trivedi ji
aisa video banaiye jisme customer sell details bhi add Ho jaye with bill no ke sath
Ok ji
Jitendra ji the way you explain is awesome. Keep posting such videos.
Thank you so much Ashok ji
very very useful video sir
Thank you Dipak ji
Sir Stocks sheet main stocks ki entry pehle se hi Karke rakhna hain kya...pls samjayiye
Yes 1 entry rakhna zaroori hai
nice teaching sir continuous on
Thanks very much Alamgir ji
,💛✨💚love you bro💛✨💚
So much thanks for your love