Dear Trainer, I have learned many things from your video about Excel. When I enter UA-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
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
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 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
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, ....?
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...
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
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
Excellent way of delivering lecture i made same one as u explain in u r presentation i did same as u told my 1st entry of Purchase and sale of same product is ok i made 2nd entry of purchase which saved in purchased sheet when i sold item of second entry then its not included in sale sheet and i received msg mentio below Selection.ClearContents Range("J8").Select End Sub Sub Sales() ' ' Sales Macro ' ' Range("J7:J12").Select Selection.Copy Selection.ShapeRange.Item(1).Hyperlink.Follow NewWindow:=False, AddHistory _ :=True Range("I1").Select Selection.End(xlDown).Select Selection.End(xlToLeft).Select Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True Sheets("Sale").Select ActiveCell.Offset(0, 7).Range("A1").Select Range("D2").Select Application.CutCopyMode = False Selection.NumberFormat = "General" Range("E2").Select Selection.NumberFormat = "General" Range("F2").Select Selection.NumberFormat = "General" Range("G2").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Selection.ShapeRange.Item(1).Hyperlink.Follow NewWindow:=False, AddHistory _ :=True Range("G2").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Range("J8:J11").Select Selection.ClearContents Range("J8").Select End Sub kindly tell me where i did mistake
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
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 .
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 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
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
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??
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.
I am your subscriber of your channel, plz can you show next video Login id plz any company name Username (with name) Passwords (******) Waiting for yiur video
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, 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.
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
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
Dear sir, How do I find out items in items name if I have more than 1000 items. Can I make the item as I see it when I enter the first few letters?. Please let me know your answer. Very thank you for your video. Time line - 22:13- 23:00
super techniques of teaching... loving from AFGHANISTAN....
Thanks a lot
Dear Trainer, I have learned many things from your video about Excel. When I enter UA-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
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
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
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
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, ....?
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...
you got a new subscriber..thank you sir :)
Thanks 🌹
Great work Bro
Superb sir ji 👌👌👌
Thanks ji
Its very helpful for me sir, but it
Would be great if you can add hsn code & discounts too
nice sir i like so much before i dont no now its good thanku so much
Thanks Rehman Bhai
You are genius
So kind of you
Pls make videos for multiple branches supply by single store
Good ❤
Thanks
Thanks From Bangladesh
Welcome from India
Very useful sir
Sir Share trading record ke liye aapki koi video hai kya ? Thanks ..
Ok ji
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
Bhai Gajjab Amazing
Thanks Akram bhai
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 please bataiye ki entry type mei mei 3 prakar ka jaise purchase, sales, return karne ke liye kya karna hoga.... Please sir
Excellent way of delivering lecture i made same one as u explain in u r presentation i did same as u told my 1st entry of Purchase and sale of same product is ok i made 2nd entry of purchase which saved in purchased sheet when i sold item of second entry then its not included in sale sheet and i received msg mentio below
Selection.ClearContents
Range("J8").Select
End Sub
Sub Sales()
'
' Sales Macro
'
'
Range("J7:J12").Select
Selection.Copy
Selection.ShapeRange.Item(1).Hyperlink.Follow NewWindow:=False, AddHistory _
:=True
Range("I1").Select
Selection.End(xlDown).Select
Selection.End(xlToLeft).Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets("Sale").Select
ActiveCell.Offset(0, 7).Range("A1").Select
Range("D2").Select
Application.CutCopyMode = False
Selection.NumberFormat = "General"
Range("E2").Select
Selection.NumberFormat = "General"
Range("F2").Select
Selection.NumberFormat = "General"
Range("G2").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Selection.ShapeRange.Item(1).Hyperlink.Follow NewWindow:=False, AddHistory _
:=True
Range("G2").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Range("J8:J11").Select
Selection.ClearContents
Range("J8").Select
End Sub
kindly tell me where i did mistake
ماشاء اللہ 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
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 nut run the macro 'inventory purchase' the micro may not be available in this workbook or all macro may be disable ???
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
So far it's cool,but I want it from opening stock,how will I do that?
With great respectfully make excel software video for cars show room slae purchase credit etc.
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 .
I think it's Will very useful
Let's watch it ??
Thkn u
Yes please continue your support as usual
Superb Sir, please how to see a particular item purchased or sales with dates (means how many times purchased or sales)
Sir Zi Namaskar! Mere liya Automatic Stock management sales invoice ka satha ek viideo banaiya please🙏🙏🙏🙏🇳🇵
Absolutely amazing
Thanks🙏
Hello Sir G,Marriage Hall Booking Schedule ka video upload kigiye Naa.......plzzzzz.
Ok Tahir ji I try
Can you help if we have more sheets then 2 sale purchase
What formula do we have to use???
Sir agr hme new item badane pade to kya ye kam karega ya kuch changing krni padegi
Kam karega
Thanks bhai
Sir kya Excel me automatic profit nikal sakte hai
Best video
Thanks
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.
Stock m kitni quantity h uska bhi price ho to achha rahega.
Good morning. All is very good. But There No Closing Stocks . For Next Month.
Sir if what i have to add different supplier name for same item and specifications for different product
Sir Kya ek bill me kewal ek hi item Purchase karega???? ya
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 g im from pakustan bro can you help me.bro sell kisko kiya uska name or price bi add krain
Super
Super Sir please how to remove olld data
Is there a way to take the final stock value in fifo method by this model?
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.
Without Macro kuch formula ho to bataye , using ipad pro ..macro not available in available excel..
thanks bro
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 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
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
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.
WILL YOU PLEASE SHARE THE EXCELL SHEET WHICH YOU PREPARED.
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.
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,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?
Sir agar koi wrong entry ho jaye toh delete kaise kr skte h
Nice😊😊
Thanks
Jo stock wali sheet hai use rate bhi aana chahiye ki kya rate me sale Kiya hai to kaise kare
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.
I am your subscriber of your channel, plz can you show next video
Login id plz any company name
Username (with name)
Passwords (******)
Waiting for yiur video
Sir please add invoice to print and save pdf with this beautiful stock management.
Sir make vedio like this entry of stock ( share market ) same all data details how to mange
Ok ji
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.
Hello Sir, Can we add customer name in this sheet also the Customer ledger and Invoice
Hi there can i get exact same copy of excel sheet(book) as your given Download link is not same
Sir incase I enter a wrong entry......then how to edit or delete?
Sir I have dought Sir if we don't have to put the rate of sales it can't happen
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.
Sir sale return or purchase return kesy dalen gy ???
Very good
Thanks ji
What for multiple items in same bill
Please design your form accordingly
Bro Can u plz add invoice printing option?
The same question is mine
👌 video
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 have a doubt what logic should we apply to include part number in the table contents can you please help ?
Ek bill ke under multiple item ho to kaise entry karege
Good looking interface,,from Pakistan
Thanks Amir bhai.
Very hard work has been done to make it.
Hi... I am from Bangladesh. I need this excel file. What is the procedure to get this .
Ammount kab formula kya sir apne???🙄🙄
Rate multiply Quantity
Hi if sale or purchase bill have more than one item then what???
I am waiting for your kind reply
Best regards!
Please make same video based on Google sheet
Ok Siddharth
@@PowerExbyJitendra sir we are still waiting ! Thanks .
Ki laptop band karne ke baad dubara on karne per is data mai entry ho jaayegi naa
Save file as Excel Macro Enabled Workbook
Hi respected sir
ap k pas data management wali ready sheet Jo hai Kia ap wo muje send kr sakte ho?
Very useful!
Can u add bill slip with it's?
If you add bill it's very pleasure for me thank you
I think to add it
Please share, how to make the drop down list searchable in this sheet.
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
Dear sir, How do I find out items in items name if I have more than 1000 items. Can I make the item as I see it when I enter the first few letters?. Please let me know your answer. Very thank you for your video.
Time line - 22:13- 23:00
It is possible with the help of searchable drop down list.
@@PowerExbyJitendra Thank you sir, Please upload more videos like this.🎆 I give 5+ stars 🌟 to your service,💐
Thanks for your kind support
Sir one more question that if we want to enter any value in our cell so can we get the details of various item.
Is this possible?
Sir, please also give a program for making hsn summary detail as in gstr1 return to enter in gstr1 return. Thanking you
Make a video item wise in different godown in different locations for a real estate company
Manoranjan ji you can explore it as per your requirements.