Sir good evening. I am your subscriber, and always watch your videos. Every one of your videos is informative. Can you make inventory for the department waise. I have six departments and I have to maintain their accounts. The details are as follows - Stock in Date ,Product Name, Received Qty, Gst, Price, T.Amount. Stock Out. Date ,Product Name, Department Name, Issue Qty, (Gst, Price, T.Amount.) optional Stock Balance Product Name, Bal. Qty, T. Amount. Thanks so much.
great sir agar search box ko purchase sale stock sheet main kerna chate hain to wo kese hoga.agar ap is sheet main search box bhi banana sekha dain to bhot acha hoga hum sub ke liye.
Dear sir thank you for this useful video and wonderful explanation word to word. But kindly please let me know can use this all function to operate with the mobile MICROSOFT office app, is it possible ???????
Inventory Management System in Excel | Excel Inventory Management (Without VBA) yeh wala aap banao please sir aap ka jo tarika hai woh kisi ka bhi nahi ho sakta
Excellent job Sir I made the same sheet with the help of your video but I'm facing a problem when the stock in date is changing in same sheet the serial number is showing some error. For example if 10 items are in one date, on another date the S. No should restart from 1 let me know how it would be possible
But sir Stock agar hamare pass kaam h eg.30 and hum sale kar rahe hai 40 toh stock ka value -10 hojata toh oose kaise handle taki stock value minus me na ja paye.
Inventory Management System in Excel | Excel Inventory Management (Without VBA);;;;;;; sir yeh viedo banao please mere liye bahout kaam ka hai yeh video himanshu agerwal ne banaya hai lekin woh mujeh samhj nahi aaraha hai please i rquest u please
Plzz Sir, अगर आप मैसेज पढ़े तो problem solve करें 🥺🙏 जब seriol no के लिए formula लगा रहा हूं तो seriol no "0" बार बार show कर रहा है 🥺😰😭 जिसके वजह से seriol no automatic सभी cells में नहीं increase हो रहा है, जब कापी करके sales में past किया तो वहा S no शून्य दिखा रहा है 🥺😭😰😰😭😭😭 क्या करूं 🙏🙏🙏🙏
Vinay ji ye complaint to abhi kisi ne nahi ki Aap please net connection check karo ya fir apna device Fir mai ye video ko mobile mai chala kar dekhta hu
Sir 1 no. Ke sheet banai hai.
Bahut dino se dekhna cha raha tha aise sheet ab ja ke mile.
Thanku sir.
Thanks
Bahut accha explain kiya hai sir,
Thankyou, it very helpful for me👍👍
sir u r best teching in the world mere liye aap se jaberdast koi nahi hai really
Thanks a lot🙏
❤️❤️❤️❤️❤️❤️❤️🙏🙏🙏🙏🙏🙏Bahut achchhe se bataya aapne
Thank you so much 🙏❤️❤️❤️❤️❤️❤️❤️
Thanks Ravishji
Sir good evening.
I am your subscriber, and always watch your videos. Every one of your videos is informative. Can you make inventory for the department waise. I have six departments and I have to maintain their accounts. The details are as follows -
Stock in
Date ,Product Name, Received Qty, Gst, Price, T.Amount.
Stock Out.
Date ,Product Name, Department Name, Issue Qty, (Gst, Price, T.Amount.) optional
Stock Balance
Product Name, Bal. Qty, T. Amount.
Thanks so much.
Sir alag alag date ko products buy hoga to bhi calculate hoga
Sir mai uae me timekeeper ke liye apply kar rahe hu ek time keeper ko kya kya uae me aana chahiye ishper ek complete video banaiye
sir bhot acha samjaya ap ne, agar main is sheet main, kisi toyoyta company ki dealer ka sale/purchase profit and lost sheet banaon to kia kerna hoga ?
Ji kaam karega
Excellent job Sir I made the same sheet with the help of your videos.
Thanks for watching.
Dear sir agar product description or model no bar bar same entry karna hai to kya karenge
great sir agar search box ko purchase sale stock sheet main kerna chate hain to wo kese hoga.agar ap is sheet main search box bhi banana sekha dain to bhot acha hoga hum sub ke liye.
Dear sir thank you for this useful video and wonderful explanation word to word. But kindly please let me know can use this all function to operate with the mobile MICROSOFT office app, is it possible ???????
Inventory Management System in Excel | Excel Inventory Management (Without VBA) yeh wala aap banao please sir aap ka jo tarika hai woh kisi ka bhi nahi ho sakta
Sir Debit and credit banking passbook entry macro with botton kaise kare ek video karea .
Koushik ji
Thoda bimar ho gaya tha
@@PowerExbyJitendra no problem. Avi kaisa hain sir?? aur banking debit aur credit kaise kare ek video dizia
Abhi Thoda thik hu
Ye topic maine note kar liya hai jaldi hi frame karta hu
@@PowerExbyJitendra ok sir
Excellent job Sir I made the same sheet with the help of your video but I'm facing a problem when the stock in date is changing in same sheet the serial number is showing some error. For example if 10 items are in one date, on another date the S. No should restart from 1 let me know how it would be possible
I want new date on top means old date should be below , plz tel how this possible...
Hum daily up ka stock management dekhte hai. Formula humko for se sumjha e a pl.
Thanks a lot.
Welcome
Congratulations for 10k subscribers 👍🏻😊
Thanks Raju
Please do one video insert row, like invoice sheet which is blank we need to delete and we should insert also row should be automatic
Sir wear house ka kam kaisa hota hai storekeeper ka store keeper ko kia karna hota hai please sir boliye
But sir Stock agar hamare pass kaam h eg.30 and hum sale kar rahe hai 40 toh stock ka value -10 hojata toh oose kaise handle taki stock value minus me na ja paye.
agar apki pass stock 30 hi tu 40 kisy sale karogi yar just use common sense.😃😀😄
@@AbidHussain-fb1si 🤣arey bhai exception aara ho toh pucha ok 100 different stocks h mere pass 4,5 nahi
Thank you sir!!
Welcome
Super🙏🙏
Thanks
Sir need add same more options like profite lose colam
Serial number का function invalid बता रहा है क्या करना चाहिए @date highlight हो रहा है
Insert formula carefully, you can watch video seperately for serial nuumber automation.
@@PowerExbyJitendra अगर हम 10 या 150 का list select करते हैं और उसके बाद अगर 11 या 151 वा प्रोडक्ट आए तो कैसे extend करेंगे
thank u sir..
Welcome
Nice Teach❤🇳🇵🇳🇵🇳🇵
Thanks a lot
Wow Very Good Sir
Thanks Rajinder ji
I didn't get new entryof product in drop-down list and date issue still with me
Please explain oil changing management
Ji
Thanks you so much sir 🙏🙏,
Thanks Nagendra ji
if coffee alag alag brand ka honga to kashe maintain karenge
Coffee ke aage brand ka naam likhna hoga
Inventory Management System in Excel | Excel Inventory Management (Without VBA);;;;;;; sir yeh viedo banao please mere liye bahout kaam ka hai yeh video himanshu agerwal ne banaya hai lekin woh mujeh samhj nahi aaraha hai please i rquest u please
Thanks, मैं ऐसा ही ढूँढ रहा था ताकि monthly sheet ना बनानी पडे, but अगर इसमे 15 list के बाद 2 महीने बाद नया प्रोडक्ट जोड़ना होगा तो कैसे करें??
Net stock me jake sirf product name type karna hai aur product automatically drop down list me purchase and sale section me bhi update ho jayega
@@piku8700 OK will try 😀 tomorrow
@@piku8700 thanks
Superb sir 👌👌👌👌
Thanks Deepak ji
Monthly basis stock reports kese banayega with material location
Sir iss file me profit/loss bhi add kar dete ....pls
New purchase on same item kaise entry kare
Sir, Add banded rows separate for purchase, sales and net stock
I have made video on it please watch:
ua-cam.com/video/DaBFBE9t6KI/v-deo.html
thanks sir
Thanks a lot
Sir if formula fixed karke jab date dal raha hu toh 0 q dikha rahi hai please help sir
Sir ye sheet download kese kare
Thank you ❤️
You are welcome Vishal
Thanks Sir
Welcome
mera =if Our Date Function Nahi Aaraha hai kiya kerna hai sir first s.r no ka
Abdul ji,
If function to aa raha hai ya nahi
Nahi aaraha hai
सर जी यह डेटा टेबल और एक्सेल टेबल में क्या फर्क होता है ?
Excel table data ko ek sath group karne ka ek powerful feature hai
Data Table vo hai jo aapne excel sheet mai banaya hai
Sir ye ready sheet mil Jaye gi
Ha ji aap mail id share kar do
Date wala option nahi le raha hai sir
Plzz Sir, अगर आप मैसेज पढ़े तो problem solve करें 🥺🙏
जब seriol no के लिए formula लगा रहा हूं तो seriol no "0" बार बार show कर रहा है 🥺😰😭
जिसके वजह से seriol no automatic सभी cells में नहीं increase हो रहा है,
जब कापी करके sales में past किया तो वहा S no शून्य दिखा रहा है 🥺😭😰😰😭😭😭
क्या करूं 🙏🙏🙏🙏
Please send your file I will resolve this issue.
Mail address is given in about section
Shit.. its works 💪 thank you sir 🙏 it will help me to maintain my stocks
Nice
Thanks ji
Formula error aata ha please any solution?
Aap ki video clear hi nhi dikhti h sari video aise hi h bhai
Vinay ji ye complaint to abhi kisi ne nahi ki
Aap please net connection check karo ya fir apna device
Fir mai ye video ko mobile mai chala kar dekhta hu
Sir s.no.me 0 hi so horaha hai thada help Ker do
Need your help
mera Baar baar error Araha hai kiya kerna hai sir
mai mujeh khuc samjh nahi aaraha hai please please sir khuc reply karo sir
D cell #name? araha hai. please help...
Bhaiya j6 kyu lia adress
❤❤❤❤❤❤❤❤❤❤❤❤
Thanks a lot
Apka no chahiye bhai
reply karo sir please i m waiting
🇳🇵🇳🇵🇳🇵🇳🇵
Thanks
Video have poor results
Nice