INVOICE PART 2 - How To Automatically Save Invoice Entries For Future Reference in Excel | HINDI

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@altafhusainansari4282]

Hello Deepak Sir, Ye wala Form MS Office 2007 Me Kam Nahi Karta hai kiya. Q k mene Office 2019 me Mera ye pura Kam Karta hai.. Par 07 me Nahi Karta hai Save ka Button Error AA jata hai

[@asifiqbal5594]

Assalam o Alaikum Deepak Bahi I am from Pakistan to learn a lot from your videos brother how can we amend saved invoices

[@altafhusainansari4282]

Ap ne jo Is ka part 3 Diya tha woh Puri achhi tarah se kam kar raha hai

[@mansoorahmad1400]

Sir ji, How to transfer and save product data from an invoice, if I have multiple products on a single invoice.

[@muhammadshahbaz7294]

Your are very very expert in excel bro Weldon

[@SunilKumar-rk9os]

thanks Sir, very useful video hai jiska mujhe kafi samasy se intzar tha, lekin isme hum chahte hai ki jo item qty hum invoice me dalte hai us item ki qty humare stock wale sheet item list se minus ho jaye invoice save karne ke baad,

[@DeepakEduWorld]

+Sunil Kumar okay.. You will learn it in PART 3 of this invoice

[@deepakdesai7093]

sir mere project me parobalem ari hi kuchto apka contact no mo dona mera mo 7874896352 ya contact me

[@deepakdesai7093]

sir sab kam karta hi magar aki renga me sev hota hi age ni hota

[@rashedchowdhury1467]

You are a boss person. Thanks a lot - Rashed from Bangladesh

[@ashishnegi2986]

Sir apke sari a to z video hai mere pass excels ki thnx sir bhut help ki apne thnx again😊😊☺

[@belaalhayajneh4796]

Hi ser After saving invoice as pdf, how can I make a hyperlink for this copy to the same invoice # in registration data in excel sheet. Thanks

[@ashishnegi2986]

Sir apka smjane ka tarika bhut acha hai thnx sir😊😊😊

[@MohitKumar-jv6nu]

Sir can u pls tell me that how to make monthly information contained in the save list of the particular name of the company

[@fahadabdullah510]

love you so much sir, made this invoice data for my father shop today because of your help

[@vinodkumar-uo5lx]

You're showing only one line entry per invoice,but if I entered more line in invoice how to record for that

[@abhilashpampady]

Thank u deepak..... your way of teaching is awesome....

[@nagwanshi884]

सर् जी आप ने जो फार्मूला बताये वाह बहुत काम का है पर मेरे से शीट को बंद करने के बाद पुनः शीट को ओपन करने पर माइको काम नही करता शीट को सेव करने से माइक्रो इनेबल वर्क बुक पर करके सेव् करता हु इस के कोई समाधान बताये

[@prashantmadavi]

. x

[@arshadkhichi806]

Your videos are very helpful to me....thanks deepak😍

[@gameplayandreview]

How to add *Print* Under Button under *Save Invoice Data* Button

[@prasadyende7968]

THANK U SO MUCH THIS VIDEO IS VERY USE FULL TO ME ONCE AGAIN THANK U SO MUCH

[@ssyed8324]

Deepak how to have details invoice saved in Excel data

[@irfanahmadmomin7543]

sir yeh to aap ne bataya bahut use full hai . aap yeh bhi bata dein ki agar duplicate invoice banana ho to woh kaise karenge.

[@dabnaryanmanna949]

Topmost video , khub sahajje sikhte parlam

[@salilpattanayak7726]

Excelent logic, Thank u sir It will help to all Excel User

[@swadindiana3308]

very good video most useful for small scale traders

[@harryvala36]

Bhai tu bahot achha kam kar rha he......

[@DeepakEduWorld]

😊

[@Ayouthwithtruth001]

Thank you so much brother for making this video for us

[@gsincubatormaharashtra3967]

Sir thanks for giving very useful tips in excel

[@johnsahayaraj5803]

VERY SIMPLE EXPLANATION TO UNDERSTAND GURU JI

[@DeepakEduWorld]

😊

[@rajeshshah6758]

Thank you Sir. Your videos are very simple and easy to learn

[@MrVeereshr]

Hi Deepak,You are creating an awareness to the people how to resolve the issues without help of software developer. I am the one among them. Thanks a lot for educating the people on "Microsoft Excel" materials.The video "INVOICE PART 2 - How To Automatically Save Invoice Entries For Future Reference in Excel | HINDI" is very useful for me and I need some more help from you. I hope you will help me to resolve the issue.In the above said video invoice data from one invoice has been saved to new worksheet using macro. However I need the data month wise. How to write a macro which creates new worksheet on 1st day of every month and automatically saves the date till that month end.Thanks and all the very best for your work.

[@chandansingh7217]

Thank you so much sir.... your video is very much useful..... salute to your work...

[@arifanazia4491]

U r now my excel guru

[@vickybadshah8962]

Very good sir 👍

[@khalidhashmi99]

This is the most valuable channel subscribed by me till date

[@DeepakEduWorld]

😊

[@chittepuprasadareddy5314]

Dear Sir, thank you very much for your informative and very useful lectures.

[@wallstohomeinteriors1947]

Very nice , simple and detailed video. Helped me alot. Thanks alot buddy

[@bidyadharrabha4033]

Bolne ke liye kuch nahi he👍👍👍👍

[@DeepakEduWorld]

😁

[@azizmohammed4616]

Thank you Sir your reply Sir your very helpful person thanks again

[@daminiarora9078]

Thanku so much you are so intelligent and we learn lots of things from you

[@DeepakEduWorld]

😊😊

[@subbiahrajendran933]

Very hardworking tutor you are. I am from Chennai, your teaching is like spoon feeding a baby. Well done deepak. Though I am a beginner I fully understood your project 👍Bhahut accha.

[@DeepakEduWorld]

Thanks g 😊

[@kalpeshfaldu]

thanks learned the trick worked perfectly for me

[@mitthukumar6291]

Heartily thanks "DEEPAK SIR"

[@GardejiInformation]

Thanks deepak bhai

[@shreemotortrainingschool5794]

THANK YOU SIR ! very useful video. i done my receipt and backup data.

[@devanandsingh5932]

You are great sir for automatically GST invoice aap Mahan ho sir

[@DeepakEduWorld]

😎😎😍😍😍😍

[@mitthukumar6291]

You're each videos very helpful..

[@mitthukumar6291]

Wow...sir you are very talented

[@raselsheikh9982]

Dear Mr. Deepak Dada Your explanation is awessome. I am searching a videos like this. Everything is clear to me. But I have a question about this topic. I want to transfer all information with product, sothat I can view total invoice based on invoice no. So waiting for your tips..........(From BD)🥰

[@saishekharkommawar8016]

Wow sir it’s amazing I done its working we have small scale clothing wholesale distribution We can’t effort to expend for software and same time facing problem for billing Now no issue for billing it’s perfect Sir please provide inventory management also Closing stock inward and outward, closing balance in excel 😋😋

[@DeepakEduWorld]

G

[@VikramBhatilovekodial]

Investing on a ERP software like Tally is not expense but an asset. In GST you need a good software to maintain accounts and also raise various reports. Also your GST returns need to be error free too. Excel is nowhere in comparison to Tally. Yes you need to spend 18000/- initially but its worth it.

[@khkhilji]

दीपक जी, आपका सिखाने का तरीका बहुत ही अच्छा है,excel में काम करना मुझ जैसो का काम आपने बहुत आसान कर दिया है।excel की बहुत सी बातें में आपके video देख कर ही सीख पाया हूँ।इसके लिए आपका बहुत आभारी हूँ।उम्मीद है कि आप इसी तरह मुझ जैसो का मार्गदर्शक करते रहेंगे।दीपक जी जिस तरह आपने item list बनाई है उसी तरह customer list कैसे बनानी है ? Please बताए।धन्यवाद।

[@DeepakEduWorld]

+kayum husain khilji just save ur customers name on different sheet.. And create dropdown list in ur invoice.. As item list...

[@md.aurangjebalam1513]

I did already but my macro records is overwriting in second line again and again.

[@rajasahoo6039]

Thinking level ko manna padega 🙏

[@bahi871]

Its very very useful, .....Thank youuuuuuu

[@magbulmansuri4636]

very nicely teached

[@narayannayak7242]

Excellant information.

[@ashishnegi2986]

Apki sari video hai mere pass

[@mdshaad2713]

जबर्दस्त

[@chandanarya1784]

VERY USEFUL THANKS

[@rajaykumar6118]

U are genius bro.

[@khalidelectricals]

Hi Friend it is Vary supportive video Thank you much.New invoice button se, invoice number increment ke sath date bhi update ho

[@আপনাকেবলছি]

Bro, Ready made file mujhe chahiye. De dona dada. Bangladesh che bol raha hu. [e-mail]

[@dipeshsharma2002]

Very Very Good

[@aliasghar292]

Deepak Sir, aap ney invoice key data transfer ko bohat achai sey explain kiya... its very nice or mujey samaj mey bi bohat achai sey agaya... per mujey ye INVOICE FORMULA key saath banana samaj ni hey... plz ye invoice aap ney kis formulas ki madad se banae hey wo bata dey.plzzzz...

[@DeepakEduWorld]

Ok g i will publish another video on this topic as soon as possible

[@mohammadaslam5218]

Thank you sir, nice video, i would like to ask one thing , in this video only one record is saving through save invoice data button suppose we would like to save more than two or three records then how ? please give me the solution

[@chandrakantmirkale4901]

Ek No. Bhai

[@Chinnurockbells]

really wonderful

[@naveeedasif786]

great work dear. thumbs up . best of luck

[@DeepakEduWorld]

+Naveed Asif thanks

[@AjayYadav-mj7ge]

thank you so much very usefull video you greate sir

[@sagaedxd6091]

Nice Bhai Jaan Veery Good

[@akramansari5317]

Invoice 1st video you explain the proforma of invoice and formulas also but you should also tell about it's properties of page set up because the invoice is make for print when I used to print it not used to come limited properties.

[@imranahmed1696]

Bhai thank you very much for this concept It worked perfectly

[@ashutoshkalamkar]

Hi. Nice information. Thanks. Pls. Post video for the same to prepare invoice from two different machines but data will be saved collectively with series of invoice no

[@amitmalekar6265]

sir Kya hum isme discount dal sakte hai cloth shop ke liye hur product pe alag alag discount hay aur discount de ke usme GST add kar sakte hay kya

[@vikaskumar-wr3bz]

Deepak Sir, i request you to please make videos on Macro and VBA in detail. I wish to gian detailed knowledge about Macro and VBA. Please....................... everything in details.

[@DeepakEduWorld]

+vikas kumar ok

[@naeemanjum136]

Hello king of Excel, Mr. Deepak Your work on excel is very good and helpful. I am store keeper in Ksa. I just want to know I made voucher and how to auto save products it's code and quantity with voucher number, date, branch code from voucher to next sheet. I no need prices.

[@jainshubham3366]

Thanks sir Ye automatic invoice par bahot badiya videos banaye hai aapne. Very helpful hai ye video. But ek problem hai. Printing time par jo bhi row and column blank hai use remove karke gross amount and net amount upper kaise laye?

[@DeepakEduWorld]

Usk liye macro use karna padega...

[@jainshubham3366]

@@DeepakEduWorld sir iske liye aapne koi video banaya hai?

[@saurabhdas7724]

Thank you very much sir !

[@DeepakEduWorld]

😊

[@padayanilesh3911]

sir, apke is channel se muje bahut kuch sikhne ko milata he. muje ek apka help chahiye he. Mene Automatic Billing ho jaye esa apse sikhke ek sheet banaya he uske mene item master creat kiya he or prices diye he. abhi mere pas retail customer bhi he or wholale me materil purhcase karne vale customer bhi he dono ke rate alag he. abhi invoice banata hu to generate rate aa jate he. to isme kuch esa ho sakta he ki me party ka name enter karu to item master me se usi party ka price invoice ke me show ho. matlab me ek bar customer vise item rate item master me enter kar du or jab invoice banao tab usi party ka rate show kare. pls help me in this metter and guide me as per your convince. Thank a lot.

[@renjithkumar8511]

Hai Deepak, Thank you very much for your efforts. Kindly make another video of automatically update stock based on invoice.

[@DeepakEduWorld]

Please watch part 3 of this video... Link is given in the description 🤗🤗 🤗

[@MohanKumar-ow9nx]

Thank you very much your quickly response. I Checked thoroughly, there is no enable macro option, And I am using office 7

[@DeepakEduWorld]

+Mohan Kumar okay.. Its too much batter to use 2010...

[@khalidalisubhanallah2947]

Bundle of Thanks Sir

[@pm-zi1xn]

Deepak ji very good vedio apne new data kase kiya or niche jo formula apne use o nehi dekhaye

[@DeepakEduWorld]

+p m Dear this is part 2 of this invoice... To know how to create this invoice step by step wirh all formulas... Please watch first part of this invoice.. Link is given in description of this video....

[@KDS-v6r]

very very much thank you

[@umarkhan4155]

Hi deepak sir very useful tutorial but pls explain how to manage or creat sales invoice summary every end of the day and take print out

[@DeepakEduWorld]

+Umar Khan i will also publish PART 4 & 5 of this invoice please wait for few daya

[@mazharhussain2404]

Save invoice and save backup ki coding ak module pe work kr Sakti hai k nai pls reply

[@naimahmad3806]

Help full many thank 2u

[@ferozkhan-lz5qw]

hi i am Feroz Khan i want to know how we can see this saved bill as well as preview is bill ko preview kaise karen jaise ye pahle tha pura bill details ke saath

[@shortStatus14366]

really gr8 I like it

[@gouravra3094]

excellent video sir plz tells us all format

[@frosi2009]

how to add each product with same invoice no.

[@urveshi]

Sir. kafi best video he, kafi achhi trah se apne bataya he, is ke liye thenk you so much, sir. agar koi Bill Cancel karna he to.? or agar koi old bill Name se search karna he to.? item ka sr no entry option, or item ko sr. no se search karke pata chal jaye ki kab Bill hua.? and agar aap koi link de jaha se ham apki banai hu xl sheets download kar sake to yeh best option hoga thank you sir, plz sir Reply me...

[@DeepakEduWorld]

Please wait for next invoice video..

[@md.helaluddin2915]

Thanks to reveal this tutorial

[@soulgroup4702]

Excellent bro

[@shaanentertainment857]

HiDeepak Ji, Pls.Reply Me Auto Save Data me ek hi row me data over right hota hai, aap ne jaise sikhaya tha vaise hi macro aur relative refrence use kar raha tha lekin wo 2nd wale pe hi data over right hota hai

[@DeepakEduWorld]

U have definitely missed some steps during recording macro.. Please retry

[@quickchargedistilledwater8294]

mr santanu ji sahi kah rahe he , same problem aa rahi he

[@simplydoing9596]

Yes ! i tried same problem here !

[@md.aurangjebalam1513]

Yes Sir many times i tried but still same problem again & again overwriting and in next row one first column Date column writing

[@simplydoing9596]

dekho , agr aap sahi video dekhna chahte he to mene Excel GST Invoice Part 1 se lekar Part 5 tak upload kr raha hu Meri Channel pr jayein aur dekhe EASILY Stock keeping bhi ! aur is problem ka solution abhi de raha hu 1. Pehle aap VBA code se ye pata lagyein ki Excel sheet ka LAST USED row konsa he?. need code see my channel video 2. Next Add 1 to this. 3. Next Copy all invoice data to VBA variable strings, numbers etc. 4. worksheets("sales register").Range("A"&lastusedrow+1)= Billno ..... sales register= sheet where our new invocie data save Billno is a VBA variable which is String type COmplete code va sahi tarike ke liye Watch my Channel video !

[@sanjeevtripathi6659]

deepak sir u r great but sir this bill purchaser and consignee bhi add karo apne sirf customer hi add kar rakha hai is me aap purchase and consignee colom bhi add karo jise bill to ship concept bhi aa sake

[@DeepakEduWorld]

+Sanjeev Tripathi ok g

[@gursewaksingh9917]

Deepak sir aisa ho skta hai ki agar hum customer ka number dale ya invoice number daale to uska old bill open ho jaye ? Reply krna pls

[@indrajeetkumar-zm8yq]

thanks Sir, very useful video hai jiska mujhe काफी समय से इन्तजार था लेकिन सर अगर हमें Invoice की शीट में इनवॉइस पुराना नंबर दुबारा वापस लाना तो कैसे लायें

[@DeepakEduWorld]

+indrajeet74081 kumar please wait for PART 3 of this invoice... PUBLISHING 14th of feb

[@sjasimasif]

Hello sir Very useful video. 1. question is how can we disable the colums after give formulas so no body can make changes 2. question is. All ready we mention any item price in item sheet if we change the price in Invoic sheet it will calculate or not 3. Question in save Invoice it shows only customer details and amount how can we get complete details with items and If customer ask for old Bill print with old date how we print Thanks sir

[@surajpintoodewangan9510]

Thanks you So Much Sir

[@MohanKumar-ow9nx]

Deepak ji, Very Good video for learners. Anybody can easily learn excel from your videos. Thank you very much. I have a question regarding converting numbers to text (amount) I followed your instruction to convert numbers to text and I succeeded. But once I closed the file saving in excel macro enabled format. The next time if I open that file number to text is not working. Please help me. Thank you once again.

[@DeepakEduWorld]

Okay.. When you open this excel file... U will see a ENABLE MACRO option just below the ribbon.. Please check out... And let me know... Ur problem is solved or not

[@MuhammadRauf786]

Deepak bro. First of all i thankful to you, your way of teaching is amazing. i have two questions 1. Please eleborate state sale and interstate sale? 2. I have created file according to your instructions but when I saved it and open a new file then and open one of item, other column filled according to the formula but Rate Column remained blank, so please guide what is the reason behind this.

[@somnathmajumder9732]

Thank you very much your quickly response. I Checked thoroughly, there is no enable macro option,

[@kapilamatya7453]

Hello sir nice tutorial one question why the pdf save code is not working in 2007 excel pls give answer thanks

[@sanjaysharma6028]

you nicely told transfer from Invoice to sheet row.Please tell how transfer data from row to invoice.?Thanks