Sir is vedio say sheet to bna li boht acha smjhya thankx 1 msla hai k month ki sale dakhni hai k regmal month may kitnye sale howay our scraper Kitna total AA jaye lookup function Bhi sikha daye
Thanks sir . Ap behtren aur ache tariqe SE samjaya. Sir Kia ham is me items Barra sakte hai? Or Kia ham apni daily ke sale SE profit nekal sakte hai? Esi work main
Dear Trainer, I have learned many things from your video about Excel. When I enter TH-cam, first of all, I press my thumb button. However, your videos are very easygoing if someone who wants to learn excel properly in some cases. Thanks and regards Tauhid Bangladesh
You are great dada. I have learned a lot of thing in your channel regarding Excel function. A automatic calender will make this system more attractive, although it looks great!
Good morning Jitendra Bhai, I am writing you from Nepal. I watch your videos and like the most. Your rich contents, lucid presentation and the interface are praiseworthy. I have something to share with you. It is not necessary that we install this system for a newly established business concern. It may be for a old business house. I have a couple of queries... 1) How do you incorporate if we have already several amount of stocks of different types of items before we make any purchase? 2) If we want to show it by Month, do you have any suggestions? 3) On selling goods, there will be customer's name and on purchasing goods there will be supplier's name and their bill/invoice number. 4) For purchase item there will be supplier side bill number. Can we give purchase bill number from our side like 1, 2, 3, 4, ....?
if we have more then tow sheets how can we apply MAX formula for example ( purchase, issuance, product, Sale and Stock. kindly make a detail video on this thank you
Thank you very very much bro. You are a Master. I learned a lot even I'm not knowing a Hindi word. Thanks for your help. I'll try to apply on my stock. İ would like to contact you bro. I'll see if I can reach you. Love Indian people, from Iraq. Regards...
Sir, i want to make customize software about purchase and consumption of raw material , where multiple raw material consumption happening in a single day, how can i make it. Please assist
Thank you very much sir, it's best useful , but in one bill no more than 2 product ,how can entry sale or purchase sir , please sir give me suggestions
WILL YOU PLEASE SHARE THE EXCELL SHEET WHICH YOU PREPARED. as Stock Management in Excel (Hindi) | Inventory Management System in Excel | Stock Register.I WANT ADD IN STOCK MATERIAL...RPY PLZ
hello,can you pls help me?? I was making a sheet following your video. When i started recording macro, i selected all cells as you told,tried to copy all but it says this command is not applicable for too many cells at a time.
Jitendrajee I am facing a problem when I made a entry in the respective purchase/sales, after returning to the database the previous entry is not deleted. please solve my problem. Thanks.
Hello sir could you help me with these points 1. System ki date lele apne aap 2. Jb entry type Sale choose kro toh Item m purchase ki drop down list aa jaye aur jb purchase choose kro toh blank bhi aa jaye aur list bhi 3. Entry level pr jo choose kro usi ki button niche activate ho Sale choose kr rha agr purchase ki dawa do toh purchase pr pahuch Jaa rha 4. Koi bhi entry delete kro beech ki sale ya purachse list se toh gap aa jaa rha column kaa
Sir aapki bani hui is stock sheet ki practice maine ki hai sir one query hai mere maine is sheet mai 5 new colour add keye hai, 1.GATE ENTRY NO 2. ITEM CODE NO 3.ITEM NAME 4 GST sir inme se ,item code no,item name inmai se kuch bhe pahle entry karu 2 automatically aa jana caye or gate entry no automatic genrate ho please fourmula batao sir
excel me inventory tracking data entry invoice creation attendence sheet creation chart creation stock maintain mailing list can u say .. in word business letter/ document proposal contract creation plan report
Sir, I want to make a stock inventory. Like a car spare parts you you know car spare parts has a big range. So how can I make an excel sheet and how can I search products in the search bar.
When you make a purchase, YOU dont decide the bill numbers, but the vendor's computer decides the bill numbers. different suppliers/vendors supply you the goods when you purchase them, so how can the person buying the goods ascertain the bill numbers automatically of the supplier??
Sir kg ko gram convert kaise kare or dashboard dra kaise use kr jaise I gravey banata hu or usm mujhe each of item 30 gram ,50 gram ,or 100 gram k hisab se chshye
Sir ji, i have seen many you tubers, who made stock inventory software, but no one answer my question that if you got more then 1 items, then how we can make entry for a single way. In your software we have to enter invoice no and date randomly. If we got 10 items in purchase then we have to enter invoice no. 10 times for same invoice. Please help
Sir ji At a time One item Entry in Purchase & Sale too. means one by one. how to Purchase entry entered many items (5-10 items, 10-15 items) at a time. as like workbook. Example - Vendors Bill is 15 items. We want to purchase entry it. we can entry it one by one ( Bill No- 15 times, Items 15 times). Please Solution this problem. Thanks.
Sir, we are interested in accounting maintain of Badkulla Vegetables Cartel(commission agent) Product on Excel file fully automatically daily transaction update . Please guide or serv the completely file material as a consultant
Very nice sir and thank for excellent explain .how to create a stock management system for the 300 students to distribute different items like pen pencil rubber notebook etc .
Thank dear from this video I learned some thing new.
Sir is vedio say sheet to bna li boht acha smjhya thankx
1 msla hai k month ki sale dakhni hai k regmal month may kitnye sale howay our scraper Kitna total AA jaye lookup function Bhi sikha daye
super techniques of teaching... loving from AFGHANISTAN....
Thanks a lot
Thanks man it really help a lot in growing my business
I am very happy to hear it. Thanks 🙏
Thanks sir . Ap behtren aur ache tariqe SE samjaya. Sir Kia ham is me items Barra sakte hai? Or Kia ham apni daily ke sale SE profit nekal sakte hai? Esi work main
Great work Bro
Dear Trainer, I have learned many things from your video about Excel. When I enter TH-cam, first of all, I press my thumb button. However, your videos are very easygoing if someone who wants to learn excel properly in some cases.
Thanks and regards
Tauhid
Bangladesh
Thank you so much dear
Your words have really encouraged me.
Thanks 🙏
Jitendra
You are great dada. I have learned a lot of thing in your channel regarding Excel function. A automatic calender will make this system more attractive, although it looks great!
Thanks Hussain ji
Bhai Gajjab Amazing
Thanks Akram bhai
Very useful sir
you got a new subscriber..thank you sir :)
Thanks 🌹
You are genius
So kind of you
nice sir i like so much before i dont no now its good thanku so much
Thanks Rehman Bhai
can nut run the macro 'inventory purchase' the micro may not be available in this workbook or all macro may be disable ???
Good ❤
Thanks
Thanks bhai
Superb sir ji 👌👌👌
Thanks ji
Sir if what i have to add different supplier name for same item and specifications for different product
Thanks From Bangladesh
Welcome from India
Good morning Jitendra Bhai,
I am writing you from Nepal. I watch your videos and like the most. Your rich contents, lucid presentation and the interface are praiseworthy.
I have something to share with you.
It is not necessary that we install this system for a newly established business concern. It may be for a old business house. I have a couple of queries...
1) How do you incorporate if we have already several amount of stocks of different types of items before we make any purchase?
2) If we want to show it by Month, do you have any suggestions?
3) On selling goods, there will be customer's name and on purchasing goods there will be supplier's name and their bill/invoice number.
4) For purchase item there will be supplier side bill number. Can we give purchase bill number from our side like 1, 2, 3, 4, ....?
if we have more then tow sheets how can we apply MAX formula for example ( purchase, issuance, product, Sale and Stock.
kindly make a detail video on this thank you
Can you help if we have more sheets then 2 sale purchase
What formula do we have to use???
thanks bro
Super
Thank you very very much bro. You are a Master. I learned a lot even I'm not knowing a Hindi word. Thanks for your help. I'll try to apply on my stock. İ would like to contact you bro. I'll see if I can reach you.
Love Indian people, from Iraq.
Regards...
Is there a way to take the final stock value in fifo method by this model?
شكرا جزيلا
Thanks
Sir please bataiye ki entry type mei mei 3 prakar ka jaise purchase, sales, return karne ke liye kya karna hoga.... Please sir
Sir ji, bacicaly mera 4-5 Wearhouse pa inventory management karanga ak sheet Ky upar. Agar ak idea da saktaha. Coal stone business ka stock karanga.
Sir if I want new item add.. So how can i use... Steps for new item add plzzz...
Respected Sir,
There are two items in the same bill in this format, so how to add them in this fotmat.
Sir, i want to make customize software about purchase and consumption of raw material , where multiple raw material consumption happening in a single day, how can i make it. Please assist
Thank you very much sir, it's best useful , but in one bill no more than 2 product ,how can entry sale or purchase sir , please sir give me suggestions
WILL YOU PLEASE SHARE THE EXCELL SHEET WHICH YOU PREPARED. as Stock Management in Excel (Hindi) | Inventory Management System in Excel | Stock Register.I WANT ADD IN STOCK MATERIAL...RPY PLZ
WILL YOU PLEASE SHARE THE EXCELL SHEET WHICH YOU PREPARED. FOR HOTELING STOCK
sir,i only can see new active entry updated other vanishes ,thats why same result shown in stock sheet only new entry i can see,can u help me?
Best video
Thanks
Sir agr hme new item badane pade to kya ye kam karega ya kuch changing krni padegi
Kam karega
With great respectfully make excel software video for cars show room slae purchase credit etc.
hello,can you pls help me?? I was making a sheet following your video. When i started recording macro, i selected all cells as you told,tried to copy all but it says this command is not applicable for too many cells at a time.
Sir I have dought Sir if we don't have to put the rate of sales it can't happen
Sir,
If the bill no of purchased item is not in sr. no. or from random no. then how it will work for last bill no.
Jo stock wali sheet hai use rate bhi aana chahiye ki kya rate me sale Kiya hai to kaise kare
I think it's Will very useful
Let's watch it ??
Thkn u
Yes please continue your support as usual
So far it's cool,but I want it from opening stock,how will I do that?
Pls make videos for multiple branches supply by single store
Hi if sale or purchase bill have more than one item then what???
Hello bro, your video is quite useful but my chart is not showing data and stock sheet also not showing entries of sale and purchase
Sir incase I enter a wrong entry......then how to edit or delete?
Sir Zi Namaskar! Mere liya Automatic Stock management sales invoice ka satha ek viideo banaiya please🙏🙏🙏🙏🇳🇵
Without Macro kuch formula ho to bataye , using ipad pro ..macro not available in available excel..
Sir kya Excel me automatic profit nikal sakte hai
WILL YOU PLEASE SHARE THE EXCELL SHEET WHICH YOU PREPARED.
Hi respected sir
ap k pas data management wali ready sheet Jo hai Kia ap wo muje send kr sakte ho?
Absolutely amazing
Thanks🙏
Hi there can i get exact same copy of excel sheet(book) as your given Download link is not same
Sir g im from pakustan bro can you help me.bro sell kisko kiya uska name or price bi add krain
nice. ek hi bill me multiple item honge to kaise karenge entry? plz help
Dinesh ji please design the format as per requirements
@@PowerExbyJitendra thank u sir
Hi... I am from Bangladesh. I need this excel file. What is the procedure to get this .
Ek bill ke under multiple item ho to kaise entry karege
Jitendrajee I am facing a problem when I made a entry in the respective purchase/sales, after returning to the database the previous entry is not deleted. please solve my problem. Thanks.
👌 video
Hello sir could you help me with these points
1. System ki date lele apne aap
2. Jb entry type Sale choose kro toh Item m purchase ki drop down list aa jaye aur jb purchase choose kro toh blank bhi aa jaye aur list bhi
3. Entry level pr jo choose kro usi ki button niche activate ho
Sale choose kr rha agr purchase ki dawa do toh purchase pr pahuch Jaa rha
4. Koi bhi entry delete kro beech ki sale ya purachse list se toh gap aa jaa rha column kaa
Very good
Thanks ji
Sir Kya ek bill me kewal ek hi item Purchase karega???? ya
Nice😊😊
Thanks
Sir aapki bani hui is stock sheet ki practice maine ki hai sir one query hai mere maine is sheet mai 5 new colour add keye hai,
1.GATE ENTRY NO
2. ITEM CODE NO
3.ITEM NAME
4 GST
sir inme se ,item code no,item name inmai se kuch bhe pahle entry karu 2 automatically aa jana caye or gate entry no automatic genrate ho please fourmula batao sir
How is the macro getting disabled when saved in an excel file? can you explain
Sir Share trading record ke liye aapki koi video hai kya ? Thanks ..
Ok ji
Good looking interface,,from Pakistan
Thanks Amir bhai.
Very hard work has been done to make it.
Please share, how to make the drop down list searchable in this sheet.
sir, need this file, given ink have not complete file. Thanks
excel me
inventory tracking
data entry
invoice creation
attendence sheet creation
chart creation
stock maintain
mailing list can u say ..
in word
business letter/ document
proposal
contract creation
plan report
Sir, I want to make a stock inventory. Like a car spare parts you you know car spare parts has a big range. So how can I make an excel sheet and how can I search products in the search bar.
Stock m kitni quantity h uska bhi price ho to achha rahega.
How to maintain stock of mobile in small shop with sr no item model sizes
I will definitely make a video on it
ماشاء اللہ bro apne bht achi sheet bani h but bro last colum pr kese jaye ga cnt + down krra hn last kr nh ja rha h
Zaroor jayega check karo neeche kahi kuch data hoga
Its very helpful for me sir, but it
Would be great if you can add hsn code & discounts too
when ever i click purchase it shows run time error 438
object does not support this property or method
y is that sir
Super Sir please how to remove olld data
Sir agar koi wrong entry ho jaye toh delete kaise kr skte h
When you make a purchase, YOU dont decide the bill numbers, but the vendor's computer decides the bill numbers. different suppliers/vendors supply you the goods when you purchase them, so how can the person buying the goods ascertain the bill numbers automatically of the supplier??
Sir sale return or purchase return kesy dalen gy ???
Superb Sir, please how to see a particular item purchased or sales with dates (means how many times purchased or sales)
What for multiple items in same bill
Please design your form accordingly
Please explain how we can show rate and amount colum in stock sheet also
Please design format as per your requirements
@@PowerExbyJitendra can you give me your mail id .
@@jyothishkumar.p.g6082 it is given in about section
Sir kg ko gram convert kaise kare or dashboard dra kaise use kr jaise I gravey banata hu or usm mujhe each of item 30 gram ,50 gram ,or 100 gram k hisab se chshye
You can use number formattion for it.
Bro Can u plz add invoice printing option?
The same question is mine
Hello Sir G,Marriage Hall Booking Schedule ka video upload kigiye Naa.......plzzzzz.
Ok Tahir ji I try
Hello Sir, Can we add customer name in this sheet also the Customer ledger and Invoice
Sir ji, i have seen many you tubers, who made stock inventory software, but no one answer my question that if you got more then 1 items, then how we can make entry for a single way. In your software we have to enter invoice no and date randomly.
If we got 10 items in purchase then we have to enter invoice no. 10 times for same invoice. Please help
I am waiting for your kind reply
Best regards!
Sir ji At a time One item Entry in Purchase & Sale too. means one by one. how to Purchase entry entered many items (5-10 items, 10-15 items) at a time. as like workbook. Example - Vendors Bill is 15 items. We want to purchase entry it. we can entry it one by one ( Bill No- 15 times, Items 15 times). Please Solution this problem. Thanks.
When the system does not save macro.... What to do?
Sir, we are interested in accounting maintain of Badkulla Vegetables Cartel(commission agent) Product on Excel file fully automatically daily transaction update .
Please guide or serv the completely file material as a consultant
Sir pls help me how to migrate...
SIR I NEED YOUR HELP I WANT TO DOWNLOAD THE SHEET THAT YOU MADE. BUT I CANNT DOWNLOAD THE SHEET
when i save file as macro enabled, but it shows macro desabled. what to do?
You have mentioned new problem here
Very nice sir and thank for excellent explain .how to create a stock management system for the 300 students to distribute different items like pen pencil rubber notebook etc .
Sir I have an error 438(object doesn't support this property or method I have window/ office 2007
My excel sheet with no working data ,pls help me