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

Thanks a lot, Sir, Its very useful and easy to learn

Thank you very much sir🙏🙏🙏🙏🙏🙏🙏🙏🙏 from Nepal🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵

Good سیکھنے کو بہت کچھ ملا بہت اچھا طریقہ ہے سکھانے کا

Allah bless you my brother ❤❤❤❤❤❤

Assalamoalaykum Awesome JazakAllah MashaAllah greatest

Excellent Islam Bhai...

भाई बहुत-बहुत शुक्रिया आपके इस टेबल के वजह से मैंने बहुत सारी टेबल बनाई आपका बहुत-बहुत शुक्रिया

Very useful and easy to learn

Really Helpful , Appreciated thanks

@shahabislam4912

Жыл бұрын

You're welcome!

its very nice and useful as per my needs plz kindly shear it.. thanks

I like your way for teaching us sir thank you very much...

@shahabislam4912

Жыл бұрын

Thanks and welcome

sir ji... Amazing sale purchase managment sheet...........wow

@shahabislam4912

3 жыл бұрын

Keep watching

@aamirsheikh5879

2 жыл бұрын

@@shahabislam4912 stock to Bhai apny Galat likha hen

awesome work by show..

Great Style of Teaching, Please make VLOG of Short keys also

Very nice sir, I don't know Hindi but I learned well because good way of your teaching....

@shahabislam4912

Жыл бұрын

Thanks and welcome

Very nice. Thank You. Wish you all the best. Jahangir Hero, Dhaka

@mianafridi6778

2 жыл бұрын

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

In this video we can learn how easily make a macro enabled purchase, sales and stock register. Thank you very much shabab islam!

@mianafridi6778

2 жыл бұрын

But how to save sir? Please rply me sir

@irshadmahsood6611

Жыл бұрын

@@mianafridi6778 same question?

بہترین محنت

Hello, video is extremely informative. GOD BLESS YOU. Regards! Sartaj (Professional Accountant)

@shahabislam4912

6 ай бұрын

Thanks a lot

Helpful 🙂. 👍

Good sir really appreciated ❤❤

@ziafatkalyar6745

Жыл бұрын

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

Shahab Islam kindly allow an english subtitle to all your video. It would be of great help in my study.

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.

Thank you so much sir 😍😊

@shahabislam4912

2 жыл бұрын

Most welcome

very inormative

Good

Hai sir how r u?all your lessons are very useful ..it's helpful to get more knowledge and improve skills

@shahabislam4912

3 жыл бұрын

So nice of you

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.

Thanks Sir

Thanks very helpful.

@shahabislam4912

2 жыл бұрын

You're welcome!

@alriyadhtechnical1096

2 жыл бұрын

Plz make video for this same topic in Google sheets

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?

Nice Work. Congratulations Shahab. Keep it up. I have understood the concept since you used a very simple language. can I ask questions on Excel sheets if doubts are there. Regards, Rajinder

@shahabislam4912

2 жыл бұрын

Yes, sure

Great 👍

Very useful Lesson...My Question is it possible that First Entry show at top in Purchase & Sale Sheet...

Good lesson

Wonderful..

@shahabislam4912

Жыл бұрын

Many thanks!

आदरणीय सर, आप का विडियो देख कर बहुत अच्छा लगा, मैं आप से यह जान्ना चाहता हुँ कि खरीदि शीट ( Purhase sheet) और (बिक्री) sales sheet में एक साथ बहुत सारी एक से आधिक entries कैसे कि जा सकती हैं।

Tq so much sir

@shahabislam4912

2 жыл бұрын

Welcome

Thanks sir. Do you have a template with different warehouse locations

good video how to add rate buy and sell

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

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

thanks

Osm

Sir pls explain that my selling price should always be Rs.1.75 more than my purchase for each product. Frequently my purchase rates will change for each product. How to analyse stock and arrives new average selling price

Very easy explanation sir

@shahabislam4912

2 жыл бұрын

Thanks and welcome

@aritromukherjee7185

2 жыл бұрын

@@shahabislam4912 bhai save kaise kare File?

आप से मेरी गुजारिश है आप एक ऐसी वीडियो बनाएं जिसमें मोबाइल शॉप से जुड़ी हुई सभी चीजें जैसे की मोबाइल रिचार्ज मोबाइल रिपेयरिंग मोबाइल सेलिंग मोबाइल एक्स वेरी सेलिंग परचेज इन सब का इस्तेमाल कर सके

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.

@mianafridi6778

2 жыл бұрын

Yes same problem with me

@sariamuhammad3985

Жыл бұрын

Brother save as macro enabled workbook

Thanks

As salam o Alaikum, Hope u will be fine and well, in-sha-ALLAH. Sir, this is very useful vedio on the topic, especially for me, which i am thankful to you. More I want to know that how can we manage invoices and party ledger ( suppliers and customers ) along with this sale, purchase & stock formate. Kindly guide us. Looking forward to view good from You, soon Thnx & awaiting.

Good video

thank you

@shahabislam4912

2 жыл бұрын

Welcome!

Ok in ur tutorial how to pick expored items

Very nice lesson, i have question that how can we prepare a report form to print or view full or in between start end dates.

@shahabislam4912

3 жыл бұрын

kzread.info/dron/cOsbNCxgUZMPoHEI1w-1RA.htmlsearch?query=data%20extract%20start%20date%20and%20date

@relaxation2041

3 жыл бұрын

@@shahabislam4912 sir very nice video I always get help from your videos , only I have one problem when i put data is updating only when I save and come back to file then not accepting any data entry

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.

so nice

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.

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

Amazing

@shahabislam4912

2 ай бұрын

Thanks

Assalamu alaikum sir in stock sheet quantity tab formula working only in first shell

Sir hamare pass 500 ke takriban saman hai to usako stock me pahle chadana hoga ya parchag karna hoga

THANKS FOR NICE VIDEO, PLEASE DESCRIBE THE FORMULA FOR TRANSPOSE ENTRY

👍👍👍👍👍👍👍

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

Kindly explain how to get a month wise sales, purchase and stok report, so that we can print and file it as a document

Sir.... Bar code reader sy scan kar kar data automatically excel may bar code number save ho sakta hy kya... Plz bta dy

Nice

@shahabislam4912

3 жыл бұрын

Thanks

Sir it is great but when we add data how it will automatically sort as per serial & serial will also generate automatically. Kindly suggest Thanks

@shahabislam4912

3 жыл бұрын

Yes it will

Sir stock wali sheet me Advance filter ka bhi to use kar sakte the jis se ki Iyem likhna nhi padta Automatic Aa jata 🤔

In the sheet it is observed that transactions happened on subsequent dates are recorded in respective "Sales" or Purchase" sheet " in upward rows, instead subsequent date transactions are to be recorded in subsequent dates, please solve for us

If we add multiple products at same time in the sales or purchase then what?

Plz give more sir

Sir agar jo cheez purchase huwa ho bus usay he ap sale karsakay extra nhi toh uskay lia kia karay

Ek chez agar is main payment amount or total amount k bhi coloum or ishi tarahan button bana sakta hain na

A file for the stock market created by Excelli

Sir Google sheet ke liye bhi aisa kuch banaye

Agr is main loss/profit afd krna ho to kya triqa hai kindly btao gy isi table main loss and profit bhi aye

Ye desain mobile me use ho skta hai ya ni boss

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

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

When I click purchase so it's not working.... Here is showing run time error... Object does not support this property or method

Nice video

@shahabislam4912

2 жыл бұрын

Thanks

Sir!! How to maintain stock for multiple locations

Inki voice Salman Khan jesi hai🧐

NICE

@shahabislam4912

2 жыл бұрын

Thanks

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

I've not seen one thing to control errors like... 1) If you enter sales quantity greater than stock, then the programming must protect to enter greater than stock. Your guideline is good but not a perfect one.

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

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??

Not calculating new entry in Stock.. Plz chk formula

Sir, how to get invoice no for sale automatically

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

Nice sir, likin aik masla he jab file ko save akro aur dobara open karta ho tu data purchase sheet me nahi jata he

السلام علیکم ورحمةاللہ وبرکاتہ بھائی میری جوب ھے اکاؤنٹس کی تو اپکی یہ ویڈیو اچھی لگی ھے لیکن مجھے ایک ایٹم کی سٹوک رکھنی ھے اس کے لیئے کیا کرنا ھو گا

What if made a FORM from Options...and do data entry...that would be the easy way...

Sir aisa possible hai. If i edit drop down list cell's spelling. So result cell's automatic update spelling..??

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

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

@shahabislam4912

2 жыл бұрын

ap range entier select karen stock sheet ke Formule me