Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate
HTML-код
- Опубликовано: 18 ноя 2019
- 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.mylivesupport.in/
👉Subscribe Our New Channel - bit.ly/2JeYnM7
Download Invoice Format - drive.google.com/file/d/1wVMY...
Download Coding File to Save Invoice in Excel Format - drive.google.com/file/d/103Y9...
Download code for Next Invoice - drive.google.com/file/d/1YMq-...
Download Excel Addins File to Convert any Amount in INR - drive.google.com/file/d/1yu8q...
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
RUclips - / 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 ----------------
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/1.gif)
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.
Such a great vedio.... cleared all the problems with the help of your vedio... thanks
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
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👏👏👏💕💕💕
आपका दिल से धन्यवाद इतना अच्छा कमेंट लिखने के लिए🥰
it was exactly what i was looking for!!! Thanks for sharing this information and spread the knowledge. In this video you have saved the invoice in separate excel workbook but is there any way to save it next to the "Invoice Sheet" ?? Please help me
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 :))))
Very educational and clear concept. I Have watch so many channel but it is one of the great channel.
I loved this video which is very well minutely explained . Very Good work Chandanji. It is useful for all the excel lovers and accounts professional. My small request to you is, please tell me how to make and save invoice number wise, Goods/item wise daily report, so that MIS is made.
Thanks in advance
beautifully explained, nice attention on every detail, wonderful work .... Thanks a lot for uploading such informative video.
Really Excellent video. Thanks a lot to convey precious knowledge. Best Regards: Ikram Saeed from Lahore, Pakistan.
Thank you i have learned alot before i had zero knowledge regarding this now im good....
This is very very very great and helpful video on RUclips.. you are a great teacher .
Bhai bohot kaam ka video hai....
Good work
Thanks
Very Good Sir. Very nicely explained ..... Thank You !!
Invoice mein discount, packing charges, transport ke charges lagakar phir se GST Invoice banayiye please, please, please 🙏🙏🙏
Maa sha Allah.... Really like this my all problems is solved....
it's an awesome video with through explanation. I appreciate your effort. This video makes my work easy. Grate thanks to you .
Sir, awesome. very easy to understand for a new learner
Thank you sir 🤗
Your Excellency, you have made a wonderful video
AWESOME VIDEOS SIR,
HOW TO DEDUCT THE ITEM FROM STOCK,MAINTAIN PURCHASE DETAILS,SUPPLIER DETAILS,RECORD EXPENSES,PROFIT AND LOSS STATEMENT,CLOSING STOCK,SUPPLIER CLOSING BALANCE,CUSTOMER CLOSING BALANCE,AND WITHOUT ADDING CUSTOMER DETAILS IN THE CUSTOMER LIST AUTOMATICALLY RECORD DETAILS FROM THE INVOICE. PLEASE SHOW A VIDEO ON THIS TOPIC
really helpful video thanks sir kindly upload mis series.
Nicely explained formulas and macros in such a way that one can use it elsewhere too. I have some questions regarding. this lesson, which I will write soon for my personal requirements. Please reply.
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.
Sir, your videos are just perfect and easy to learn.
Thank you so much 😀🤗
@@MyLiveSupport sir i want to save these entries in another sheet on same workbook. How can i do it plz make video
thanx dear for your very nice presentation, its really helpful for me
Demo acca nhi lajawab lga mere Bhai I love you tumne Mera kaam itna assan kr diya ki kya bate
Sir, it excellent presentation by you, I have done and working through this.
Sir if we can provide, convert this invoice data in cash book, it will be more helpful to everyone.
Owsm video with great firmulas which i dint know till now
excellent work Bro. God Bless
Sir apki trick use karke pura sahi se bana diya mujhe ak jagah par dikkat aai hai but invoice complete ho gaya thankyou sir
Very helpfull vedio... Thank you
Thanks bhai for technical part....
Amezing....
Thanks for your excellent 😘 video lesson 😊
thank you sir. this is great video.
Its very useful information . Thanks bro
Thank you...
Super video... 👌👌👌👌👌
Superb dear... well explained... thanks a lot.
Awesome video... please add "Print Macro and Button" in this video
Really bro , too helpful and easy to under stand , all the best for your future, and am subscribe, because love your content
Superb explanation. Thanks.
Thank you brother for your full explain
Best video, well explained 👏
Excellent video for the preparation of GST invoice
Dear sir very nice information Really Excellent video.
8.39 टाइम पर आप ने कहा आंबे एजन्सी पर एक ही सिटी मे आंबे एजन्सी नाम की चार या पाच भी शॉप हो सकती है तो व्ही लुकअप तो गलत इन्फॉर्मेशन प्रोव्हाइड करेगा तो येतो सब गलत आउटपुट मिलेगा आपका positive response is appreciated
Very very helpful thanks sir
Very nice thanks a lot. explained very well
V good video and teaching way is excellent
Good content.
Bahot badhiya sirji
Sir, you are such a great
बहुत अच्छी वीडियो ।
Shukriya bhaijaan ❤️
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*
Thank you sir, I will WhatsApp you for GST Returns Input
@@MyLiveSupport my pleasure Chandanji will wait for the same
excellent video you are very intelligent
perfectly explained
Thanks lot brother.
I want to learn excel from basic pls suggest me playlist of ur vdos
Kya baat he sir . nice
Very good sir
You are the best
Hello brother
I hope you are all family well and fitness health.....
Brother you have made a gst sgst invoice i mostly liked but I want that you make in userform of this.....
Kindly I request to you soon as soon.
THANK YOU ....
Sir, I am using 2007 version of excel. Which version do you recommend to use..?
Nice video,
I want to set invoice name like: mjc/1, /SR.no.
Can you tell me the VBA code for this.
Also want to create PDF when click on next invoice button.
sir, how about locking the formulas? by mistake, I entered 1(one) in sr no., automatic formula got deleted. Please give some hint. Secondly, how can I simultaneously save as .pdf file? . Is there any lesson form you in which I can make sale-register i.e. certain cells like customer name, invoice no. date amount etc? (I mean those with drop-down menu or derived through formulas). I look forward for your reply.
Yehi to me dhundhta tha sir, thanks
great work
Great work
After data validation /List I could not go to next worksheet for custemer selection.how fix it ?
Thank you so much brother
Thank you...u have explained very nicely in detail so that anybody can easily understand...but one more thing... Whenever we enter the quantity in the invoice then how to automatically minus the quantity from the product list? Also I want the coding add on to convert amount into words can u please share it with me
That is my qeustion.
Iys there on the description. But my problem is that it is in rupee how do I now change it to Dollar or any other currency. Mine is Naira. Thanks sir
Khup Chhan sir..
Sir ji VBA code ke niyam ka 1 video bana dena ji
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
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 ?
Fantastic job 👌👌👍👍🙏🙏
Thank you 🤝🥰
you are brilliant
Really interesting and very good video, agar samvab hota to mai 1000 like de dete, really really good. Keep it up, ✌
good explanation sir
Thank you 👍👍 sir
Thank you sir 🙏
Good explaination
Nice work😊👍
Thanks you very very much
Sir I want save the invoice with invoice number and name of the customer .eg 1.Customer name , 2 Customer name .....like wise
Maja aagaya bhai thanks sir
Thanks 😊
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.
Sir, Please, ek video sirf errors ke baare mein banayiye. It will be very helpful and easier to understand and correct them.
I really like this video
I can't understand your language but I can understand your teaching. Very well teaching
Really great video. Please make print macro....
Great man,complicated for person like me but manageable, can't you just provide a link to download it🤗
check description for download link
Great but invoice bnate waqt intra ya inter state sale ka option ka dhyan rkhna padega usse acha formola use kar skte ha
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...
Bahot badiya
Thanks for such a great video. Only one request. After downloading invoice format, party list folder is not getting downloaded. Kindly help.
thank you sir
Thanks for the video sir. It is really easy to understand. My question is how can I change the currency from rupee to another currency. Pls sir I did like you to attend to it.
Thank you 🙏🏻 I
Bhai yeah second macro assin nai hora error dera