Learn How To Create This Amazing Excel Invoice While I Build It From Scratch [Full Training]

[@ExcelForFreelancers]

📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

[@connief2679]

What a fantastic training!! Between this training and the VBA for Beginners series, I finally finished my first invoice! It looks great! Thank you also for the support from the Facebook Group! 😄😄 I'm ready to learn UserForms next!! Thank you, Randy. A million blessings!!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Connie. I am so glad we could help and Congrats on your first invoice. Very well done.

[@ambienceprofessional5804]

thanks a lot. i have a construction company that gives me a headache on paper works everyday. thank you for this.

[@ExcelForFreelancers]

For sure, you are very welcome. I am happy to help and share.

[@fionathomas6717]

Thank you so much for all your hard work. You make learning Excel easy. Can you make more from scratch videos. Or videos where you breakdown the functions and formulas. I'm still struggling to understand it all. Thank you again for all you do.

[@ExcelForFreelancers]

Thank you Fiona, yes I will try. That seems to be the popular opinion so I am going to do my best on this. Much appreciated.

[@fanfan6719]

applauses for, brillant pronunciation,, content, n flying directly to the results, u got the navy salute.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@cyrillmichaelambe8884]

Randy thank you for this classes online I have learned a lot from your videos.

[@ExcelForFreelancers]

You are very welcome Cyrill

[@cyrillmichaelambe8884]

Just from those videos I discovered that I still have a lot to learn to increase my skill.

[@ExcelForFreelancers]

I am happy I can help. Thank you for your Likes, Shares & Comments. It really helps.

[@rubyscupoftea9420]

THank you so much for this very informative video, i always replay your videos because i am currently working on something and i find your videos very helpful for someone like me. i am interested with all your videos thanks for sharing your knowledge god bless you

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@chandaatanu]

Hi Randy, Your video tutorial was excellent and was very simple to understand. I am building an Accounts Payable module on the MS Excel platform purely customised for my own workplace & this has really inspired me. Keep up the good work 👍.

[@ExcelForFreelancers]

That is really great to hear i am so happy you enjoyed the lesson and it will help you moving forward in your own application. Thanks again.

[@instapostercreations2875]

I can get the dynamic range formulae to work, been try for 3 hours now with no luck...what amazes me is I copied exactly what you did there

[@ExcelForFreelancers]

Hi and thanks for your comment. Sorry you are having issues can you share the formula or post your screenshots in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@yourhaven5403]

I am grateful to have come across your channel. Great work!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Cha

[@minalharsh3698]

Great video! 2 suggestions on possible bugs - 1. Message Box displayed even when correct invoice # is entered on new invoice (maybe because inv. row is empty) 2. During Save/Update removing items does not work, only adding new items functionality is built in

[@ExcelForFreelancers]

HI and thanks so much. I have a lot of those features added in my newest Invoice training here: kzbin.info/www/bejne/pKrNnGqVf5yUlaM

[@grisrtcantas4484]

Hi I solved the first issue which you mentioned by dupplicating the same Invoice_Load () (Copy Paste as Invoice_Load2() ) at the bottom and then: deleting this Part "MsgBox "Please select a correct Invoice #"" and "End IF", then replacing the " Invoice_Load " in the last row of VBA editor Sheet1 (invoice) with the new one : " Invoice_Load2" probably there are better ways to do it, but it works. For your Second issue i don't have a answer, i am just deleting the entry manuelly ,so it is't that big deal for me :D

[@terrig5704]

Randy you are a genius! I know so little about excel. I learn as I go so your video is amazing. I have created my own invoice but your invoice with the customer dropdown box is amazing. I'm just so bad at this that I cannot even add rows at the top to make space to fit my business details without getting an debug error. Your invoice only have the customer and I don't know if I can nicely space it in the merged cell with the invoice heading. Any help for a clueless will be much appreciated. Thank you.

[@ExcelForFreelancers]

Hi Terri, thanks so much editing and customizing this does require a good deal of VBA knowledge I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ If you run into a specific issue that you cannot solve please feel free to post screenshots of the issue, along with the details, in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@terrig5704]

@@ExcelForFreelancers thank you very much Randy for offering more help and support but unfortunately I do not have facebook. Thanks for taking the time to respond. I really appreciate it.

[@terrig5704]

@@ExcelForFreelancers Hi Randy I want to add a customer dropdown list like yours on my invoice but when I try like you did at timestamp 14:26 i get errors. I think it is when I try to select the customers when I type in the "offset" part like you did to add the "=Customer_Name". How do you select? What do you mean by "tab out" and "tab back in"?

[@ExcelForFreelancers]

HI and thanks for your comment. The only form of help and support we have at this time is the Facebook group. Many of our members have created a facebook account just to join the group. Thanks for your understanding

[@ryanng328]

Thank you for your effort, love from Malaysia

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help. You may also like my new one, also from scratch, called Invoice With Profit here: kzbin.info/www/bejne/g6Okd3Z_a6-SiMU

[@duskobogos2348]

He says: 'Its ALL kind of confusing !!'.....wow wow! a shocker. Honestly, I miss my 80's & 90's... I loved my pen and pencil...what a hassle this is!! Wot Wot? Now I understand, listening to this guy... that Yes.. the humanity is up to ..it.

[@ExcelForFreelancers]

Thank you for your Likes, Shares & Comments. It really helps.

[@sanjeebananda]

Thank you so very much. Amazing teaching. I learnt a lot today....

[@ExcelForFreelancers]

For sure, you are very welcome Sanjeev. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

[@ianblake9243]

Hi all, Thank you all for the opportunity to learn and be able to produce a worthwhile product. I am a 73 year old and have only taken up Excel in the last 15 months to stimulate the brain and fulfill my fascination with VBA. I have made and converted Randy's invoice to a service invoice for my son who is a fiberglass caravan and motor home repairer. I have the invoice up and running with a number of extra requirements in the sales: Insurance - Customer area. My question to you is: To keep invoice rows contained to the least number required for a given quote/invoice, is it possible to add a VBA formula that can automatically increase rows and formulas as required and then when the invoice is saved revert back to the original size invoice. I have managed to insert a manual solution with a button but if there is a solution to my request can you advise me where I may find such information. Many thanks to you all

[@ExcelForFreelancers]

Hi Ian, thanks so much. I really appreciate your comments. It is a great question for sure. What you can do is create a Shape-based, floating footer, which will be positioned based on the last row of content. This is what I have done for the Invoice that I am designing in the Accounting Application in our Mentorship program. You can find a picture of that Invoice sample here: www.dropbox.com/s/cu61b33iq4rxk1n/Invoice_SS.jpg?dl=0 More information on our Mentorship Program here: bit.ly/MentorProgram_YTComment I hope this helps and thanks so much

[@ianblake9243]

@@ExcelForFreelancers Thank you for your reply, I look forward to seeing your application of the floating footer and trying to use it in my invoice. Meanwhile I will keep on learning more VBA to satisfy my fascination with Excel

[@ExcelForFreelancers]

Thanks so much Ian. :)

[@deepakbhanushali1]

what a macro hours of work completed in min Sir wonderful , Sir I want to sort all the invoicelist with itemrow that to customerwise and create a pdf for that full year

[@ExcelForFreelancers]

HI and thanks so much. Can you post more details in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@joemanflyer2001]

Nice invoice setup !!

[@ExcelForFreelancers]

Thank you Joe, I am glad I could help

[@ma7moudabaza638]

thanks a lot Mr.randy for your useful lesson

[@ExcelForFreelancers]

You are very welcome, and I am happy I could help

[@ChillSheiakh]

well done, very good training. God bless you

[@ExcelForFreelancers]

For sure, you are very welcome Mohammad

[@harveyblackwood3563]

Thank you for this tutorial. I did an invoice template in MS Access for my school project and I based it from this tutorial. 🥂

[@ExcelForFreelancers]

Hi Harvey thanks so much for your comment. Really happy to hear that. Very well done.

[@aftabalamkhan7290]

Thanks alot for this amazing tutorial videos. You are excellent. I have no words to praise you. I have one question - In the invoice, an item will be displayed more then one time if same item is sold in quantity more than one. If 3 pcs of a shirt is sold, it is displayed three times in the invoice instead of one time with quantity 3.

[@ExcelForFreelancers]

HI and thanks. Yes you can automatically total items if you like. I show you how to do that in this video kzbin.info/www/bejne/iZPNc5qnr8d0adk I hope this helps and thanks so much.

[@sarasilva8744]

Amazing! I followed your tutorial and everything worked! I even learned new ways to implement code and how flexible vba can be. I am glad I found your videos while browsing new things to try out! Keep up the good work!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Sara

[@atingodiong197]

very good by show how to add new customer detail and new item

[@ExcelForFreelancers]

For sure, you are welcome. Thank you for your Likes, Shares & Comments. It really helps.

[@TheLegend_lab]

Dear Randy, Majority of video's i have watched so far are more in financials, invoices, and inventories management and they are super great. Can you perhaps, also create the user form database that has got futures like hiding excel after login and show only big rectangle userform, should have with admin status that allows admin to provide new user access to certain information, searchable bar to search for specific employee, hilight raw of data when select employee in database, unable to create a duplicate employees profile due to same employee number, full name, and date of birth, remove inactive raw data of employee by selecting end date eg. Just like when an employee is inactive they should get removed from active list and automatically gets updated in the inactive sheet database and additional column gets added showing inactive, user form should also be able to add new staff, edit, delete entry, dependent dropdownlist, autofill back certain information when selecting employee. That will be brilliance 😊

[@ExcelForFreelancers]

Hi and thanks very much for your suggestions. These would be features for a customized application for a single purpose. You may want to take my Employee Manager training and customize it based on your requirements. With that said I do have a training coming out that is based entirely on a userform here: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.

[@عائلةالوزيرى]

Thank you so much for all your hard work. You make learning Excel easy. but how i get back the previous invoice when i want to print it again for the client or to make any update on it or else

[@ExcelForFreelancers]

Hi and thanks so much. You can add Previous and Next buttons. I show you how to do that in this training: kzbin.info/www/bejne/lZPSpYGaoLetsM0 I hope this helps and thanks so much.

[@malakismani]

Hello, I love your videos and find them extremely helpful. One question I have is, when I open VB, I try and change the module from “general” to “worksheet” but for some reason the “worksheet” option does not pop up. I tried to still do the code but it won’t work. What do I do? Thank you

[@ExcelForFreelancers]

Hi thanks so much for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.

[@Snowdrift0638]

I'm having this same problem. I just requested to join the group, hopefully there was a resolution to this problem.

[@awildalpz]

Hello. God bless you. Thank you for offering this video. It’s detailed and what I’d want to have. However, I got stuck with adding Address 1 and 2. It doesn’t show. I’ve checked repeatedly if I miss something in the coding but I didn’t. So, do you offer services to create this and if so, how much?

[@ExcelForFreelancers]

Hi and thanks so much. If you have just a single issue, you can post that issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. If you would to create a custom solution, there is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? [e-mail] Thanks so much.

[@BB-bs7hm]

Is this invoice system associated with barcode field... to make it work easier with barcode scanner.... do you work in the future with MS access or only with excel..... to be honest with you. ... you exceptional and your ideas is different... top notch Mister Randy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that. You an add any bar code to any field simply by changing the font to a bar code font. This way the Invoice # can be changed to a bar code. I exclusively work with Excel only. Thank you for your Likes, Shares & Comments. It really helps.

[@saulcampos4404]

Hi Randy can you start adding a small part at the beginning where you show the finished product's functionalities. I find myself having to scroll through the video to see if certain methods are included

[@ExcelForFreelancers]

HI Saul, thanks for your comment. I do that mostly now with my newer videos, where I use a sample workbook to show all the features, before closing it and working on a blank one. Make sure to check out the POS With Inventory video launching in 14 hours right here: kzbin.info/www/bejne/iZPNc5qnr8d0adk

[@chrisfotoglidis437]

Very intersting. Nice Work.

[@ExcelForFreelancers]

Thank you very much. I do appreciate that Chris

[@chanmonanrie6898]

Thank you so much for your prompt responses to my previous questions - you guys were able to fix my problems with the INVOICE. However, I'm now having trouble making show up the DESCRIPTION, QTY, PRICE on the INVOICE whenever I click the ITEM (they did show up before), these strings no longer show up. What should I do?

[@ExcelForFreelancers]

Hi and thanks make sure that the Invoice Load is set to False within VBA. Please download my sample and use that for comparison . I hope this helps and thanks so much.

[@AdeKaryadi]

Nice tutorial, thanks

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@wlondoner]

What an amazing totorial. Thanks so much for your time. I wonder if you have a another totorial that shows the invoice been paid. If paid, payment confirmation will be generated and ready to be emailed otherwise it will show payment overdue. I look forward to your reply. Many thanks again

[@ExcelForFreelancers]

Hi and thanks for the great suggestion. I am currently working on a School Manager series (here bit.ly/SchoolManagerSeries ) However when I finish that I would like to do an Automated Time Tracking & Billing application that would track time, billing & payments with a similar invoice. Please keep watching the videos and I will get this done soon. Thanks again.

[@wlondoner]

@@ExcelForFreelancers yesss i will definitely keep watching. i can re assure that you have another committed subscriber.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that.

[@shiningstars2573]

Hello sir thank u so much: Sir can I make a video on Excel that has the following features: 1.where we can make automatic invoice like above. 2.where items automatically deduct in stock sheet. 3. Where we will write hsn code of item and all the details of that item will automatically be showed. I mean to say that it must be like an application that comes on net.

[@ExcelForFreelancers]

Yes sure you can do all of that, No problem at all. IF you need help with this, feel free to request help in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@khidhirmohd5411]

Hi, Tq for the video, I've love and learned much through your training. But still need to figure out one thing, what is the formula for the Range combination eg: .Range("B" & MonthRow & ":H" & MonthRow).Value if the Item cells on your receipt are merged with other colums, let say B through F columns are merged in the formula above. Thanks in advance

[@ExcelForFreelancers]

Hi and thanks very much. When you have merged cells, you will want to use the upper left cell for formulas. When you are clearing merged cells you must use the upper left and the lower right. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@khidhirmohd5411]

@@ExcelForFreelancers sry what i meant was B through F -->Row not colums, are merged, my bad

[@ExcelForFreelancers]

Can you please post your detailed question, with screenshots, in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@fernandogonzalez571]

Simply Amaizing thank you for share your knowledge

[@ExcelForFreelancers]

Thank you very much. I do appreciate that.

[@rashida7777]

I am just in ann excel precursor class...OMG! I am terrified now!

[@ExcelForFreelancers]

HI and thanks so much for your comment. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@salesdepartment6867]

Thank you for your explanations. I would like to know if you have a special video with an excel file por quantity, gross weight, net weight, carton size, what we call packing list , thanks a lot, and have a nice day

[@ExcelForFreelancers]

Hi and thanks so much,. I do not have a video on this specific items however you can download this application using the link in the description and add these additional features.

[@wndmiles]

Wow! You really know your stuff! Unfortunately, I do not. I’m a beginner in an office where I need to learn how to do this. Your over my head here and moving way to quickly for me. Do you have beginner tutorials that can bring me up to speed?

[@ExcelForFreelancers]

Hi and thanks for your comment Wanda. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@wndmiles]

@@ExcelForFreelancers You really do care! You’re not one of those that puts info out there and then leave us dummies hanging. Thank you for your quick response! I will investigate the info you sent me. Thank you!

[@ExcelForFreelancers]

For sure, you are very welcome Wanda. Happy to help

[@maiphuc4225]

Nice work. Keep it up😊

[@ExcelForFreelancers]

Cam On Em :)

[@JamesWilliams-gx3rr]

Hi Randy, I stumbled on your video and it's amazing. I am half way through following along building this. I think I need help making the tool that I am envisioning though. Can you tell me what's the best way to find someone like you to develop a quoting tool/invoice tool that is customized to my needs? If you are interested, let me know. Thanks!

[@ExcelForFreelancers]

Hi James, thanks so much and glad you love the training. The best way would be to write up a detailed scope of your requirements then email them to me along with your budget. I can then forward it to a qualified developer. [e-mail] I hope this helps and thanks so much.

[@manibbt007]

hi sir thanks for your hard work to teach us. please give formula to add discount tab at different percentage. Thank you sir. God lees you

[@ExcelForFreelancers]

Hi and thanks, please see my updated POS training on how to add discounts here: kzbin.info/www/bejne/iZPNc5qnr8d0adk I hope this helps and thanks so much.

[@manibbt007]

@@ExcelForFreelancers Thanks a lot sir

[@shekhsadi]

it's very helpful-thank sir

[@ExcelForFreelancers]

For sure, you are very welcome Shekh

[@leighannmurdoch5804]

Love the video and thank you, but I have one question. My print port blew and I am waiting on the path. I am unable to run the program. Can you assist in fixing this problem till I get my part please.

[@ExcelForFreelancers]

Hi and thanks you will want to set your default printer to a different printer in your computer settings. I hope this helps and thanks so much.

[@geoffrosaliejackson9580]

Hi I have used this program to create invoices it is fantastic, I need save my invoices as PDF and then want to send the PDF attached to an email automatically can this be achieved??

[@ExcelForFreelancers]

HI and yes, it can, you can check out this video here: kzbin.info/www/bejne/lZPSpYGaoLetsM0 I also show you how to email this on my Patreon channel here: www.patreon.com/ExcelForFreelancers

[@ictassistant7529]

thanks so much for this tutorial. my only question is how do you add an option for print preview, so that you can see the how the printout is before printing?

[@ExcelForFreelancers]

Hi and thanks very much for your comment. You can add something like this: Worksheets("Sheet1").PrintPreview I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.

[@ictassistant7529]

@@ExcelForFreelancers thanks so much

[@ExcelForFreelancers]

For sure, you are very welcome

[@joshuakasase9625]

Wonderful work

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Joshua

[@uclevan1002]

Thank you so much . I'm from vietnam's fan

[@ExcelForFreelancers]

Cam On Em. I live in Da Nang. Nice to have you here.

[@surendramajeti9628]

Very nice explanation .please share this sample template 😊

[@ExcelForFreelancers]

Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.

[@johnballo2402]

What about not print it but send it to clients email. It would be cool. In by the way nice job sir and soon I will be purchasing that 100 workbook... and one more question sir... when I get it can I resell one of those applications... ? Thank you.

[@ExcelForFreelancers]

Hi John thanks so much and I am really glad you like it. In my Mentorship Program I am creating a comprehensive Invoice in which you can email, send, save as picture, pdf, or Excel as well as duplicated it and make recurring. It is also fully customizable. Feel free to join us here: bit.ly/MentorProgram_YTComment Concerning the resale of the applications, yes you are allowed to customize and resell the applications as you wish, however you will want to fully check for issues and customize them as well before putting them on the market.

[@mariiopara8680]

Hi John can I buy the template for the invoice app you discuss in the mentorship programme direct from you?

[@nextgene-motors2922]

This is so beautiful. Thanks Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome, I am happy to help.

[@nextgene-motors2922]

@@ExcelForFreelancers thank you sir... thank you for your valuable reply and time,,,

[@nextgene-motors2922]

@@ExcelForFreelancers sir i want to create a excel invoice for retail shop. Could you please share any link that have inventory stock also... That is very helpful for me...

[@ExcelForFreelancers]

This Invoice from scratch will work just fine for you, then you can add any features you want onto it. Thanks again.

[@BassamThebian]

Many thanks for this video, really great. one question though, when doing the dynamic list as you described it's still showing blank rows. any reason?? would very much appreciate your answer on this.

[@BassamThebian]

please note I have formulas in those rows, would that effect?? what can I do?

[@ExcelForFreelancers]

Hi and thanks very much if you have formulas in these rows, and they are returning nothing you can use a slightly different formula, something like =Offset(Sheet1!Range($A$1,,,50-Countblank(Sheet1!$A$1:$A$50),1) This will subtract the # of blank cells from the total cells in your range. Just update the Sheet names and ranges I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@BassamThebian]

Many thanks in deed. I will try it for sure.

[@BassamThebian]

Thank you, it worked perfectly.

[@ExcelForFreelancers]

Thats great to hear. I am glad it helped

[@mdkamruzzaman6398]

Thank you so much for your hard work. ❤️❤️❤️

[@ExcelForFreelancers]

For sure, you are very welcome. I appreciate that.

[@fsfu100]

great video as usual - i need an invoice format with the following: - individual product tax rate (uk VAT) - dynamic invoice length (not pre-determined ) - multi currency capability - product price bands according to customer type (wholesale, retail, or customer specific) can you help?

[@ExcelForFreelancers]

HI , thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? [e-mail] Thanks so much.

[@aminuddinbaharom]

Hi Randy, This is a great tutorial and helps us do better in our work. I have a question. How can I do that if I want to have a specific Invoice running number? let's say, instead of 1, I like the running number to be INV-001 as an example. Please help.

[@ExcelForFreelancers]

Hi and thanks so much for your suggestion. If you want a different type of invoice # you can use an extra column. One column to keep the numerical invoice # and another column to keep the alphanumeric Invoice #. On new Invoices you can use VBA to combine the text with #'s to create the desired Invoice #. I hope this helps and thanks so much.

[@yahyaramadhan2698]

Hi Randy What a perfect POS system you created from scratch. How else can you link it up with a stock system in the same worksheet. For example as I prepare the receipt, and change quantities, I would like it to reduce stocks and give me alerts when quantities are below minimum.

[@ExcelForFreelancers]

Hi and thanks so much for your comment. I am glad you liked the training. This automated Purchase Order may help you with that right here: kzbin.info/www/bejne/aXPVpJapetGhbc0 I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@JanBolhuis]

This is a great tutorial. Thank you very much.

[@ExcelForFreelancers]

For sure, you are very welcome Jan. I am happy to help and share. I have a brand new Invoice from scratch coming out next week which will include Installment payments. Thank you for your Likes, Shares & Comments. It really helps.

[@AmirSina]

Hi Randy, this tutorial is amazing. thank you for all your time and effort creating it and it's so generous of you, making them available for free. I have question: in the invoice it's been assumed that the customer database is already available. what if we start the customer list from scratch and adding them while we create the invoice. i.e. building up the customer list. how can we do that?

[@ExcelForFreelancers]

Hi that is a great question. I solve that issue in this training: kzbin.info/www/bejne/g6Okd3Z_a6-SiMU Also, another issue I will solve next week is: 'What if the invoice items create multiple pages?' I will create a new training video next week to solve that problem I hope this helps and thanks so much.

[@macman007747]

Another great lesson Randy, thanks!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Rob and always appreciate your help and support.

[@hydrogenperoxide4848]

This tutorial was amazing, I like your each video. I have taught a lot from your videos. I have a question about this invoice , hope you will help me. What if my invoice items exceed than the number of rows i have allotted to them..? How can we make that dynamic so that where my invoice items end, the subtotal and total automatically come under that.?

[@ExcelForFreelancers]

Hi and thanks for the great question. In my Mentorship Training I show you how to create a dynamic invoice with unlimited rows with a floating footer, where I am creating an entire accounting application including Inventory, Purchases, Dashboard, Multi-User sharing & sync and a ton more. You can learn more about the program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/

[@hydrogenperoxide4848]

Excel For Freelancers Thank you Randy☺️

[@tobayekaina8610]

Hi Randy thanks for sharing

[@ExcelForFreelancers]

For sure, you are very welcome Tobaye. I think you will enjoy this one as it starts with a blank Invoice. This is a far simpler Invoice template that what we are creating in the Accounting application, but its a great foundation to build on.

[@blancawilhelm7665]

Hi Randy, i would like to learn more about how to create a more templates, more about macros and formulas, can you training me? i created this invoice but something when wrong can you take a look of what i did?

[@ExcelForFreelancers]

Hi Blanca, Thanks so much for your comment. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@MrDinhoR]

Great Video.. Just one question. how to add a email button, so the invoice can be sent to customers email address (of Customers "Sheet5") instead of printing it>>>>

[@ExcelForFreelancers]

Hi and thanks so much. You can print it to PDF and then Attach it in an email. Next week (May 24th, I will have another Invoicing video that shows how to create a Multi-page invoice) In this video I will also show you how to email an Invoice. I hope this helps and thanks so much.

[@alfredreloj683]

Great video, Randy!

[@ExcelForFreelancers]

Glad you enjoyed it Alfred :)

[@tonydao1828]

Thank you for much for this tutorial. my only question is how do you do a quick search in the customer name?

[@ExcelForFreelancers]

HI Tony thanks so much. You can use an advanced filter to search for a partial name. I show you how in this video: kzbin.info/www/bejne/j6amo3iNipeHo5I

[@chanmonanrie6898]

Your video have been a great help to my small business. One thing I'd like to learn is how to change the INVOICE No. 1 in your video to my preferred INVOICE No. 210001. Would you show me how to do this?

[@ExcelForFreelancers]

Hi and thanks very much. We use the Max formula to generate the next Invoice #'. If you clear out any existing invoice data you can generate the next Invoice # for 210001 using this formula =Iferror(Max(InvNumb)+1,"210001") Just update the variable according to your named ranges for Invoices. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@yosef-yosef9414]

great video, very informative for all excel users. do you have a Video for VBA excel tutorial? i hope you'll gonna have

[@ExcelForFreelancers]

Hi thanks I have over 140 videos on my channel, many of which are intermediate. (The Channel 'Excel VBA is Fun' is a great channel that is a bit more basic. I hope this helps and thanks. I will usually cover more advanced VBA because there are already thousands of videos on VBA basic training my videos are often more advanced. Thank so much.

[@yosef-yosef9414]

@@ExcelForFreelancers Excel VBA is Fun

[@ExcelForFreelancers]

Yes it is and it is a great channel for sure. I am sure you will like it to learn the basics. Also WiseOwlTraining is a really great channel to learn the basics also.

[@sandilekhumalo5693]

i can't wait for a day where i will be as incredible as you with excel.

[@ExcelForFreelancers]

Thanks so much. For sure you will be. Keep up the great work.

[@munnamazi6115]

absolutely amazing

[@ExcelForFreelancers]

Thank you munna, Thank you for your Likes, Shares & Comments. It really helps.

[@medkari]

thanks Mr RANDY

[@ExcelForFreelancers]

For sure, you are very welcome Med

[@wymes1]

I tried this oder form. Works great. Only this is, you can't delete an invoice once it's created.

[@ExcelForFreelancers]

Hi and thanks so much, and glad you like it. You are welcome to add the delete feature and download my version. I often leave off components in order to challenges students to add them to increase their skills. Thank you for your Likes, Shares & Comments. It really helps.

[@wymes1]

@@ExcelForFreelancers thanks so much. I appreciate the challenge. As a novice, that barely understands the pseudo, i was scared to mess something up beyond recovery.

[@ExcelForFreelancers]

Thanks so much. Sometimes the best way to learn is to mess things up then try to fix them again. :)

[@varismashkuli6036]

Thanks Randy

[@ExcelForFreelancers]

For sure, you are very welcome Varis

[@ProHack_GR13]

Hi.. really cool, one question! It would be nice to only allow to print an invoice when it has been saved. This way you can't send out any invoice that was not saved. Any suggestion on how to fix that, i'm struggling on that.

[@ProHack_GR13]

And one more.. if you dont add any data to the invoice it stil saves it. It would be nice if it doesnt allow you to save the invoice when it is a blank invoice.

[@ExcelForFreelancers]

Yes sure, you can. Just check the cell that displays the row number of the invoice, if it is blank, that means the invoice has not been saved yet, and you can require the user to save it before printing. You can also check the last row of data, if it is the same as the header row, you can ask the user to add an item before saving the Invoice. I hope this helps and thanks so much.

[@upaliwijeratne8696]

This Invoice is very nice creation. I want to how can I restrict the entries in cells which are not meant for data entry please

[@ExcelForFreelancers]

Hi and thanks very much. You can go to the cell properties and make sure the cell is locked and then protect the sheet. I show you how to do this in this training: kzbin.info/www/bejne/hImxcmWrrqisgNE I hope this helps and thanks so much.

[@rayl1043]

Thanks, Sir, I need your help. I'm new to excel, but with the help of your video, I have created an auto repair invoice. When add a new customer and save the data the template close and the save one open. I have lost many invoices trying to write over a spare one. How do I keep this from happening?

[@ExcelForFreelancers]

Hi Ray its hard to tell. Make sure you are saving it as an xlsm file and also save your workbook before running any macros. Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 25,000 Members who would love to help you with this. Thanks so much.

[@laurellsnailsandcare]

This is a great video, but I can’t seem to get the macros to work. It keeps saying duplicate declaration in current scope

[@ExcelForFreelancers]

Hi Laurell's, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.

[@magichands1982]

How did you get your selected row and column identifiers to be yellow instead of gray? Thanks for these videos by the way, I watch a few everyday!

[@ExcelForFreelancers]

Hi Robert, thanks very much for your comment. I just colored the background cell yellow, There is no conditional formatting on that. In the video coming this Tuesday I will do another from scratch so you can follow along as well. This upcoming week i will be showing you how to create Work Orders and sync with Mobile Staff.

[@magichands1982]

I meant the color of the cells you have selected, not the cell it'self but the identifier at the top and far left of the screen indicating which cell you have selected. Mine is gray, is there a way to change it to the yellow like you have? And that sounds great! looking forward to the new lesson!

[@ExcelForFreelancers]

Hi Robert, to change the selected cells when a user selects a row i used a conditional formatting with a formula such as =$B$3=Row() Then when a user makes a selection change the row color will change based on the applied format in the conditional formatting. You can learn about that here: kzbin.info/www/bejne/bILKqmSOi6-Mnrs

[@upaliwijeratne8696]

Hi Nice Vedio However I can not find worksheet object in VB Object menu when I try select it. Pls advise me

[@ExcelForFreelancers]

HI and thanks very much. The worksheet object is only available in the worksheet code (not in a module) so in VBA you would want to right click the sheet and click View Code in order to select the worksheet objects and then your workhseet event. I hope this helps and thanks so much.

[@Hussainlhr]

Thanks a lot. will you please guide me. I just need that invoice number should start from 1 again next day with the date change plz help me to do so.

[@ExcelForFreelancers]

HI and thanks you can run an if statement checking on the previous Invoice Date and if the current date is not the same as the previous date then show the current date. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@sphiwemthimunye5201]

Thank you so much for amazing skill.

[@ExcelForFreelancers]

For sure, you are very welcome, I am glad I can help. Thank you for your Likes, Shares & Comments. It really helps.

[@evanturner3046]

having troube getting the addresses to populate. I'm not very familiar with macros, but i am following all your steps and keeping line for line.

[@ExcelForFreelancers]

Hi Evan thanks so much for following. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

[@robertbateman3665]

Question: What happens if the invoice migrates into multiple pages? Printing and recalling the invoice? Curious thought. I really like your videos. Thanks.

[@ExcelForFreelancers]

Hi and thanks so much Robert. Multiple pages is not a problem. You can determine the last row using xlup then set the print range dynamically within the code. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@alistairscott9216]

Hi, I have watched your video, I am a bit rusty with Excel. I have entered text and cell info verbatim in Macro and Cell "E4" and "E5" are still blank when I go back to invoice view, to see if it's working, (The address box is still empty after double clicking in the cell. What Am I doing wrong? I have made my works sheet the same as yours to the Letter. Cheers Alistair

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@sheikhified]

Thanks again Randy

[@ExcelForFreelancers]

For sure, you are very welcome

[@RealSuperNintendan]

Hello my friend. I am just wondering what program or app you use to record your screen? Also, what microphone (or headset?) do you use? And finally, what program do you use to put it all together?

[@ExcelForFreelancers]

Hi and thanks for your comment and question. For the recording I use Camtasia Student Microphone i use Yetti Blue. And to edit it and put the video together i also use Camtasia Studio for that. I hope this helps and thanks.

[@andrewbartlett824]

Love watching learning well in lock down, I have created the invoice and macro but on my true ,fales dose not work as it should as sometimes it reads ture ,ture or false, false which will not allow me to crate a new invoice and not ad items unless I manually change them any idea why

[@ExcelForFreelancers]

Hi and thanks for your comment. It would be difficult to know what is causing the issue unless we see your code. Please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@nenylee6073]

Hi sir please make video how to create quotation,invoice & delivery order (items & customer list ) using excel Please.....

[@ExcelForFreelancers]

Hi and thanks. I have all of that already. Please search my channel. I hope this helps and thanks so much.

[@karemapringle1946]

Really appreciate these video's learnt a lot

[@ExcelForFreelancers]

For sure, you are very welcome Karema

[@deenwayztrading3262]

Hi Randy, How do we store each invoice in google drive with one click? If you have done video for that please send the link. Thanks

[@ExcelForFreelancers]

Hi and thanks so much. You can download the Google Drive application for your computer and simply safe the Invoice as a PDF in that folder. I hope this helps and thanks so much.

[@deenwayztrading3262]

@@ExcelForFreelancers Thanks a lot Randy It works. Thanks for teaching us.

[@renatajesus6769]

Hi! Hope everything is perfect for you. I've seen practically every Excel for Freelancers video. I would like to know how I can get to learn how to make the invoice program and how much ...

[@ExcelForFreelancers]

HI Renata, thanks so much. It is free, you can download this application using the links in the description and follow this video to make the Invoice program. Thanks again.

[@majedshareif3611]

Nice to listen that. Thank you Manger. And I appreciate your efforts for all that is made.

[@ExcelForFreelancers]

For sure, you are very welcome Majed and thanks so much.

[@abirmahmud3115]

Thank you for the nice tutorial. If I want to delete an item from loaded invoice what are the steps we needed?

[@ExcelForFreelancers]

Hi you can add an inline button to remove or add new. You can use this training here to help you: kzbin.info/www/bejne/roC6e3yifJ2Le6c Thanks for the great question. I am also teaching a comprehensive Invoice with all of these features in my Mentorship Program here: bit.ly/MentorProgram_YTComment

[@riyaa8061]

Very Useful, It would great, If you could provide delete invoice item event, Can you assist me that same..

[@ExcelForFreelancers]

Hi and thanks so much for your comment. When deleting an invoice item you would just have to delete the original database item based on the database row. I am teaching full Invoicing features in my Mentorship Program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/

[@rofiqulislam7544]

Nice video ❤️❤️

[@ExcelForFreelancers]

Thanks for the visit. I really appreciate that Rofiqul

[@seanfletcher7659]

Hello Randy. Awesome tutorial! I made it about 15 minutes in when I realized that the version of excel that Ian using doesn’t have the name manager function under the formula toolbar. Wondering if there is a work around for said issue? Please advise. Thanks!!!

[@ExcelForFreelancers]

Hi Sean, thanks very much. Is that a Mac version? I have heard that some versions of Mac's dont have name managers. Perhaps a different version or OS would be better if this is the case. I hope this helps and thanks so much.

[@seanfletcher7659]

@@ExcelForFreelancers Yes, It is on an older mac. Think the version of Excel I am running is 2011. I can see the name manager Icon but it is grey and can't select it. Sad to hear, Oh well. Thanks anyway Randy, i'll try on a newer computer

[@gutangerine]

Thanks for such a great tutorial! I am walkthrough it and practising, only to find that I am stuck at the first Macro where the customer details don't pull up themselves..... wondering what went wrong in my script.....

[@ExcelForFreelancers]

Hi, Thanks for your comment and I am glad you enjoyed the training. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.

[@lemyul]

thanks

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help.

[@musedeeknasr8297]

very helpful work but i have a question when i put the codes to show the address like you explained it doesn't work with me like it did with you any help with that? notice i'm excel amateur

[@ExcelForFreelancers]

Hi its no problem. These things take time, and we are happy to help. Can you share a screenshot of your code, along with the detailed issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel . We have 25,000 members and would love to help you though this.

[@musedeeknasr8297]

@@ExcelForFreelancers i will thanks for your time