Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate

  Рет қаралды 260,853

My Live Support

My Live Support

Күн бұрын

Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate 👉 Doston is video me maine apko bataya hai ki kis tarah aap excel me fully automatic GST Invoice or Bill bana sakte hai. Excel mein aap is method ka use karke Multple GST Rates or Multiple Items ke liye Bill or Invoice bana sakte hai.
👉Get Our Complete Excel Course Now - www.mylivesupp...
👉Subscribe Our New Channel - bit.ly/2JeYnM7
Download Invoice Format - drive.google.c...
Download Coding File to Save Invoice in Excel Format - drive.google.c...
Download code for Next Invoice - drive.google.c...
Download Excel Addins File to Convert any Amount in INR - drive.google.c...
Topic Discussed in this video :
1. How to make Fully Automatic GST Invoice in Microsoft Excel
2. How to make Fully Automatic GST Bill in Microsoft Excel
3. How to prepare Tax Invoice or Bill in MS Excel
4. How to make Fully Automatic Performa Invoice in Excel
5. How to take backup of Each Invoice in Microsoft Excel
6. How to Save All Invoice or Bill in Excel Automatically
7. How to Make Invoice or Bill in Excel for multiple GST Rates
8. How to make Bill or Invoice in Excel for Multiple Items.
9. Excel mein GST Invoice kaise banayein
10. Excel mein GST Bill Kaise Banayein
❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
Please support me on
Like us on Facebook - / mylivesupport
Website - mylivesupport.in/
Follow us on Twitter - / mylivesupport
Follow us Instagram - / mylivesupport
Facebook Myself - / chandankumar926
KZbin - / mylivesupport
▶️WATCH ALL VIDEOS FROM BELOW PLAYLIST :
▶️All Video for MS Excel Magic Trick Series - goo.gl/qS296Q
▶️All Advanced Excel Video in Hindi - bit.ly/2Ej6Viy
▶️All Computer Tips and Tricks Video in Hindi - bit.ly/2Pj70Ji
▶️Top 10 Excel Video in Hindi - goo.gl/McEe53
▶️All Videos of Excel in Hindi - goo.gl/boUo8C
▶️All Videos of Technology in Hindi - goo.gl/E9VyCA
▶️All Videos of MS Excel VBA in Hindi - goo.gl/W4pb5t
▶️All Videos for Tally.ERP9 GST in Hindi - goo.gl/CbsFhr
#fullyautomatic #GST #Invoice #excel #exceltips #exceltrick #HindiTutorial
Most Useful Videos of Our Channel - Must Watch
▶️How to Convert Handwritten Notes in MS Word using Google Drive | Hindi Tutorial • How to Convert Handwri...
▶️How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi • How to Maintain Attend...
▶️Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate • Make Fully Automatic G...
▶️🔥How to Recover Unsaved MS Office Files | Excel | Word | PowerPoint without any Software 🔥 • 🔥How to Recover Unsave...
▶️Excel में किसी भी Sheet को Print करो Expert की तरह | Become MS Excel Expert • Excel में किसी भी Shee...
▶️Ms Word में Expert बनना है तो इन 5 Magical Tricks का USE करना सीखलो • Ms Word में Expert बनन...
Our aim behind making this channel to make you expert in Microsoft Excel, Microsoft Word, Tally.ERP9, Computer and Technology. You can easily learn Excel, Word, Tally, Internet, Computer in Hindi language. So don’t forget to Subscribe Our Channel.
learn excel in hindi,excel formulas in hindi,excel in hindi,advanced excel in hindi,ms excel tutorial in hindi,learn ms excel in hindi,excel,excel course in hindi,free excel training,learn excel online,advanced excel,advanced excel formulas,microsoft excel,ms excel 2007,ms excel 2016,ms excel 2019,excel for beginners,excel function in hindi,ms excel tutorial,excel tutorials,invoice in excel,bill in excel,gst invoice in excel,make invoice in excel,make bill in excel,automatic invoice in excel,automatic bill in excel
---------------- Chandan Kumar ----------------

Пікірлер: 461
@basweerrashid690
@basweerrashid690 4 жыл бұрын
Yaar such mai mena aaj bahot kuch seeka hai appse... Thank you so much... her aik action app samja tay hain even the keyboard actions which you doing... really loved it👏👏👏💕💕💕
@MyLiveSupport
@MyLiveSupport 4 жыл бұрын
आपका दिल से धन्यवाद इतना अच्छा कमेंट लिखने के लिए🥰
@Its_Zeeshan_Khan
@Its_Zeeshan_Khan 5 ай бұрын
Very Nice brother, Exactly yahi video ki talaash thi, thank you for covering all the things one single video. THANKS AGAIN!!!!! ❤❤❤
@rakesh-9924
@rakesh-9924 3 жыл бұрын
Thank you... Super video... 👌👌👌👌👌
@TallyAccountingSolution
@TallyAccountingSolution 5 жыл бұрын
Bhai bohot kaam ka video hai.... Good work
@MyLiveSupport
@MyLiveSupport 5 жыл бұрын
Thanks
@aparajitaenterprise1957
@aparajitaenterprise1957 3 жыл бұрын
Very educational and clear concept. I Have watch so many channel but it is one of the great channel.
@tastygate1928
@tastygate1928 4 жыл бұрын
Outstanding. I do not speak or understand Hindi, but the presentation outlay was clear and concise that I could follow. Thumbs up and thank you
@MRLAUGHLAGOON
@MRLAUGHLAGOON 11 ай бұрын
Demo acca nhi lajawab lga mere Bhai I love you tumne Mera kaam itna assan kr diya ki kya bate
@spuranik007
@spuranik007 4 жыл бұрын
It was such a wonderful experience of preparation of automated worksheet . A beautiful art of hand holding perfected by you is very rare. It is very scarce to find people who wholeheartedly share their knowledge, without hiding anything. I am a very senior person, & touched excel after a gap of many decades. I worked in the era of 123. After finding people exploiting for software with recurring cost, I wanted do it on my own with my engineering background but I couldn't make progress till I came across your video. May God bless you .I am sure you would continue your good work.
@Heyvihar
@Heyvihar 4 жыл бұрын
This is very very very great and helpful video on KZbin.. you are a great teacher .
@amitthakur3941
@amitthakur3941 4 жыл бұрын
Such a great vedio.... cleared all the problems with the help of your vedio... thanks
@gomatidas8421
@gomatidas8421 2 жыл бұрын
it's an awesome video with through explanation. I appreciate your effort. This video makes my work easy. Grate thanks to you .
@MightyTechGuy
@MightyTechGuy 4 жыл бұрын
Watched full video in detail, 1 hour kese nikal gaya pata hi nahi chala.. you are very engaging and talented as well.. Keep up the good work :))))
@darkkingshirohigerayleigh2929
@darkkingshirohigerayleigh2929 4 жыл бұрын
Thank you i have learned alot before i had zero knowledge regarding this now im good....
@saeedmart
@saeedmart 4 жыл бұрын
Really Excellent video. Thanks a lot to convey precious knowledge. Best Regards: Ikram Saeed from Lahore, Pakistan.
@mohsinjameel9718
@mohsinjameel9718 3 жыл бұрын
Maa sha Allah.... Really like this my all problems is solved....
@TVSCDN
@TVSCDN 5 жыл бұрын
Thanks for your excellent 😘 video lesson 😊
@RamdasAvachar
@RamdasAvachar Жыл бұрын
Sir apki trick use karke pura sahi se bana diya mujhe ak jagah par dikkat aai hai but invoice complete ho gaya thankyou sir
@atiqrehman1223
@atiqrehman1223 5 ай бұрын
great work. You are marvellous sir.
@loveking2350
@loveking2350 4 жыл бұрын
I can't understand your language but I can understand your teaching. Very well teaching
@arpitbajpai6498
@arpitbajpai6498 3 жыл бұрын
Very good sir You are the best
@ivp2264
@ivp2264 Жыл бұрын
Yehi to me dhundhta tha sir, thanks
@santdnyaneshwar9920
@santdnyaneshwar9920 2 жыл бұрын
Sir, isme kuchh problem face karne pad sakte hai.. jaise ➡️ 📀1) 'New Invoice' par galati se 2-3 ya jyada baar click karenge to auto Invoice number change hota rahega aur blank invoice ko invoice number assign hota rahega, yeh galti se bhi nahi hona chahiye... 📀2) Save Data / Save Invoice par bill complete karne se pahle click karte hai aur fir bill me kuchh updation karte hai aur Save Invoice karenge to ek hi invoice multiple times backup me save nahi hona chahiye.. 📀3) =today() yeh formula bill date ke liye lagate hai to sabhi old invoice ka date bhi current date hi aata rahega.. yeh bhi wrong ho jayega.. baki sabhi automated functions 👌👌👌👌👌👌👌👌👌👌👌 In short hum agar janbujhkar bhi koi galti karna chahe to vah nahi honi chahiye... then it will be a perfect auto invoice...
@enlifebiotech5971
@enlifebiotech5971 2 жыл бұрын
beautifully explained, nice attention on every detail, wonderful work .... Thanks a lot for uploading such informative video.
@mohammadjaved5205
@mohammadjaved5205 4 жыл бұрын
V good video and teaching way is excellent
@prashantg8973
@prashantg8973 4 жыл бұрын
Very Good Sir. Very nicely explained ..... Thank You !!
@jeevansolanki848
@jeevansolanki848 2 жыл бұрын
Excellent video for the preparation of GST invoice
@jeetendersadh6386
@jeetendersadh6386 4 жыл бұрын
Thanks bhai for technical part....
@omdevsinhjadeja7007
@omdevsinhjadeja7007 4 жыл бұрын
Owsm video with great firmulas which i dint know till now
@gautamprasaddewangan593
@gautamprasaddewangan593 4 жыл бұрын
thanx dear for your very nice presentation, its really helpful for me
@bhaveshrchangela
@bhaveshrchangela 2 жыл бұрын
Dear sir very nice information Really Excellent video.
@nisarahmed4424
@nisarahmed4424 Жыл бұрын
Very nice thanks a lot. explained very well
@yashupanwar4891
@yashupanwar4891 3 жыл бұрын
Sir, you are such a great
@nastharbabu3555
@nastharbabu3555 4 жыл бұрын
Superb dear... well explained... thanks a lot.
@rajatjagga1922
@rajatjagga1922 4 жыл бұрын
Great but invoice bnate waqt intra ya inter state sale ka option ka dhyan rkhna padega usse acha formola use kar skte ha
@sureshkonatam
@sureshkonatam 3 жыл бұрын
Its very useful information . Thanks bro
@nishuraja31
@nishuraja31 4 жыл бұрын
Really interesting and very good video, agar samvab hota to mai 1000 like de dete, really really good. Keep it up, ✌
@chintamanikulkarni1787
@chintamanikulkarni1787 5 жыл бұрын
Fantastic job 👌👌👍👍🙏🙏
@MyLiveSupport
@MyLiveSupport 5 жыл бұрын
Thank you 🤝🥰
@nagendersingh2465
@nagendersingh2465 2 жыл бұрын
Best video, well explained 👏
@rajeshshah6758
@rajeshshah6758 5 жыл бұрын
Sir, awesome. very easy to understand for a new learner
@MyLiveSupport
@MyLiveSupport 5 жыл бұрын
Thank you sir 🤗
@sayeedrahman2397
@sayeedrahman2397 Жыл бұрын
Superb explanation. Thanks.
@pramoddas4756
@pramoddas4756 3 жыл бұрын
Thank you brother for your full explain
@rajbeersingh6555
@rajbeersingh6555 2 жыл бұрын
excellent video you are very intelligent
@mudalivenky1957
@mudalivenky1957 Жыл бұрын
बहुत अच्छी वीडियो ।
@geevee909
@geevee909 3 жыл бұрын
Good Evening sir 🙏
@prabhakarpawar573
@prabhakarpawar573 3 жыл бұрын
Bahot badhiya sirji
@razzakkhan9367
@razzakkhan9367 4 жыл бұрын
Shukriya bhaijaan ❤️
@luqmannawaz2291
@luqmannawaz2291 3 жыл бұрын
👍👍👍👌
@tanujmahule8599
@tanujmahule8599 3 жыл бұрын
Maja aagaya bhai thanks sir
@MyLiveSupport
@MyLiveSupport 3 жыл бұрын
Thanks 😊
@uttampersonal69
@uttampersonal69 4 жыл бұрын
Khub sundar vidio
@MyLiveSupport
@MyLiveSupport 4 жыл бұрын
Thanks 🥰
@vaishyarharjibhai3289
@vaishyarharjibhai3289 4 жыл бұрын
Kya baat he sir . nice
@rajeevgosavi4514
@rajeevgosavi4514 10 ай бұрын
Thanks for such a great video. Only one request. After downloading invoice format, party list folder is not getting downloaded. Kindly help.
@MrBhopinderkumar
@MrBhopinderkumar 5 жыл бұрын
Nice video chandan ji
@threestarcomputers691
@threestarcomputers691 4 жыл бұрын
good explanation sir
@priyapandey2723
@priyapandey2723 3 жыл бұрын
I really like this video
@sandipdhodia7140
@sandipdhodia7140 3 жыл бұрын
Thank you 👍👍 sir
@sagardhaware8389
@sagardhaware8389 4 жыл бұрын
8.39 टाइम पर आप ने कहा आंबे एजन्सी पर एक ही सिटी मे आंबे एजन्सी नाम की चार या पाच भी शॉप हो सकती है तो व्ही लुकअप तो गलत इन्फॉर्मेशन प्रोव्हाइड करेगा तो येतो सब गलत आउटपुट मिलेगा आपका positive response is appreciated
@channelsolutions3573
@channelsolutions3573 Жыл бұрын
Sir agar Hume invoice ko party ke name aur invoice number dono eksath save karna ho to Video me yato party name ka option hai ya to invoice number ka option hai but humko dono ek sath me chahiye krupaya bataye ....
@srijansvlog5739
@srijansvlog5739 4 жыл бұрын
Very helpfull vedio... Thank you
@ajaypundir38
@ajaypundir38 4 жыл бұрын
Thanks you very very much
@bal_kamalvir
@bal_kamalvir 2 жыл бұрын
Good explaination
@vishalbhati912
@vishalbhati912 4 жыл бұрын
Bahot badiya
@asimsiddiq475
@asimsiddiq475 4 жыл бұрын
you are brilliant
@rabharat
@rabharat 4 жыл бұрын
Really bro , too helpful and easy to under stand , all the best for your future, and am subscribe, because love your content
@mohammedamir5094
@mohammedamir5094 4 жыл бұрын
Great work
@rajkumarshaw1221
@rajkumarshaw1221 3 жыл бұрын
Thank you sir 🙏
@jasvindersingh2640
@jasvindersingh2640 Жыл бұрын
good invoice automated worksheet
@hanumansingh6284
@hanumansingh6284 4 жыл бұрын
Very nice Sir
@loveislife4769
@loveislife4769 Жыл бұрын
Very nice video
@vaibhavbhagat254
@vaibhavbhagat254 4 жыл бұрын
sir excel mai jo invoice save hoga , kya formula active rahenge , ya sirf values hogi, kya aisa invoice edit hoga, aur agar mai kuch changes karta hu price list mai to kya already save invoice ki amount change hogi
@surajrwt524
@surajrwt524 2 жыл бұрын
Bhai verry well Great guru ho aap one question🙋🙋 Yadi ham vlookup ki jagha only lookup use karr to y kamm karryga Only for only for confused hu And plz replay me Plz plz plz 🙏🙏🙏🙏🙏🙏 Plz plz Suraj Rawat
@prateeksharma277
@prateeksharma277 Жыл бұрын
Sir isko apn bna k kese or pc m use krege to forumla disturb to nhi hoga na
@yogendrashaw3800
@yogendrashaw3800 3 жыл бұрын
You do the good work in fully automatic gst invoice but our one question that how to calculate multiple gst rate in under one gst invoice. For example I want make gst invoice and gst rate is 12%,18%,5% then how can do it. Please advice or any other video of your for this issue.
@dharmrajbairwa3992
@dharmrajbairwa3992 5 жыл бұрын
Very very helpful thanks sir
@azharyounas5523
@azharyounas5523 3 жыл бұрын
Very helpfull thanks I want to khow that Can we have our last invoice by adding one more button like previous invoice along with next invoice ?
@baponpal8234
@baponpal8234 4 жыл бұрын
Sir upko video bahut achha laga mujhe... Sir I have a question... Sir drop down list mein kaise search option create kru
@Mgopi1111
@Mgopi1111 3 жыл бұрын
excellent work Bro. God Bless
@rajatkumaryadav9438
@rajatkumaryadav9438 3 жыл бұрын
Great sir ,But supposed kisi pichale saved bill mai kuch edit karna hai to kaise kare and re-save kaise kare
@rajeshshah6758
@rajeshshah6758 5 жыл бұрын
Sir, your videos are just perfect and easy to learn.
@MyLiveSupport
@MyLiveSupport 5 жыл бұрын
Thank you so much 😀🤗
@abhilashgupta5799
@abhilashgupta5799 4 жыл бұрын
@@MyLiveSupport sir i want to save these entries in another sheet on same workbook. How can i do it plz make video
@raiismail5962
@raiismail5962 4 жыл бұрын
Your Excellency, you have made a wonderful video
@santoshponnu4142
@santoshponnu4142 4 жыл бұрын
Can we create partywise itemlist which would be searchable
@arunmhaskar
@arunmhaskar 5 жыл бұрын
Really good. It created an interest to learn more of excel at the age of 60. My dear friend I put the image of Our logo in left corner. When we press next the copy of the excel sheet is getting saved. But in original sheet the logo gets disappear. Please help. Rest everything works really brilliant. Thank you ! God bless you Always.
@ajikumarvk3244
@ajikumarvk3244 4 жыл бұрын
After data validation /List I could not go to next worksheet for custemer selection.how fix it ?
@SanjayYadav-tv5ie
@SanjayYadav-tv5ie 4 жыл бұрын
Very Nice Video
@kiranbandekar2434
@kiranbandekar2434 4 жыл бұрын
Khup Chhan sir.. Sir ji VBA code ke niyam ka 1 video bana dena ji
@arojitbiswas5599
@arojitbiswas5599 5 жыл бұрын
Nice work
@MyLiveSupport
@MyLiveSupport 5 жыл бұрын
Thanks
@apachepremiumqualityproduc3949
@apachepremiumqualityproduc3949 4 жыл бұрын
Thank you so much brother
@snvrisk786
@snvrisk786 3 жыл бұрын
as per your video you save bill with number but if i want to save bill with client name so what is the formula of it.i write this formula but its not work. NewFN = "C:\Users\admin\Desktop\invoice date\" & Range ("c8:h8").Value & ".xlsx", my client name is show between c8 to h8 cell, so plz suggest
@hamidmukhi8918
@hamidmukhi8918 2 жыл бұрын
Sir bohot clearly apne explain kia but 1 help hai ki apne jo invoice separate work mai save karne ka formula ki link mai dia hai usme error araha hai error hai (Sub or Function not defined) sir please help to solve this error
@108_vaibhavmahajan9
@108_vaibhavmahajan9 3 жыл бұрын
Nice work😊👍
@sanjeevtripathi5014
@sanjeevtripathi5014 5 жыл бұрын
Thanks for bringing such demanded video Chandanji do also make videos on how to *file GST returns and what all inputs required to file it*
@MyLiveSupport
@MyLiveSupport 5 жыл бұрын
Thank you sir, I will WhatsApp you for GST Returns Input
@sanjeevtripathi5014
@sanjeevtripathi5014 5 жыл бұрын
@@MyLiveSupport my pleasure Chandanji will wait for the same
@shanky645
@shanky645 Жыл бұрын
Hi am facing problem to feeding data in the cell. whenever i any information i have go the pop-up from Microsoft Visual basic of application: Error is only comments may appear after End Sub, End Function , or End Property. One more thing i want know is it possible when i command next invoice and it save other folder in excel can possible in PDF?
@nityagdas5228
@nityagdas5228 4 жыл бұрын
Excel GURU hain aap. Sirji ek auto save video bhi banaiye please. Matlab Next Invoice click karne ka saath saath previous invoice clear ka sath sath auto save bhi ho jayega.
@MyLiveSupport
@MyLiveSupport 4 жыл бұрын
Sir last mein ye bhi bataya hai
@nityagdas5228
@nityagdas5228 4 жыл бұрын
@@MyLiveSupport sorry sir, maine pura video dekha nehi. Actually main bahud excited tha. Tons of love sirji. ❤️❤️❤️🙏🙏🙏🙏
@akhileshshahi7731
@akhileshshahi7731 5 жыл бұрын
really helpful video thanks sir kindly upload mis series.
@Green_Life123
@Green_Life123 Жыл бұрын
bhai aap igst or cgst ko ek sath add krke btao kese krna invoice sheet
@khalidmahmoodtariq4995
@khalidmahmoodtariq4995 2 жыл бұрын
nice lecture
@harisshah4189
@harisshah4189 4 жыл бұрын
sir esa ho sakta hai k hame jitna bhi invoice bana na hai utna hi bane suppose agar 5 products ka bana naa hai tw 5 product k bad total amount ajaye and bill wahi tak rahe if you want please reply here..
@veenarathod4184
@veenarathod4184 4 жыл бұрын
thank you sir. this is great video.
@AlpoalpoPaglami1767
@AlpoalpoPaglami1767 2 жыл бұрын
Sir kia ai invoice life time use kar sakte hay ..yea kuch month baad expire ho jaia ga ??Plz ans me sir
@vikashkumarsharma3813
@vikashkumarsharma3813 3 жыл бұрын
Great sir
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 20 МЛН
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 62 МЛН
Excel Formulas and Functions | Full Course
52:40
Kevin Stratvert
Рет қаралды 1,7 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 1,1 МЛН
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН