Sir I m working in Labratory. We purchase from suplier in bulk qty. Example.. We buy kit 5 boxes. one box has 40 kit.. Now we use only one kit whenever its needed. How to maintain such stock box as well as loose item.....???
*VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM Please make one like I mention Below: 1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return ) 2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually
Plz help me with the formula for data extracted from the two drop down menus, if I have a purchase something from a vendor and there are 5 vendors in my list and there is a drop down list of items also so from the item dropdown list and from the vendor dropdownlist how can I extract information of one item and a particular vendor
Sir it is super very simple but every small business people can use this kind of excel report thank you so much One more pls tell me how enter invoice wise stock out report please help me
I make this excel sheet as u guided in video but facing some problem..in balance column first five six cells working with formula remaining not working... How I can solve this
Good Morning sir, Muje apne factory k production(sweet/namkeen) ka stock maintains karna hai. Humare pass software hai but ek manual data humare pass rhe day wise cross check k liye uske liye apka help chahiye.
Sir inward range main first letter likhte hi stock select nahi jota plz tell me how to select in short cut because we have 1000 stock item it is very difficult to find by mouse click or scroll
sir , iss sheet main maine opening stock ka bhi column banaya hai,toh stock inward main add hoke aa jaata hai par jab wahi net stock inward ke column ko net stock ke liye use karte hain toh woh nahin hota ,pls help kijiye
Thnku sir , actually mujhe puchna tha sir aap ek video bna do jisme kgs and GM's me stock aata h in and out hota h morning and evening ke hisab se wo sheet kese bnegi ....
agr 10 item h uska Maine aapke tarah bna liya sabkuch kr liya formula sb set kr diya 10 no tk agr baad me aur 20 ya 50 item aayega to kaise sare item aur formula set krenge
Inward stock outward stock tatha balance stock ke sath ismein opening stock aur closing stock bhi dikhai de tatha rank number bhi mil jaaye to bahut achcha ho jaaye
Watch latest video about stock management - th-cam.com/video/sejct_QtmOs/w-d-xo.html
Need ur help sir...
Sir I m working in Labratory. We purchase from suplier in bulk qty. Example.. We buy kit 5 boxes. one box has 40 kit.. Now we use only one kit whenever its needed. How to maintain such stock box as well as loose item.....???
0:42 0:43 0:44
*VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM
Please make one like I mention Below:
1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION
Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return )
2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually
कल मुझे इन्वेंटरी की सीट बनानी है और ये वीडियो मेरे लिए बहुत हेपलफुल होगी।। धन्यवाद ❤
Aapka trika bhut acha hai smjhane ka bhut eazy way se samjate ho aap
Excellent .....Very Useful Video It solved my problem...Thanks a Lot...God Bless You🌹🌹
I really appreciate,
nice explain.
thank you 🙏
Bhot sahi yrrrrr great knowledge
Very useful sir , Thanks for the information
Thank you sir this video very helpful ❤️👏
excellent. Actually, I opened a small business and I really need this type calculations.Best wishes from Kapurthala, Punjab.🙏
Good work Easy giddiness.🥰
Thank you so much it really helps
Only u are best youtube
Finally found formula here.. thank you so much bro
Bhàiii bht achhi vedio thi
Thank you so much, very helpful and something I needed.
Use Full Video thank you Sir
Thank you so much sir❤❤
Thx❤
Bhai bht zbrdst 👍👍
Actually it's add real value brother
Thanks Sir, the video is very helpful.
Thank you it's help for me
Thank you very much for your valuable information!
Thank you so much I don't how can I I tell you these is very useful to me..
Plz help me with the formula for data extracted from the two drop down menus, if I have a purchase something from a vendor and there are 5 vendors in my list and there is a drop down list of items also so from the item dropdown list and from the vendor dropdownlist how can I extract information of one item and a particular vendor
THANK YOU FOR YOUR VALUABLE VIDEO
I did it very helpful sir, Thanks 👍
Best teaching skills ….
Thank sir for making this type video
Thank u Sir..✍️🤲
Very helpful video
Bhout acha bataya hai bhai
It actually helps full nice
Very helpful 👌
Bahut achha laga sir
Thanks 🙏🙏🙏
Very useful..
Sir it is super very simple but every small business people can use this kind of excel report thank you so much
One more pls tell me how enter invoice wise stock out report please help me
Thank You Vinay. I will check it will feedback you
Super bro❤
Sir agar mere pas 100 item hai maine sab par formula laga liya uske bad agar mujhe usme aur item jodna ho to
Very very good🎉
very help ful video thanks sir
I make this excel sheet as u guided in video but facing some problem..in balance column first five six cells working with formula remaining not working... How I can solve this
Copy that formula and paste it to all remaining columns where u r getting issue
Good ❤❤❤❤
Thankyou ❤
Har month pe new sheet banana padega kiya ek pe hi infinity ke liye nehi use kar sakte kiya pls reply
Sir or assan tarika batiya..hum to sirf Excel khol sakta hee ji...stock sheet.. important hee
I'm watching the video at the moment
Thanks 👍❤sir
Hi sir muze kg , meter , nos , mai closing stock nikale , sab material alag alag unit mai hote hai .......
Hello sir muje inward outward samaj me aaya yadi pahle stock pada he to use kese aad kare pls bata sakte he sir
th-cam.com/video/eyX487HrXFE/w-d-xo.html
SUPER BHAI
Super sir 💯🙏❤
Sir stock work ke tafsealin video baney ❤❤
Thanku sir ❤️
Thank you for this vdo
Thank you Sir 😊
Which battons is pressed after "sumif" >then choosing the range?
Usefull knowledge
Kya ismein closing balance aur opening balance jod sakte hain
very helpful vedio thanks
Thank you 🙏
Subscribe kor Diya thanks
Sir drop down me 150 item ho to frist letar vais item aa sakta he ki 150 item aayega..
Keep it up bro
Sir quantity nahi ho paa rehaahai
Good Morning sir,
Muje apne factory k production(sweet/namkeen) ka stock maintains karna hai. Humare pass software hai but ek manual data humare pass rhe day wise cross check k liye uske liye apka help chahiye.
Nice Sir, Thank you
sir sale or purchase different sheet mai to month wise kaise fomula lagayenge stock summary mai
Sir one question agar koi new item aati hai toh usko list me add kese krenge jisko arrow ko click kr k shortcut me ajay
Nice very helpful
Aese hi e-will per ek video bana dena please sir
Videos is excellent but how will be add Opening stocks after closing of Month
Watch this video - th-cam.com/video/sejct_QtmOs/w-d-xo.html
Or bhai koi new stock add karna hoga to kaise karenge isme
Nice 👍
great work
Very good bhai
Thanks 😊
Use full video
Very nice thank you
Thank you so much bhai
Drop down me bahoot sare item ho to kaise surch karen
Kiya filter laga sakte hain
To kaise filter lahaen
according to name, how will you do it?
Jaise Alex John mickle ko kitni stationery items diya
Thank you for your help.
Thanks sir❤
I looking part number before goods name .. how i can picked both without repition
I have 250item zc but when i want to inward. It will difficult to find items, send me filter setting formula in this sheet, in inward
we can use filter formula for a single cell, not on entire sheet. I work on it and as soon as possible i will share the same.
Asslam Alikum sir video is very nice and very helpful sir ak cheaz pochne hay ky balance stock alag sheet per a Sakta hay
Wa alaykumu s-salam, ji aap kar sakte jaise waha formula lagaya hai waise hi kisi dusri sheet par laga dijiye
@@Excel4Freshers thanks
जो सॉफ्टवेयर खरीदेंगे वह सॉफ्टवेयर है या यही है क्योंकि मुझे खरीदना है plz
Sir inward range main first letter likhte hi stock select nahi jota plz tell me how to select in short cut because we have 1000 stock item it is very difficult to find by mouse click or scroll
sir , iss sheet main maine opening stock ka bhi column banaya hai,toh stock inward main add hoke aa jaata hai par jab wahi net stock inward ke column ko net stock ke liye use karte hain toh woh nahin hota ,pls help kijiye
Thank you so much sir
Thnku sir , actually mujhe puchna tha sir aap ek video bna do jisme kgs and GM's me stock aata h in and out hota h morning and evening ke hisab se wo sheet kese bnegi ....
Kg ko gms mei convert kigiye
Very nice
agr 10 item h uska Maine aapke tarah bna liya sabkuch kr liya formula sb set kr diya 10 no tk
agr baad me aur 20 ya 50 item aayega to kaise sare item aur formula set krenge
Inward stock outward stock tatha balance stock ke sath ismein opening stock aur closing stock bhi dikhai de tatha rank number bhi mil jaaye to bahut achcha ho jaaye
Sir excel ke andar possible nahi hai. Ek free software hai uske upar humne video banaya hai. Iss software main hum dekh sakte h
The link you have given perfectly but I'm facing a problem with opening stock
Sir plz remake with Opening Stock
Nice jankari
Agar isme ek colam or aad kre to kya fir bhi aase hi work kre ga kya
Ji haa karega
bro I have 30 iteam 24 iteam automatically formula working after 25 row formula not working on your file pls help me how do fix
Great tutorial 👌
Thank you bro