Deepak jee !!! Yesterday i m facing issue to save as pdf option but now all options are working properly. Thanks a lot finally I have completed 3 parts of invoice making process myself for my business.
Respected Sir Mai aapke sabhi video ka pratical karta hu or bo bilkul 100% acurate hoti hai. Or mughe bahut sari chheje sikhne ko mili jo mughe nhi pta tha.So, heartly Tankyou.
dipak ji .. kinti baar aap mera jaan bacha lia... aap ka yea sob trick sikh sikh kar mai popular v ho gaya hu office me and mera promotion ve hone wala he ... Thanks you dipak ji.
Sir, Thank you. You are great, you are really a magician. i have never ever seen any excel master like you. I am very good in excel and i think so but when i see your videos, i am no where. i would like to talk once with you and it is my honor to talk with you once. Once again thank you so much for your precious valuable time to guide us.
Bohot din se dhoon raha tha ee option.. I tried it and got success. bohot kam ka hai eee.. u r great.. u shows code in very easy way pls add auto clear in this butten ager generate of pdf
बहुत बहुत धन्यवाद दीपक जी । बहुतै अच्छी जानकारी मिली आपके इन तीनो वीडियो से । BV6 वाली कोडिंग की शॉफ्ट कॉपी की लिंक दे सके तो हमारा समय बच जाए ।। 🙏🙏🙏🙏🙏🙏🙏
ASSALAM-O-ALAIKUM DEAR GOOD TO HEAR THAT YOU GOT SUCCESS IN MAKING COMPLETE INVOICE FILE KINDLY SEND YOUR FILE AT MY EMAIL ID ABDULMAJIDKHAN84@GMAIL.COM I SHALL BE VERY THANKFUL TO YOU I NEED TO MAKE A SMALL SHOP SOFTWARE IN EXCEL THANKS IN ADVANCE
Thanks a lot sir , u solved a big problem . It is so easy that even a non computer background person like me can do it . It will be be further helpful if u kindly tell us how to save this in excel only format .
दीपक जी आपका video काफी useful है वैसे तो आपके समझाने से मैं कर लूँगा पर कुछ लोगो के लिए हेल्पफुल हो की आप Party Name को भी एक अलग sheet से link कर के Pick करा कर समझा दें जिससे की बार बार Address और GSTIN Automatic आ जाये और गलती के Chance भी कम हो जाये Very Very thankful for your Detailed Explained Video
Deepak Ji, Namaste, It is very very nice & important training given by you, I already prepare a bill format in excel,but that time I could`nt understand how to save it or backup it, now I learn it from you,Thanks ,God bless you & fulfill all your dreams true.Can we make it for large data of various types of stock item & there sizes,like as inventory register,please help,
Very very informative and use full video given by you. Deepak sir kya aap video bana sakte hai..? Jisme party ka name,bill amount,gst detail type karte hi automatic bill me save ho jaye Jaise jaise table me details fill karege new bill generate hoga and save bhi kar paye
Sir, You r doing great job. Sir it is my earnest request to you please make some videos on Macro Coding from basic to advance with every description. Thank u so much
Deepakji. My sincere thanks to you from my bottom of my heart. request you to guide me how to create buttons "Print", "go to previous invoice" in the excel sheet
thank you sir bahut kuchh maine apke video se sikha hai ab ap yeh bataye jab koi bill mai banau to net pay total kisi sell me jakar ruke average aur profit sab kisi sell me jakar ruke aur jo item mai sale karun oh stock se automatic cut jaye yani kam ho jaye take end par jab closing karun to mujhe pata chale aj ka sale kitna hai profit kitna hai aur ek aisa button vi ho Clears all items us par jaise click karun ganad total profit average sab cleare ho jaye next day ke liye bahut meharbani hogi fir jakar complete software hoga sir
Thanks a lot, it works for me, can you please also tell me 1) How can i save 3 copies like original,duplicate and triplicate files. 2)Also want to save file as customername+invoicenumber
really ye bahot superb hai lekin jaise apne pdf me save karna bataya vaise hi kya print bhi kar sakte hai kya agar possible hai to print karna bhi sikhaiye
Nice one 👍 deepak ji but is me party details ka bhi kuch advance feature banana sikiya ga jaise party name select kare to us ka address gst no automatic select ho jaye
Lovely sir, may Allah give u all u want my prayers with u always, sir one little request plz plz plz plz je sa ap ye invoice banaya he aor sikhaya sir plz plz 1 aor hum pe ehsan karen k isee invoice ki tarh excel mn pos invoice banana sikhao plz plz plz
Hello sir your page is a awesome information but please make a video for invoice in which there is recepient copy, transport copy , seller copy and data will be save as seller copy!!
Thank you sir very much .I made automatic invoice by watching your video and also save in pdf file .but there is one problem when I click on data validation it will not go on the other sheet.But thank you sir very much...
Hello Thank u very much for such productive uploads. I have all these steps and made invoice and saved it as well. I have one issue if u can help please. I want that after saving the invoice it should update the inventory list means to subtract the stock so i should what remains how much. Waiting for yr reply. I saw some videos but can not understand from them like urs.
Please tell me how it will be possible. There r videos available but i can not understand them. Ur way of teaching i understand very well and fast. Waiting
Please also make a video on "retail products invetory" which auto reflects after adding and subtracting products after daily sale and purchase. If you have already then please share the link. Thanks in advance.
Here is the solution for all of those who had issues with EXCEL 2013 ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Oliver\Desktop\HOJAS DE RUTA\" & ActiveSheet.Range("G8").Value, openafterpublish:=True Took me a while to figured it out xD
HELLO BROTHER. AS USUAL A VERY INFORMATIVE VIDEO. ALL DONE VERY SUCCESSFULLY EXCEPT 1 THING. I APPLIED SUM FORMULAS AGAINST THE DATA AS"PREVIOUS BALANCE, INSTALMENT RECEIVED, FRESH BALANCE,". WHEN I CLICK NEW INVOICE, PREVIOUS DATA ALONGWITH FORMULAS ALSO DELETED. I HAVE TO INSERT SUM FORMULA AGAIN AND AGAIN. PLEASE HELP
Sir aapka jo automatic invoice ka video tha that was very good. I made it for my father. But I'm in kota preparing for JEE. And some times he needs help because he is not expert in computer. And I want to purchase macbook air for me. So what I want to know is that the Invoice made on windows pc can it be edited on macbook too. So that I cn send him back through gmail after making correction in the formula
This tutorial is very helpful. I complied all 3 parts and it's working very nice. JUST FACING ONE ISSUE... ITS NOT SAVING LOGO(PICTURE) IN PDF... ANY UPDATE IN SCRIPT REQUIERED
Sir, Very interesting. Video. AlSo knowledge ful. Can we Edit saved invoice by calling back to invoice template.? If yes, Please send me the VBA code for Edit Invoice Button. Also can save edited invoice to Save data Sheet. Please send VBA Sir.
Hello you are really great, thank you for your videos I just want to ask can we save invoice with 2 different cell together e.g. invoice number along with party name in different 2 cell please guide
Please upgrade excel to 2010... To do this.. Without any problem... Specially to fix run time error 5
Deepak sir
Main ms office 2007 use kar raha hu
Isme auto save pfd nahi kaam kar raha hai please muje bataye kya karu
Download save as PDF exe from Microsoft site and install it will work
OK SIR thanks a lot
i will try office 2013,2016
Hi bhai mje ek sawal kr na h
Help me sir
Dear Deepok, Many thanks from my heart for these tutorials you made ! It is a great help for us. Keep it up. Wish you all the very best.
I am from Pakistan and i am really thankful to you sir. Your are a great teacher. God bless you.
hello sir mene savepdf try kiya but muje error ati he
run-time error '5':
invalid procedure call or argument
Deepak jee !!! Yesterday i m facing issue to save as pdf option but now all options are working properly.
Thanks a lot finally I have completed 3 parts of invoice making process myself for my business.
Respected Sir
Mai aapke sabhi video ka pratical karta hu or bo bilkul 100% acurate hoti hai. Or mughe bahut sari chheje sikhne ko mili jo mughe nhi pta tha.So, heartly Tankyou.
i get a run time error '5' ,invalid procedure call or argument when I press the 'save invoice' button.I changed the save folder location in VB code
Which excel version u r using excel??
I have also same problem im using 2013 version
I Deepak ji...when I click on save invoice button it's showing error Please help me
Please help me with the savings error problem as I mentioned earlier
Same problem
dipak ji .. kinti baar aap mera jaan bacha lia... aap ka yea sob trick sikh sikh kar mai popular v ho gaya hu office me and mera promotion ve hone wala he ...
Thanks you dipak ji.
😊😊😊😊😊👍👍
Sir, Thank you. You are great, you are really a magician. i have never ever seen any excel master like you.
I am very good in excel and i think so but when i see your videos, i am no where.
i would like to talk once with you and it is my honor to talk with you once.
Once again thank you so much for your precious valuable time to guide us.
sir aapka koi jawab nhi me dil se share krta hu aapki video....
Deepak sir danyvad itne acche video dikhane ke liye Jo game bhavisiy me bahut kaam ane vale hai
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Bohot din se dhoon raha tha ee option..
I tried it and got success.
bohot kam ka hai eee..
u r great..
u shows code in very easy way
pls add auto clear in this butten ager generate of pdf
Ok..in next part of this video 👍
Thanks a lot Deepak ji finally I have completed 3 parts of invoice making process myself for my business. Abidul Haque. Guwahati .
😁🤗👍👍👍👍
thanks dear i have been using this format last 1 year sometimes i got error and will fix the error by watching again this video.
KYA BAAT HAI MANE KAR LEYE NEW INVOICE CREATE ...REALLY LIKE YOU
deepak bai aap ne bahuth acha explain kiya hai i like u r video bai sukriya . Nawas From Madharasi Tamilan.
😊😊😊😊😊😊😊😊😊😊😊😊
बहुत बहुत धन्यवाद दीपक जी । बहुतै अच्छी जानकारी मिली आपके इन तीनो वीडियो से । BV6 वाली कोडिंग की शॉफ्ट कॉपी की लिंक दे सके तो हमारा समय बच जाए ।। 🙏🙏🙏🙏🙏🙏🙏
Salute Mr Deepak 👍 Appreciate rightly from heart.
Hi Deepak you r doing a great job in a fantastic style.
Sir Aapka kaam Aur Videos bahut Ache hai please sir Ms Access main Complete Invoice Videos need
Thanks a lot sir it worked h have been the ultimate teacher that I have been looking for
Thanks
You are a good teacher. Wish you all the best.
God made you so innocent and simple guy I like you.
Thank you sir.. really good job. I have completed all 3 parts of invoice and it's working very nice. Keep us educating.
How you have done ? can u pls send me that excel file to my email id- kdrverma@yahoo.co.in bcz im unable to complete the part 3
ASSALAM-O-ALAIKUM DEAR GOOD TO HEAR THAT YOU GOT SUCCESS IN MAKING COMPLETE INVOICE FILE KINDLY SEND YOUR FILE AT MY EMAIL ID ABDULMAJIDKHAN84@GMAIL.COM I SHALL BE VERY THANKFUL TO YOU I NEED TO MAKE A SMALL SHOP SOFTWARE IN EXCEL THANKS IN ADVANCE
Many Many thanks sir,i have successfully created invoice temp let with all automatic feature .
😊
Sir Aapke Sare video bhut hi aache h ! Nice
owsom bhaiya.... mujhe apki voice bahut achhi lgi or apki samjhane ki technique
I have done all feature in invoice. Thankyou Deepak brother.
can u pls help me how to finish part 3 ? or u can send me that excel sheet to my email id - kdrverma@yahoo.co.in which you had made
sirji
tussi gr8 ho
thanks for for teaching so much in so much details & with lot of easyness
really thanks a lot
+sumiit ahire 👍
Hello sir you tought very good. GST part three very best and important.
Thanks a lot sir , u solved a big problem . It is so easy that even a non computer background person like me can do it . It will be be further helpful if u kindly tell us how to save this in excel only format .
Very very thanks bhaiya... For your guide. It's too helpful. Thanks again.
Thanks bro. I'm from Sri Lanka ❤️
bohut aatsa laga apka video dekhke.
Sir ji bahut hi jada jabardast hai aap to yr excel ke god ho, 😘😘😘
Hi Bro your teaching more interesting. Thanks
दीपक जी आपका video काफी useful है
वैसे तो आपके समझाने से मैं कर लूँगा पर कुछ लोगो के लिए हेल्पफुल हो की आप
Party Name को भी एक अलग sheet से link कर के Pick करा कर समझा दें जिससे की बार बार Address और GSTIN Automatic आ जाये और गलती के Chance भी कम हो जाये
Very Very thankful for your Detailed Explained Video
Okay g
Deepak sir Pankaj ji ne jo bola hai uska video kB published kroge ???
YOU CAN ALSO DO THIS USING VLOOKUP FORMULA SIR
Sir, u r genius,,hands up for Ur information
Deepak Ji, Namaste, It is very very nice & important training given by you, I already prepare a bill format in excel,but that time I could`nt understand how to save it or backup it, now I learn it from you,Thanks ,God bless you & fulfill all your dreams true.Can we make it for large data of various types of stock item & there sizes,like as inventory register,please help,
Very very informative and use full video given by you. Deepak sir kya aap video bana sakte hai..?
Jisme party ka name,bill amount,gst detail type karte hi automatic bill me save ho jaye
Jaise jaise table me details fill karege new bill generate hoga and save bhi kar paye
Truly great , best tutorial videos
😊
Great job sir, You are great teacher......thank you
very nice and very usefull video deepak sir, isi tarah excel formet main bhi save karna bata dete.
Ok g i will publish another video on this topic as soon as possible
ok thank you
wonderful demo very useful thank you bro
Save to pdf is one of the best trick. How to save in excel using same function.
I use RapidBooks to create PDF Invoice
great work...thank you for your tutorials I am learning a lot from you
Your videos super excellent
Very helpful.... Keep going👍👍👍👌
A brilliant idea thank you so much 100% Working Sir! ❤️
Ap bohota achhe sikhate hai
Sir, You r doing great job. Sir it is my earnest request to you please make some videos on Macro Coding from basic to advance with every description. Thank u so much
Ok g.. I wjll publish vba macro full course shortly
Very useful video for beginners.
Deepakji. My sincere thanks to you from my bottom of my heart. request you to guide me how to create buttons "Print", "go to previous invoice" in the excel sheet
I m researching for proper perfet invoice with database... I ll publish video as well as possible 👍👍 👍
thank you sir bahut kuchh maine apke video se sikha hai ab ap yeh bataye jab koi bill mai banau to net pay total kisi sell me jakar ruke average aur profit sab kisi sell me jakar ruke aur jo item mai sale karun oh stock se automatic cut jaye yani kam ho jaye take end par jab closing karun to mujhe pata chale aj ka sale kitna hai profit kitna hai aur ek aisa button vi ho Clears all items us par jaise click karun ganad total profit average sab cleare ho jaye next day ke liye bahut meharbani hogi fir jakar complete software hoga sir
Hi Deepak, your excel videos are amazing. i just want to know how i can backup of customer wise detail and how i can retrive data in excel.
Thanks a lot, it works for me, can you please also tell me
1) How can i save 3 copies like original,duplicate and triplicate files.
2)Also want to save file as customername+invoicenumber
+srinivas M ok i will publish PART 4 of this invoice as soon as possible
Very Good Bro... I like that... Thanks a lot..
Thank you for your very good video. Request you to upload a video regarding "Automatically Update Inventory while Creating Invoice"
Ys.. I will publish video shortly
very useful and helpful 🙏🙏🙏
Sir please give us complete solution as soon as possible that will be very helpful for us
G..
THANKS FOR THE WONDERFUL TEACHING. PLEASE SHOW STEPS TO CREATE THE BUYER'S LIST WITH ADDRESS AND GST NO.
thank you for the video its very helpful
very useful video sir than so much
Very nice vedio. Thnks bro
Very Useful tutorial
Acha he video ....vande mateam
Great job..
Thanks you so much 💖
sir aapki training file dekh kar hi type kiya tha
Problem solve hui???
@@DeepakEduWorld office 10 nahi mil raha
i am trying to creat receipt form. so i need this PDF OPTION. MOBILE 7834838981
Great Sir Ji
really ye bahot superb hai lekin jaise apne pdf me save karna bataya vaise hi kya print bhi kar sakte hai kya agar possible hai to print karna bhi sikhaiye
+Pankhil Shah ys we can print... I will publish PART 4 of this invoice as soon as possible
Sir you are great
😊
Nice one 👍 deepak ji but is me party details ka bhi kuch advance feature banana sikiya ga jaise party name select kare to us ka address gst no automatic select ho jaye
Ys.. I will publish another advanced video on this topic
Lovely sir, may Allah give u all u want my prayers with u always, sir one little request plz plz plz plz je sa ap ye invoice banaya he aor sikhaya sir plz plz 1 aor hum pe ehsan karen k isee invoice ki tarh excel mn pos invoice banana sikhao plz plz plz
Hello sir your page is a awesome information but please make a video for invoice in which there is recepient copy, transport copy , seller copy and data will be save as seller copy!!
Ok... I will publish video as soon as possible
Very useful video
Very nice bro..I already subscribed
🥰
nice expalnation of invoice
great job sir
Great work keep it up. I have one question jah aik invoice save hogayi phir uske baad next new invoice kese hogi?? Plz iska bta dain
Thank you sir very much .I made automatic invoice by watching your video and also save in pdf file .but there is one problem when I click on data validation it will not go on the other sheet.But thank you sir very much...
Hello
Thank u very much for such productive uploads. I have all these steps and made invoice and saved it as well. I have one issue if u can help please. I want that after saving the invoice it should update the inventory list means to subtract the stock so i should what remains how much. Waiting for yr reply.
I saw some videos but can not understand from them like urs.
Please tell me how it will be possible. There r videos available but i can not understand them. Ur way of teaching i understand very well and fast. Waiting
Thanks Deepak, good tutorial.
Would you please make another tutorial if any invoice required edit or corrections.
Thanks in advance.
Ya sure.. Please wait.. I will publish
Please also make a video on "retail products invetory" which auto reflects after adding and subtracting products after daily sale and purchase. If you have already then please share the link.
Thanks in advance.
I always follow ur vdo .. bro .. hum kese barcode bana sajte hen invoice pe .. aur product pe
Pls help
Here is the solution for all of those who had issues with EXCEL 2013
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Oliver\Desktop\HOJAS DE RUTA\" & ActiveSheet.Range("G8").Value, openafterpublish:=True
Took me a while to figured it out xD
How to get opening balance from the closing balance of another table automatically. Pls answer. Big fan of yours.
Plz answer
Nice data 🎉
very nice video i like it thanks
Very Good video
HELLO BROTHER. AS USUAL A VERY INFORMATIVE VIDEO. ALL DONE VERY SUCCESSFULLY EXCEPT 1 THING. I APPLIED SUM FORMULAS AGAINST THE DATA AS"PREVIOUS BALANCE, INSTALMENT RECEIVED, FRESH BALANCE,". WHEN I CLICK NEW INVOICE, PREVIOUS DATA ALONGWITH FORMULAS ALSO DELETED. I HAVE TO INSERT SUM FORMULA AGAIN AND AGAIN. PLEASE HELP
Sir aapka jo automatic invoice ka video tha that was very good. I made it for my father. But I'm in kota preparing for JEE. And some times he needs help because he is not expert in computer. And I want to purchase macbook air for me. So what I want to know is that the Invoice made on windows pc can it be edited on macbook too. So that I cn send him back through gmail after making correction in the formula
Will it work on windows after editing/correcting formula errors in mac os Sierra
This tutorial is very helpful. I complied all 3 parts and it's working very nice. JUST FACING ONE ISSUE... ITS NOT SAVING LOGO(PICTURE) IN PDF...
ANY UPDATE IN SCRIPT REQUIERED
can u pls help me how to finish part 3 ? or u can send me that excel sheet to my email id - kdrverma@yahoo.co.in which you had made
pls let me know ur what,up no
U can download.. Link is given in description
Thanks for nice tutorial
🤗
Very nice Bhai... ☺☺
Deepak Bhai Aapka whatsapp Number mill skta.. ?
Thanks for suggestions Sir
Sir,
Very interesting. Video. AlSo knowledge ful.
Can we Edit saved invoice by calling back to invoice template.?
If yes,
Please send me the VBA code for Edit Invoice Button.
Also can save edited invoice to Save data Sheet.
Please send VBA Sir.
Thanks for these all videos . But how to manage inventory data ?
Dear Sir, Make a video on Purchase entry, Sales entry & Stack maintaince in Excel
Bhut khoob wao
Hello you are really great, thank you for your videos
I just want to ask can we save invoice with 2 different cell together e.g. invoice number along with party name in different 2 cell please guide