thanks for reply sir.... sir 1 question tha.... may ne micro banaliya lakin har time micro run karna ke liya devloper se import karna padta hay.... ? solution dijiye... thanks
Sir bhot Kuch sikhne ko milta h aapse thank you so much sir😘😘😘😘😘😘😘😘 .........sir Mai gst invoice bill bna toh liya but sir eska Pura set-up print me nhi aata😥😥😥bhot paresan hu sir
Hi good Morning / Namaskaar, i am one of your subscriber , just from last month or 2 months. I really appreciated all your work, and specially the way you are teaching, and a special quality sound and very effective Voice Volume, i always watching your everyone single video, and really feeling thirsty in day without your videos.
Sir You are great and there is no match in this video. Here we want to know how is converted Grand total to in word's.Kindly tell us if possible. Thanks
Bhai maza a gaya zabardast ab try karunga Ek chez maloom karni thi purchase or sale ka 2no ek jaisa rahega bill bs uper name change karna hoga Plz waiting for answer
Deepakji Very good and very simple sir how to create picture lookup in estimate format like we select item description from the drop list then automatic reflect picture and all details only we can put qty
Deepak ji agar bill mai discount ya display party ko daina ho to gst kese calculate hoga with formula, or jo party ko products bill kiya hai unpai gst alg alg ho like (1 product 18% gst and other product 12% gst)
Thank you sir for sharing your knowledge i have learned many things. i just want to know one more things that how to show calculation of HSN wise CGST SGST total in this invoice because as per GST rule we have to show classification of HSN and total CGST SGST on a particular HSN number. Please make a video in this. Thank You
Deepak sir How are you? please ik chota sa software complete bana sikhayen, jis main invoice, quotation, LPO, complete inventory, sale purchase, profit, loss day book, month book and annual report fully auto generate hon or print b ho skyen plz
Deepak Jee, excellent work, but i am facing a challenge while copying vlookup formula in the below cells. it changes the table array value. Please guide...
Dear Deepak ji thank you for your excellent support. My request is that please prepare a pos billing software with GST in excel which will keep inventory after each sale bill. Once more thank you so so much for your kind support n excellent explanation. Good day...
VERY GOOD EXPLANATION ABOUT HOW TO MAKE THIS EXCEL SHEET. BUT YOU SHOULD HAVE MADE AUTO FILLING OF SGST COLUMN WHEN ONE FILL CGST COLUMN OR VICEVERSA . IS THIS DOWNLOADED FILE EDITABLE? HOW TO REMOVE DROPDOWN MANUES AS WE HAVE ONLY CUSTOM MADE ITEMS? PLEASE REPLY.. HOW TO SAVE & PRINTTHIS INVOICE AND RETRIVE FOR EDITING PURPOSE?
helpful in gst work Deepak Eduworld sir i saw each n every videos on your channel . As a fresher i learn advanced excel that you shows in your videos but I didnot get job . Will you plz help me to get job in mumbai ?
Just practic excel.. By following my videos.. Each and every video is very helpful.. I hope if you are following my every videos.. You can easily crack interviews
thank you for video sir , mera ek question tha if i want to set range of product items means agar mere 10 se jada product hi toh mai ek dynamic range option kaise bna sakta hu please ans
Dear Deepak ji thank you for your excellent support. i have Used the below formula for PDF invoice creation Private Sub CommandButton3_Click() Sheet1.Range("B2:J48").ExportAsFixedFormat xlTypePDF, Filename:="C:\Users\admin\Desktop\RAMINV\" & Sheet1.Range("J12").Value, openafterpublish:=True End Sub for below error comes " Run Time error 5 Invalid Procedure Call or argument"
Hello DIPAKJI, mera pharmaceutical ka business. Usme ek problem ho raha hain, ek hi product bar bar nehi le raha hain, aur dusri bad yeh hain ki main ek row chorke jab dusre row mein jabe raha hoon woh v nehi ho raha hain. Main use kar raha hoon EXCEL 2007
dear.... this is working automatically with vlookup formula..... please watch vlookup video... link is in description.... thanks... i hope you can do it after knowing about vlookup...
Visit our INVOICE PLAYLIST
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
may aap se bahot kuch sikha hoo.... aur sikhta rahooga.... gr8 work.... god bless you
Bhai really you r genius, kamaal ka sikhate ho bhai. Or har ek cheej ka knowledge he aapko.
Thank you so so so much bhai.
😊😊😊😊😊😊😊
Thank you sir good explanation
बेहतरीन 👌👌👌👌👌लाजबाब ।।
thanks sir app bahut acha sikhate ho
Really u r baap of excel 💪💪💪💪👍👍👍👌👌👌
😇😇😇😇😄😄🤗🤗
Bahut hi majedar h...
🤗
thanks for reply sir.... sir 1 question tha.... may ne micro banaliya lakin har time micro run karna ke liya devloper se import karna padta hay.... ? solution dijiye... thanks
Very good and your video make easy to learn thank you
THANK YOU
BROTHER
Thank you gst invoice sahi hai
sahi kam kar raha haj.
Great sir🙏🏻
very good information given in detail
Very useful vedio sir thanks please continue to make vedio like that.
Sir bhot Kuch sikhne ko milta h aapse thank you so much sir😘😘😘😘😘😘😘😘 .........sir Mai gst invoice bill bna toh liya but sir eska Pura set-up print me nhi aata😥😥😥bhot paresan hu sir
Deepak sir very good video
v v good guide slow and good understand
Bahot hard
Very nice sir🌹🌹
😊😊
Dipak Sir, ye video bahut hi mast hai, aap cash book ka video release kare, usme cas book me jurnal entries karne ke baad khud cash book fill ho jai
Ur Excel video excellent
Dasu format bhai thanks
EXCELLENT JOB FOR SOCIETY. LEKIN JAB BILL AMOUNT LAKHS SE UPER HOTA HAI TO =SPELLNUMBER() FORMULA KO SAHI KASE SAHI KARNA PLZ REPLY.
Hi, Deepak I really appreciate your work. Thank you so much. I am learning MS office by your channel. I have learned a lot. Thank you.
Hi good Morning / Namaskaar,
i am one of your subscriber , just from last month or 2 months.
I really appreciated all your work, and specially the way you are teaching, and a special quality sound and very effective Voice Volume, i always watching your everyone single video, and really feeling thirsty in day without your videos.
+Ibrahim Muhammad thanks alot... 👍👍👍
sir ji apko bahut bahut dhanya bad.mere ek chhotasa request tha invoice number agar automated hota to achchha hota
Aap plz hmare channel ki playlist dekho.. special INVOICES KI playlist hai .. 5 video hain invoice ke👍
Very easily teach the Invoice Format. Lot of thanks sir Good night
Dilip Londhe thanks.... good night
Sir please include purchase sale and stock balance
Sir
You are great and there is no match in this video. Here we want to know how is converted Grand total to in word's.Kindly tell us if possible. Thanks
very nice information sir
Bhai maza a gaya zabardast ab try karunga
Ek chez maloom karni thi purchase or sale ka 2no ek jaisa rahega bill bs uper name change karna hoga
Plz waiting for answer
NYC video
Very very useful 😍
😊
Thank you very much
Very Good dear i like this
Loved it..
@deepak is video me drop down list add kesy kren gay plz btaen
awesome Sir ji . keep it up
Thank you
Deepakji
Very good and very simple sir how to create picture lookup in estimate format
like we select item description from the drop list then automatic reflect picture and all details only we can put qty
tnx very much
Proud you sir
Excellent Video Sir
thanks
Very useful
You can add one more formula to take the HSN/SAC Code and GST rate automatically when the product is selected.
Very interesting v... and big v... how u make sir thanks a lot of u
Deepak ji agar bill mai discount ya display party ko daina ho to gst kese calculate hoga with formula, or jo party ko products bill kiya hai unpai gst alg alg ho like (1 product 18% gst and other product 12% gst)
Thank you sir for sharing your knowledge i have learned many things.
i just want to know one more things that how to show calculation of HSN wise CGST SGST total in this invoice because as per GST rule we have to show classification of HSN and total CGST SGST on a particular HSN number. Please make a video in this.
Thank You
Nice sir or agar is sheet me row delete or row add karne ke liye button kese lagaye
Deepak sir
How are you?
please ik chota sa software complete bana sikhayen, jis main invoice, quotation, LPO, complete inventory, sale purchase, profit, loss day book, month book and annual report fully auto generate hon or print b ho skyen plz
Hello Bro,
Your video is very very good, I have also created the same invoice.
Thank you for your help.
Reagrds,
Rohan Garsund
SIR CUSTOMER KA GST NO.SAVE RAHA OSKI EXPLANATION KI VIDEO CHIYA AND THANK YOU SO MUCH SIR FOR THIS VIDEO
Hi Deepak ,
First I thank u for making video abt excel lesson.
Sir please give solution for party ledger, invoice number and receipt details also. Liked your video.
Please wait.. I ll publish video as soon as possible 🤗🤗🤗🤗
thank you so much brother....
Deepak Jee, excellent work, but i am facing a challenge while copying vlookup formula in the below cells. it changes the table array value. Please guide...
Lock table array range... By pressing f4
Salute you to create such a great video👍
😊
Formula put karke kaise hoga same cheez wo bhi daliye plz deepak ji.
Dear Deepak ji thank you for your excellent support.
My request is that please prepare a pos billing software with GST in excel which will keep inventory after each sale bill.
Once more thank you so so much for your kind support n excellent explanation.
Good day...
G
Nice video
Brilliant this video is very helpful for me
Nice.
sir database to add format seet and printing seet add to print
Can u pls make a video for inventory management & tax invoice for pharma wholesale?
Ok.. I ll publish video shortly
@@DeepakEduWorld luv u bro.
how z ur hlth
hi we have trouble when we take same product in second time then values are not show plz help me out
What to so if there are hundreds of line items, how to do multi page invoice??
Thank you Sir,
How to create user form and use long activate in Excel?
Sir isme table insert kr ke ho skta hai na..?
VERY GOOD EXPLANATION ABOUT HOW TO MAKE THIS EXCEL SHEET. BUT YOU SHOULD HAVE MADE AUTO FILLING OF SGST COLUMN WHEN ONE FILL CGST COLUMN OR VICEVERSA . IS THIS DOWNLOADED FILE EDITABLE? HOW TO REMOVE DROPDOWN MANUES AS WE HAVE ONLY CUSTOM MADE ITEMS? PLEASE REPLY.. HOW TO SAVE & PRINTTHIS INVOICE AND RETRIVE FOR EDITING PURPOSE?
sir vedio is very nice but i want to other litile knowledge cess amount in the coloum how to work and use
Mind blowing sir
thnx... bahut hi acha tha.......
Thanks see pak bhai
Thank u somuch bro.
Thnk u so much 🙏🙏🙏
Nice sir
helpful in gst work
Deepak Eduworld sir i saw each n every videos on your channel .
As a fresher i learn advanced excel that you shows in your videos but I didnot get job . Will you plz help me to get job in mumbai ?
Just practic excel.. By following my videos.. Each and every video is very helpful.. I hope if you are following my every videos.. You can easily crack interviews
+Deepak EduWorld thanks u so much Sir
finally I got a job
plz will you make some vedio macro and VBA basic level?
Sir isme stock maintain kaise kr sakte hai kitna gaya kitna aya uski report kaise bna sakte hai isi ke sath
Behtarin sir...
Tq sir
thank you for video sir , mera ek question tha if i want to set range of product items means agar mere 10 se jada product hi toh mai ek dynamic range option kaise bna sakta hu please ans
ruclips.net/video/EX2ZahZ3pHo/видео.html
Deepak Bhai Kya hm Excel me tally ke jesa software bna Skte h??
Or vo complete work kr Skte h Jo hm tally me krte h
Ys.. What type of software u wanna create??
I wanna to create a business software like tally in Excel that work exactly like tally.
Plz help me Deepak Bhai I really need a alternative software like tally
Masha Allah
Thank you my dear brother..
जय हिन्द फ्रोम नेपाल्
Dear Deepak ji thank you for your excellent support.
i have Used the below formula for PDF invoice creation
Private Sub CommandButton3_Click()
Sheet1.Range("B2:J48").ExportAsFixedFormat xlTypePDF, Filename:="C:\Users\admin\Desktop\RAMINV\" & Sheet1.Range("J12").Value, openafterpublish:=True
End Sub
for below error comes
" Run Time error 5
Invalid Procedure Call or argument"
sir print nikal ne ka bhi bataye plz
Pan kis key se hatate h
Cell range is not locked while applying vlookup hence error will come
Hello DIPAKJI, mera pharmaceutical ka business. Usme ek problem ho raha hain, ek hi product bar bar nehi le raha hain, aur dusri bad yeh hain ki main ek row chorke jab dusre row mein jabe raha hoon woh v nehi ho raha hain. Main use kar raha hoon EXCEL 2007
Please tell me how to create gst invoice in multiple gst rate on MRP based items
nice
Suggest me a video in which describe basic of excel,,, . How to use
Amount in Words ka video plz upload kijiye na sir
sir royalty kaise lagaye , rayalty added ek format dekhna hai .
Great bro
THANK YOU SO MUCH SIR THANK YOU VERY MUCH
Sir jo sheet 3 h kya use bs typ krne p ji auto options honge
Fully smjhaiy
dear.... this is working automatically with vlookup formula..... please watch vlookup video... link is in description.... thanks... i hope you can do it after knowing about vlookup...
day wise changing rate with different parties sales and purchase ,please send me one format
Great
Sir Electrical billing in project according BOQ batou ji plz