Hi sir kya aap hame help kar sakte hai Ye formate ready hone ke bad jab file close karne par dobara open karne ke bad micro record kam nahi kar raha hai
Sir all your techniques is very good but think of a retail shop , where we purchase and sale n numbers of items in one invoice... kindly guide how to make it happen.
आदरणीय सर, आप का विडियो देख कर बहुत अच्छा लगा, मैं आप से यह जान्ना चाहता हुँ कि खरीदि शीट ( Purhase sheet) और (बिक्री) sales sheet में एक साथ बहुत सारी एक से आधिक entries कैसे कि जा सकती हैं।
Thank you so much sir ap ny bht easy way me samjaya hai, but i'm having a problem. Jab me second or third sales enter karta ho wo usko balace me se minus nahi karta. please guide on it.
Jazak Allah Sir, Aik request hay k is may jo b new entry hoti hay wo sab sy uper ati hay let suppose agar hum ya karna chahy k jo b new entry ho ho tarteeb k lihaz sy bad may ay wo kesay karin gain please.
Sir aik formate bana k guide kry hum ko daily bill notes na krna pry or daily amount b add krni h customer kii For example Bill num ,party name, amount ,recovery
hi.. nice.. i've try this file.. but at stock sheet, even i've already fixed the range, after the new data was input, the range change, shifted down. how to fixed the sum range?
Shadab bhai video acha hai aur simple b pr agr purchase, sale kia hai tou Debtors & creditors b hona chahiye tha. Saat mai Inventory kuch purana b ho sakta hai aur saat mai profit b hona chahiye.
Hi sir how are you? Sir mene btana tha k me dhaga nalki ka kam karta hn or mene isi video se dekh karbik sheet bnai thi lekin meri jo item serial bohat ziyada hain Ap se darkhwast hai k ap time laga k ik nalki manufacturing ki stock managment and sales hain us pe bhi video bnain plzzz
achha sir, sabse pehle aapko thank you is video k liye. Lekin sir aur ek upay isme bata dijiye ki agar koi product 200kg purchase kiye hai. aur 1 baar mein 100kg phir dusre baar mein 50 kg aur tisre baar mein 15 kg aur baaki ka product jitna kgs bacha hai, utna ka sales kar denge toh sir, stock mein bhi toh badlav hona chahiye na par nahi ho raha hai. upay bataye
Can you guide me... there an error ..data enter krne k bd sale ya purchase buttons pe jb click kr ry hain tu 'object does not support this property or method a raha hai... how to resolve this??
Sir main nay same formula apply kiya tha magar bas sab upar jo product hai us ka sum theak ata hai magar baki Sara zero ata hai. Please suggest me what I can do
bahi mujay same iis tarah ka dat entry project chy but autmtic calculation bi kareen then data save karay for example sale --- item detail---- qty----- discount------ sale tax 17% ------- net amount plz reply soon
sir excel me esa koi software banaen k jis me business ki parties add kr saken or jo jo stock ya saman den tu wo date by date add krty jaen or koi id h ya koi ot method banaen k wo id ya name ya number dalen tu us party ka khata open hojaey automatic total hota jaey
आप से मेरी गुजारिश है आप एक ऐसी वीडियो बनाएं जिसमें मोबाइल शॉप से जुड़ी हुई सभी चीजें जैसे की मोबाइल रिचार्ज मोबाइल रिपेयरिंग मोबाइल सेलिंग मोबाइल एक्स वेरी सेलिंग परचेज इन सब का इस्तेमाल कर सके
Agar hum 2 jaga sale kar rhe he ..jese ki 1-F1 bej rahe he ar 2- f2 me to dono ko - karke kitna stock baja wo check karna he to kese kare ..kansa formula lagega - ke bad
You didn't tell us about excel mode in which mode we should create or save it. Because on the time of saving the document there is a message comes about it.
Thanks you very much sir, I have a problem with ma system when I saved on purchase sheet it shows Run-time error '438': Object doesn't support this property method plz help me
Assalamu Alaikum, @Shahab_Bhai sheet maine taiyar ki hai lekin ismein ek error a raha hai jaise sheet taiyar karne ke bad is ko closed karne ke bad dubara open kar rahe hain to tamam formulas hide hojate hen, or dubara creat Karni parti hai file...
Sir Please help, I cannot save because it shows: To save a file with these features, click NO, and then choose a macro-enabled file type in the File Type List. How to save? Please help?? It also showing Cannot run the macro 'bc.xlsm!Sales'. The macro may not be available in this workbook or all macros may be disabled. What is the solution Sir?
Sir Mera ek sawal Quantity ka bad ek or chez add karne ho kase add ho ge ma na bht kia add ho jate par sale purchase ma show nhi ho rhau plz tell me ??
Meny asa hi sara form bniya, phir practice ki, is may aik issue aaiya hy, aagr aap wo resolve kr de to bht acha ho ga, issue ye hy k jb hm stock sheet may sumif wala formula laga k final krte hen to phir jb dubara koi form may entry krty hen to stock sheet update ni hoti, plz is ko resolve kr den, Mn aap k reply ka wait kron ga
Assalamoalaykum Awesome JazakAllah MashaAllah greatest
Good
سیکھنے کو بہت کچھ ملا
بہت اچھا طریقہ ہے سکھانے کا
sir tooo much help ful video teacher me center main samjhaya tha itna samjh nain aya ap ne pori video bna kar bht bht help ki
Hi sir kya aap hame help kar sakte hai
Ye formate ready hone ke bad jab file close karne par dobara open karne ke bad micro record kam nahi kar raha hai
Thank you very much sir🙏🙏🙏🙏🙏🙏🙏🙏🙏 from Nepal🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵
Hello, video is extremely informative. GOD BLESS YOU. Regards! Sartaj (Professional Accountant)
Thanks a lot
Asalamu alaikum...
Sir Thank you very much...
The way u explained is totally next level.... May Allah keep his mercy all times upon u...... ❤❤
Thanks and welcome
Excellent Islam Bhai...
भाई बहुत-बहुत शुक्रिया आपके इस टेबल के वजह से मैंने बहुत सारी टेबल बनाई आपका बहुत-बहुत शुक्रिया
Allah bless you my brother ❤❤❤❤❤❤
بہترین محنت
Really Helpful , Appreciated thanks
You're welcome!
Very nice. Thank You. Wish you all the best. Jahangir Hero, Dhaka
Sir how to save this method in MSExcel
I am saving this file but after sometime i opened this file but no data in this file please rply me
Very Helpful
sir ji... Amazing sale purchase managment sheet...........wow
Keep watching
@@shahabislam4912 stock to Bhai apny Galat likha hen
Good lesson
Good
Very nice sir, I don't know Hindi but I learned well because good way of your teaching....
Thanks and welcome
its very nice and useful as per my needs plz
kindly shear it..
thanks
Sir all your techniques is very good but think of a retail shop , where we purchase and sale n numbers of items in one invoice... kindly guide how to make it happen.
I like your way for teaching us sir thank you very much...
Thanks and welcome
Sir hamare pass 500 ke takriban saman hai to usako stock me pahle chadana hoga ya parchag karna hoga
Very easy explanation sir
Thanks and welcome
@@shahabislam4912 bhai save kaise kare File?
Good video
आदरणीय सर, आप का विडियो देख कर बहुत अच्छा लगा, मैं आप से यह जान्ना चाहता हुँ कि खरीदि शीट
( Purhase sheet) और (बिक्री) sales sheet में एक साथ बहुत सारी एक से आधिक entries कैसे कि जा सकती हैं।
thanks
Thank you so much sir ap ny bht easy way me samjaya hai, but i'm having a problem. Jab me second or third sales enter karta ho wo usko balace me se minus nahi karta. please guide on it.
Jazak Allah Sir, Aik request hay k is may jo b new entry hoti hay wo sab sy uper ati hay let suppose agar hum ya karna chahy k jo b new entry ho ho tarteeb k lihaz sy bad may ay wo kesay karin gain please.
Great 👍
Very useful Lesson...My Question is it possible that First Entry show at top in Purchase & Sale Sheet...
Ek chez agar is main payment amount or total amount k bhi coloum or ishi tarahan button bana sakta hain na
Great Style of Teaching, Please make VLOG of Short keys also
Thanks very Helpful ❤️❤️
You're welcome!
Good sir really appreciated ❤❤
Sir aik formate bana k guide kry hum ko daily bill notes na krna pry or daily amount b add krni h customer kii
For example
Bill num ,party name, amount ,recovery
Thanks very helpful.
You're welcome!
Plz make video for this same topic in Google sheets
Newton miss you man 2023 po nuam hle Mai Kei Chu Vai Nia nuam khop Bengal and mizo relation are very old and long lasting .
Sir bahut acha laga prog but sir ek prog his Mai insert add delete bhi kaise Karen is pr ek easy prog Excel Mai batayen sir
Sir.... Bar code reader sy scan kar kar data automatically excel may bar code number save ho sakta hy kya... Plz bta dy
hi.. nice.. i've try this file.. but at stock sheet, even i've already fixed the range, after the new data was input, the range change, shifted down. how to fixed the sum range?
Shadab bhai video acha hai aur simple b pr agr purchase, sale kia hai tou Debtors & creditors b hona chahiye tha. Saat mai Inventory kuch purana b ho sakta hai aur saat mai profit b hona chahiye.
Sir agar jo cheez purchase huwa ho bus usay he ap sale karsakay extra nhi toh uskay lia kia karay
In this video we can learn how easily make a macro enabled purchase, sales and stock register. Thank you very much shabab islam!
But how to save sir?
Please rply me sir
@@mianafridi6778 same question?
Tq so much sir
Welcome
Hi sir how are you?
Sir mene btana tha k me dhaga nalki ka kam karta hn or mene isi video se dekh karbik sheet bnai thi lekin meri jo item serial bohat ziyada hain
Ap se darkhwast hai k ap time laga k ik nalki manufacturing ki stock managment and sales hain us pe bhi video bnain plzzz
very inormative
Agr is main loss/profit afd krna ho to kya triqa hai kindly btao gy isi table main loss and profit bhi aye
Sir aisa possible hai. If i edit drop down list cell's spelling. So result cell's automatic update spelling..??
Thanks sir
salam bro purchase ik invoice ke batt agr dosari purchase ko entry kary to sum nhi ho raha hain diffrent date ka purchase add akes hoga
so nice
awesome work by show..
Helpful 🙂. 👍
Thanks
Thanks a lot, Sir,
Its very useful and easy to learn
Hai sir how r u?all your lessons are very useful ..it's helpful to get more knowledge and improve skills
So nice of you
achha sir, sabse pehle aapko thank you is video k liye. Lekin sir aur ek upay isme bata dijiye ki agar koi product 200kg purchase kiye hai. aur 1 baar mein 100kg phir dusre baar mein 50 kg aur tisre baar mein 15 kg aur baaki ka product jitna kgs bacha hai, utna ka sales kar denge toh sir, stock mein bhi toh badlav hona chahiye na par nahi ho raha hai. upay bataye
Ye sheet save kar sakte hen
Sir isme to product ki purchase aur sale hai aur invoice jo nikal ke date hai hum to uski sheet ko bhi isme link kar sakte hai
Amazing
Thanks
Shahab Islam kindly allow an english subtitle to all your video. It would be of great help in my study.
Can you guide me... there an error ..data enter krne k bd sale ya purchase buttons pe jb click kr ry hain tu 'object does not support this property or method a raha hai... how to resolve this??
Sir main nay same formula apply kiya tha magar bas sab upar jo product hai us ka sum theak ata hai magar baki Sara zero ata hai. Please suggest me what I can do
Sir kia ap ak cheez our add kr skte hain es formate mei pora purchaes our sale krne k bahd Jo stock Buch gea hai us ki closing value kitni hai
g poche
THANKS FOR NICE VIDEO, PLEASE DESCRIBE THE FORMULA FOR TRANSPOSE ENTRY
👍👍👍👍👍👍👍
Nice
Thanks
Osm
Thank you so much sir 😍😊
Most welcome
Sir stock wali sheet me Advance filter ka bhi to use kar sakte the jis se ki Iyem likhna nhi padta Automatic Aa jata 🤔
bahi mujay same iis tarah ka dat entry project chy but autmtic calculation bi kareen then data save karay for example
sale --- item detail---- qty----- discount------ sale tax 17% ------- net amount
plz reply soon
Very useful and easy to learn
Microsoft visual basic……
Means what sir?
Sir isme barcod scener system bhi bataiye....pls..
Ye desain mobile me use ho skta hai ya ni boss
sir excel me esa koi software banaen k jis me business ki parties add kr saken or jo jo stock ya saman den tu wo date by date add krty jaen or koi id h ya koi ot method banaen k wo id ya name ya number dalen tu us party ka khata open hojaey automatic total hota jaey
आप से मेरी गुजारिश है आप एक ऐसी वीडियो बनाएं जिसमें मोबाइल शॉप से जुड़ी हुई सभी चीजें जैसे की मोबाइल रिचार्ज मोबाइल रिपेयरिंग मोबाइल सेलिंग मोबाइल एक्स वेरी सेलिंग परचेज इन सब का इस्तेमाल कर सके
Agar hum 2 jaga sale kar rhe he ..jese ki 1-F1 bej rahe he ar 2- f2 me to dono ko - karke kitna stock baja wo check karna he to kese kare ..kansa formula lagega - ke bad
السلام علیکم ورحمةاللہ وبرکاتہ بھائی میری جوب ھے اکاؤنٹس کی تو اپکی یہ ویڈیو اچھی لگی ھے لیکن مجھے ایک ایٹم کی سٹوک رکھنی ھے اس کے لیئے کیا کرنا ھو گا
good video
how to add rate buy and sell
Kindly explain how to get a month wise sales, purchase and stok report, so that we can print and file it as a document
Thanks sir. Do you have a template with different warehouse locations
Plz give more sir
thank you
Welcome!
You didn't tell us about excel mode in which mode we should create or save it. Because on the time of saving the document there is a message comes about it.
Yes same problem with me
Brother save as macro enabled workbook
Thanks you very much sir, I have a problem with ma system when I saved on purchase sheet it shows Run-time error '438':
Object doesn't support this property method plz help me
Sir!! How to maintain stock for multiple locations
Ok in ur tutorial how to pick expored items
Sir colour or size ko kaise stock me layenge
What if made a FORM from Options...and do data entry...that would be the easy way...
Assalamu Alaikum, @Shahab_Bhai
sheet maine taiyar ki hai lekin ismein ek error a raha hai jaise sheet taiyar karne ke bad is ko closed karne ke bad dubara open kar rahe hain to tamam formulas hide hojate hen, or dubara creat Karni parti hai file...
Sir isme rate bhi add karna ho toh
Someone please help me.....
Stock is aading when making purchase but when doing sale stock is not decreasing can Someone explain why and how to fix it
Sir Please help, I cannot save because it shows: To save a file with these features, click NO, and then choose a macro-enabled file type in the File Type List.
How to save? Please help??
It also showing Cannot run the macro 'bc.xlsm!Sales'. The macro may not be available in this workbook or all macros may be disabled.
What is the solution Sir?
What if I want to print multiple item in one invoice
Us ke sath party wise pyment in ka bhi bata do sel hi karange to pyment bhi to lange
Sir main ny bna li hai lakin close kar k phir open karun tou dobara sy micro assign Karna parta hai
Save Macro Enable Format Me Ki He File Apne?
sir one question is required.
how this date is change automatically without typing date.
=today()
=now()
Sir Mera ek sawal Quantity ka bad ek or chez add karne ho kase add ho ge ma na bht kia add ho jate par sale purchase ma show nhi ho rhau plz tell me ??
As salamu alekum bhai mujko transport ka business hai us ko kyse up date kare excl me
NICE
Thanks
Meny asa hi sara form bniya, phir practice ki, is may aik issue aaiya hy, aagr aap wo resolve kr de to bht acha ho ga, issue ye hy k jb hm stock sheet may sumif wala formula laga k final krte hen to phir jb dubara koi form may entry krty hen to stock sheet update ni hoti, plz is ko resolve kr den,
Mn aap k reply ka wait kron ga
ap range entier select karen stock sheet ke Formule me