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!!
Wait there he’s got a beginners course?? I’m gonna have to look for that. There’s so many features and options within Excel I honestly don’t get how you learn all this stuff to know it’s an option to use and apply. It’s awesome, overwhelming, and fascinating all at the same time. 🤯 🎉😂
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.
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.
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: ruclips.net/video/MrAFCI6J_Rc/видео.html
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
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?
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.
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.
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
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
Hi and thanks so much. You can add Previous and Next buttons. I show you how to do that in this training: ruclips.net/video/_botNdkRzzk/видео.html I hope this helps and thanks so much.
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.
HI and thanks. Yes you can automatically total items if you like. I show you how to do that in this video ruclips.net/video/SbjBgqzbA3w/видео.html I hope this helps and thanks so much.
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 👍.
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
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.
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.
@@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.
@@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"?
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
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
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.
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!
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?
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? Randy@ExcelForFreelancers.com Thanks so much.
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.
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?
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.
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
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
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.
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.
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.
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
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
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.
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
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.
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?
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? Randy@ExcelForFreelancers.com Thanks so much.
This tutorial is amazing and been trying to follow all the steps. Sadly, I think I’m stock at 26:49. Because it’s not showing me the Worksheet option with the (General). (Declaration) didn’t show other option neither 🥺
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
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.
HI and thanks, mostly the same however there are some differences laid out in this website www.macexcel.com/ Please keep in mind that Excel on a Mac is somewhat limited when it comes to macros so its best to use a PC I hope this helps and thanks so much.
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.
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.
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.
Hi, i would like to know whether is there an template or format for Invoice, Proforma Invoice, order confirmation, packing list and Delivery order that i could purchase and use it ?
Hi and thanks I do not have all of those features in a single application however you are welcome to customize any of my applications, or feel free to email me with a detailed project scope and I can refer a developer to create this for you. I hope this helps and thanks so much. Randy@ExcelForFreelancers.com
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
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.
Hi Pinkrah, and thanks so much. You can use a helper column to create a date-based or numerical-based number, then combine that with text in another column to create your unique invoice #'s. 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
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.
Hi Daryl, I used the Invoice # as a criteria so that only those items associated with that invoice would filter out. 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
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??
HI and yes, it can, you can check out this video here: ruclips.net/video/_botNdkRzzk/видео.html I also show you how to email this on my Patreon channel here: www.patreon.com/ExcelForFreelancers
Hi and thanks, yes that makes sense. For example, in one Invoice i created for the Auto Workshop Manager, the first column is a drop down of Labor or Service, once that is selected the next column is either a drop-down list of all service items, or all Employees, each with their own hourly rates. You can see this Invoice here: ruclips.net/video/ymrwA6_Ko4c/видео.html I hope this helps and thanks so much.
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/
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
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.
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
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
Hi you can add an inline button to remove or add new. You can use this training here to help you: ruclips.net/video/xOWJIlG8XEE/видео.html 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
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?
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/
Great content. Thank you! You’ve been very helpful. I know it’s recorded, but for future content it’d be super helpful to slow your roll a little and speak a little slower. 😂
Hi and thanks very much. I will make sure to talk slower. thanks very much for the feedback. Thank you for your Likes, Shares & Comments. It really helps.
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
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.
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.
Hi Randy hope your holiday was great In the purchase order tutorial , how do you create a delete function in vba for the purchase order so that my saved ORDERS do not pile up
HI and thanks you will want to determine the row of the invoice and then delete that row. You can also run and advanced filter on the items, by Invoice #'s can delete those rows as well. I hope this helps and thanks so much.
Hello goo day, can I ask a question because after doing all the process , it still won't work 29:30 , the name and address won't still appear and I don't know why.
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 60,000 Members who would love to help you with this. Thanks so much.
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.
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: ruclips.net/video/3BrscsEln7k/видео.html 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
Hello randy, would it be possible to have an excel product catalog with variable components and variable pricing? For example I would like to have a custom product with its own Bill of Materials set up and have that product be within our said product catalog and when a customer orders that product I would like for this to be automated in a way that the bill of material and cost from the raw materials show up in its own form. I’m not sure if you can help me with this. Thank you.
Hi thanks very much Rafael. Excel is certainly capable of that, and it would be a nice project for sure. While I am unable to take on any projects, if you email me the entire project scope, I could refer it to a qualified developer (Randy@ExcelForFreelancers.com ) I hope this helps and thanks very much.
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>>>>
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.
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.?
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/
Help! :-) I followed the tutorial until 26:39, where your screen shows "Option Explicit" - My version of Excel (Office Professional plus 2019) doesn't have a dropdown for worksheet - just the general tab - have I done something wrong? Loved the tut to this point but now frustrated I can't complete it - can you help please? Sam.
Hi and thanks very much for your comment. You can write code within modules or within worksheets. Only the code within the worksheet has those drop down lists for worksheet events. 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/ I hope this helps and thanks so much.
@@ExcelForFreelancers It will help - eventually, when it sinks in what you are telling me ( old dog learning new tricks LOL) Just realised that i can download the excel sheet from your very helpful Facebook page so will try to work it out tomorrow when this 'ole brain is firing on 4 x cylinders again. Thank you so much for the personal help - it's a personal goal to create this Invoice to prove to myself I'm not prehistoric!!!!
Regarding the Inv#: How do we go about it if we need the invoiceNr to actually be formatted like: "INV0001". How do we adapt the command so we can have as next inv.# "INV0002"
Hi and thanks you can use a helper column in your Invoice database. One column keeps track of the numerical #'s (1, 2, , 3, etc), while another column combines the numerical with the alphanumerical #'s. I am going to be teaching this when I reach the Invoice & Receipts section of the large School Manager series here on RUclips. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for the response and the solution. One of your admins in the FB page suggested to take advantage the Text(row()) function which worked in my case. Ideally I would prefer a solution than "tells" the macro to separate the numerical from the alphanumerical, add 1 for the next row and then re-combine the two. Maybe you could include that in your upcoming series. Nevertheless, I really appreciate your and your teams responses. I am someone who started programming excel from your videos (and purchased a pack of your files from your website) and have been able to set up a mini ERP (although incomplete) for my business. Sometimes it is hard to adapt some functions to my needs, but it's a fun and ongoing and probably never ending work in progress!
Thanks so much and glad you were able to get a solution. I will try to add a solution for the alphanumeric ID's in the near future. I hope this helps and thanks so much.
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.
Thanks so much for this training. I have a couple of questions though. You use the cell B5 to check if the invoice was loaded. In VBA you just set B5 to true. When will it be set to False? And what if i want to add something to my invoice? Adding an item does not load the description, quantity and price. Even if you add a new invoice nr. Could you check it?
Hi and thanks for your question. B5 should be marked as True at the beginning of the macro and go to False before the macro completed. 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.
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!!!
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.
@@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
Hi, Randy! I wanna know what should be the code if i don't want to include QTY on the INVOICE. Your code for the INVOICE is "Range ("E" & Target.Row & ":G" & Target.Row).Value = Sheet5.Range("C" & ItemRow & ":G" & ItemRow).Value 'Copy over Desc, Qty, Price." On the ITEMS sheet, I removed the QTY column (Column D) and put my "Sales Price" there instead. Your help is highly aprreciated.
HI and thanks if you do not need the Qty then you can get rid of 2 columns (Qty & total) and just use the same. There would be a lot of changes to the code and formulas, and much more than I could explain in a RUclips comment. You could also try defaulting the Qty to 1 via VBA and hiding the price & Qty columns. 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
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.
Hello Randy, I followed along and built the invoice, however the advanced filter doesn't appear to be working, so the Items, descriptions, quantities and prices are not showing in existing invoices. I downloaded the workbook and checked the VBA and mine seems to be correct. Any thoughts on what I missed? Thank you for the training.
Hi Mark, thanks for your comment. Can you upload your workbook, and/or screenshots of code to our Excel For Freelancers group here: bit.ly/groupexcel This way me and the members can have a direct look at the issue. I am sure we can get it corrected right away for you.
Thank you for your response, I have requested to join the@@ExcelForFreelancers Facebook group and will upload the workbook as soon as I am able to. I have added a customer # field and a row to add a client's logo, but I believe that I have accounted for them in VBA. Thank you in advance for the assistance., Mark
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 😊
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: ruclips.net/video/9biCBLwEngM/видео.html I hope this helps and thanks so much.
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
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.
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
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.
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.....
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.
If you fail in the Change Event Worksheet section at 29:00 minutes. there is an easy way, using IFERROR() and INDEX() The procedure: If you have followed the previous tutorial which created a 'Name Manager' for the Customer Name, then you created a new Name Manager specifically for the Customer Address section. then you click Sheet Row E4 on the Sheet Invoice. After that use the INDEX() formula =INDEX(Customer_address;B2;1) Then you will be able to address the customer according to their name / their data. B2 is here to identify the customer's name in what row, 1 here is column. If Empty Will Error? therefore use IFERROR() then the forum is so =IFERROR(NDEX(Customer_address;B2;1); " ") If there is no data then it is not written. This is an easy way, if you are still confused, try reading about Forumal Index() Excel or watch on youtube about that Good luck.....
Hi Wakwaw, 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.
Hi Randy, Thank you for the awesome video. When I click the Add New Button, a Run Time Error 13 will pop out for "If Target.Value Empty And Range("B6").Value Empty Then" on the macro worksheet change. Please advice me on how to solve the issue. Thank you :)
Hi it is hard to know since I cannot see your workbook but make sure the cell you are selecting or editing does not contain an error. Please share your entire code screen shots and workbook in 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.
Thank you so much for your work! Just a few questions. Is it possible to have the next available invoice number to be automatically there at H1 when you press add new button? Thanks!
HI Keil, yes, its certainly possible. On the Invoice_New macro, after the fields are cleared, after the ".Shapes("AddNewBtn").Visible = msoFalse" line add .Range("H1").value = .Range("B6").Value 'Add New Invoice # Also on the worksheet change event update this line to include one more condition like this 'On Change of Invoice #, Load Invoice If Not Intersect(Target, Range("H1")) Is Nothing And Range("H1").Value Empty And Range("H1").Value Range("B6").Value Then Invoice_Load 'Load Invoice
@@ExcelForFreelancers It worked! Thank you! I removed the End If below that line because it gives me error when I add a new invoice. I also had a problem with Inv Load not changing to False when adding a new invoice so I added a line on the Invoice_New like this .Range("B5").Value = False Anyway, I really appreciate your work and sharing it so other people would be able to do it and use it. Thank you very much!
Hello, How would we add a quote to this ? could you maybe do a video where you add a quote page , so that if you create a quote it "holds" the coresponding invoice number so that when the client accepts the quote you could just convert or add that quote to the invoice number?
HI and thanks I have that already in a few other videos. You can search for "Estimate" and "Document Workflow" and "1-Click Estimate, Work Order & Invoice" here: ruclips.net/video/CkbEQ_S91Y0/видео.html for some videos to help you with that.
Hi yes this application is included within the 150 Pack. I hope this helps and thanks. You can see a list of all applications within the file here: www.excelforfreelancers.com/product/100-of-my-best-excel-workbooks
Yes it is certainly possible. Adding some additional code. Please feel free to download this application using the link in the description and customize it however you like. I hope this helps and thanks so much.
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?
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.
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?
Hi that is a great question. I solve that issue in this training: ruclips.net/video/MrAFCI6J_Rc/видео.html 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.
Hi should the invoice number automatically change to the next available invoice number once you press add new invoice I have followed your instructions but mine is not doing so i wondered if you might be able to explain how to do this. thank you
Hi Megan, thanks for your comment. Make sure you create the new Invoice # using the Max formula and have that new Invoice # added to column A for new 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
Excellent, but how would I include a list to show all of the inv #'s so that the user would be forced to choose from the available inv #'s? Also, would it be a good idea to have a Cust #? Thx
HI and thanks so much. You can learn to add customer details in this updated video here: ruclips.net/video/eF678YvQ93g/видео.html I hope this helps and thanks so much.
I'd like to know if it is possible to use DATE WITHOUT TIME stamped on the invoice? I prefer to use DATE ONLY because I need to calculate my daily sales based on DATE (Excel does not work this way if the date has time included on it). Hope there is a way to solve this issue.
Hi and thanks you can have a date without time simply by making sure the date is a whole number and formatting it without the minutes & seconds in cell formatting. 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
Hi Jos, Thanks very much. Yes certainly its possible. The application is open and you are welcome to customize it as you like. In my Mentorship Program I will be teaching how to create a comprehensive Invoice with Email As, (Picture, Excel, PDF), Save as (Picture, Excel, PDF), Make Recurring, Apply Payments, and a host of other features that will be part of a large accounting application here: bit.ly/MentorshipProgram_YTCom
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?
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.
seus videos nunca foram terrivel, é unico canal que fala e debruça sobre o excel em diferentes dominios. esse canal ja ajudou e empregou de certeza muitas pessoas. Eu sou a prova viva que esse é o maximo, consegui aperfeiçoar o meu excel e ajudar outros tambem mas sempre indicando pessoas para seguiram esse canal. Que continuem com essa garra e determinacao
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.
![Learn How To Create This Excel Work Order Application & Mobile Sync [Full Training From Scratch]](/img/1.gif)
🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
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!!
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.
Wait there he’s got a beginners course?? I’m gonna have to look for that.
There’s so many features and options within Excel I honestly don’t get how you learn all this stuff to know it’s an option to use and apply.
It’s awesome, overwhelming, and fascinating all at the same time. 🤯 🎉😂
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.
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.
Randy thank you for this classes online I have learned a lot from your videos.
You are very welcome Cyrill
applauses for, brillant pronunciation,, content, n flying directly to the results, u got the navy salute.
Thank you so very much, I really appreciate that
Just from those videos I discovered that I still have a lot to learn to increase my skill.
I am happy I can help. Thank you for your Likes, Shares & Comments. It really helps.
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.
Thank you for your Likes, Shares & Comments. It really helps.
Thank you for your effort, love from Malaysia
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: ruclips.net/video/MrAFCI6J_Rc/видео.html
I am grateful to have come across your channel. Great work!
Thank you so very much, I really appreciate that Cha
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
Thank you so very much, I really appreciate that.
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?
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.
@@ExcelForFreelancers thanks so much
For sure, you are very welcome
thanks a lot Mr.randy for your useful lesson
You are very welcome, and I am happy I could help
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.
please note I have formulas in those rows, would that effect?? what can I do?
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
Many thanks in deed. I will try it for sure.
Thank you, it worked perfectly.
Thats great to hear. I am glad it helped
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
Hi and thanks so much. You can add Previous and Next buttons. I show you how to do that in this training: ruclips.net/video/_botNdkRzzk/видео.html
I hope this helps and thanks so much.
thanks a lot. i have a construction company that gives me a headache on paper works everyday. thank you for this.
For sure, you are very welcome. I am happy to help and share.
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.
HI and thanks. Yes you can automatically total items if you like. I show you how to do that in this video ruclips.net/video/SbjBgqzbA3w/видео.html
I hope this helps and thanks so much.
Very intersting. Nice Work.
Thank you very much. I do appreciate that Chris
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 👍.
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.
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.
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
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.
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.
@@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.
@@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"?
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
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
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.
I'm having this same problem. I just requested to join the group, hopefully there was a resolution to this problem.
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!
Thank you so very much, I really appreciate that Sara
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?
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? Randy@ExcelForFreelancers.com
Thanks so much.
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.
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.
Nice work. Keep it up😊
Cam On Em :)
Nice invoice setup !!
Thank you Joe, I am glad I could help
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?
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.
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
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
@@ExcelForFreelancers sry what i meant was B through F -->Row not colums, are merged, my bad
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.
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.
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.
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
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
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
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.
well done, very good training. God bless you
For sure, you are very welcome Mohammad
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
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.
@@ExcelForFreelancers i will thanks for your time
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?
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? Randy@ExcelForFreelancers.com
Thanks so much.
This tutorial is amazing and been trying to follow all the steps. Sadly, I think I’m stock at 26:49. Because it’s not showing me the Worksheet option with the (General). (Declaration) didn’t show other option neither 🥺
Nevermind, I’ve scan thru the comments and found someone with the same issue. And solved mine with your answer to their question. Thanks ❤
Thank you Zhyrie, I appreciate that and glad you were able to work it out. Thank you for your Likes, Shares & Comments. It really helps.
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
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.
@ExcelDorFreelancers are we able to use these same macros on Mac?
HI and thanks, mostly the same however there are some differences laid out in this website www.macexcel.com/
Please keep in mind that Excel on a Mac is somewhat limited when it comes to macros so its best to use a PC
I hope this helps and thanks so much.
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.
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.
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.
Hi, i would like to know whether is there an template or format for Invoice, Proforma Invoice, order confirmation, packing list and Delivery order that i could purchase and use it ?
Hi and thanks I do not have all of those features in a single application however you are welcome to customize any of my applications, or feel free to email me with a detailed project scope and I can refer a developer to create this for you.
I hope this helps and thanks so much. Randy@ExcelForFreelancers.com
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
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.
hello, please concerning the invoice numbers, if you wish to use text and values as the invoice number, how do you automate it?
eg: VT2021/11001
Hi Pinkrah, and thanks so much. You can use a helper column to create a date-based or numerical-based number, then combine that with text in another column to create your unique invoice #'s.
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
Simply Amaizing thank you for share your knowledge
Thank you very much. I do appreciate that.
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
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.
@@ExcelForFreelancers Thanks a lot Randy It works. Thanks for teaching us.
What code did you set for the criteria to change according to load invoices
Hi Daryl, I used the Invoice # as a criteria so that only those items associated with that invoice would filter out. 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
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??
HI and yes, it can, you can check out this video here: ruclips.net/video/_botNdkRzzk/видео.html
I also show you how to email this on my Patreon channel here: www.patreon.com/ExcelForFreelancers
Hi thank you so much for this video, can i ask question how about if we do also like the item have category. Like multiple drop list connected
Hi and thanks, yes that makes sense. For example, in one Invoice i created for the Auto Workshop Manager, the first column is a drop down of Labor or Service, once that is selected the next column is either a drop-down list of all service items, or all Employees, each with their own hourly rates. You can see this Invoice here: ruclips.net/video/ymrwA6_Ko4c/видео.html
I hope this helps and thanks so much.
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.
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/
Wonderful work
Thank you so very much, I really appreciate that Joshua
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
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.
@@ExcelForFreelancers yesss i will definitely keep watching. i can re assure that you have another committed subscriber.
Thank you so very much, I really appreciate that.
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
HI and thanks so much. I have a lot of those features added in my newest Invoice training here: ruclips.net/video/nyjk7_J7a_A/видео.html
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
Thank you for the nice tutorial. If I want to delete an item from loaded invoice what are the steps we needed?
Hi you can add an inline button to remove or add new. You can use this training here to help you: ruclips.net/video/xOWJIlG8XEE/видео.html
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
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?
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/
Great content. Thank you! You’ve been very helpful.
I know it’s recorded, but for future content it’d be super helpful to slow your roll a little and speak a little slower. 😂
RUclips allows you to do that in settings?
Hi and thanks very much. I will make sure to talk slower. thanks very much for the feedback.
Thank you for your Likes, Shares & Comments. It really helps.
@@asifosman I might give that a try, it might slow it down too much though. I might have just needed a lot more coffee to keep up. 😂😂
@@asifosmanhaha!! I just found the playback speed changer. Any thing slower than 0.75 and he sounds stoned. But thanks for the tip!!
Thank you so very much. Amazing teaching. I learnt a lot today....
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
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.
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.
Hi John can I buy the template for the invoice app you discuss in the mentorship programme direct from you?
Hi Randy hope your holiday was great
In the purchase order tutorial , how do you create a delete function in vba for the purchase order so that my saved ORDERS do not pile up
HI and thanks you will want to determine the row of the invoice and then delete that row. You can also run and advanced filter on the items, by Invoice #'s can delete those rows as well. I hope this helps and thanks so much.
Hello goo day, can I ask a question because after doing all the process , it still won't work 29:30 , the name and address won't still appear and I don't know why.
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 60,000 Members who would love to help you with this. Thanks so much.
Thank you so much . I'm from vietnam's fan
Cam On Em. I live in Da Nang. Nice to have you here.
Nice tutorial, thanks
Thank you so very much, I really appreciate that.
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.
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: ruclips.net/video/3BrscsEln7k/видео.html
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
Hello randy, would it be possible to have an excel product catalog with variable components and variable pricing? For example I would like to have a custom product with its own Bill of Materials set up and have that product be within our said product catalog and when a customer orders that product I would like for this to be automated in a way that the bill of material and cost from the raw materials show up in its own form. I’m not sure if you can help me with this. Thank you.
Hi thanks very much Rafael. Excel is certainly capable of that, and it would be a nice project for sure. While I am unable to take on any projects, if you email me the entire project scope, I could refer it to a qualified developer (Randy@ExcelForFreelancers.com )
I hope this helps and thanks very much.
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>>>>
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.
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.?
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/
Excel For Freelancers
Thank you Randy☺️
Great video, Randy!
Glad you enjoyed it Alfred :)
Another great lesson Randy, thanks!
Thank you so very much, I really appreciate that Rob and always appreciate your help and support.
Help! :-) I followed the tutorial until 26:39, where your screen shows "Option Explicit" - My version of Excel (Office Professional plus 2019) doesn't have a dropdown for worksheet - just the general tab - have I done something wrong? Loved the tut to this point but now frustrated I can't complete it - can you help please?
Sam.
Hi and thanks very much for your comment. You can write code within modules or within worksheets. Only the code within the worksheet has those drop down lists for worksheet events.
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/
I hope this helps and thanks so much.
@@ExcelForFreelancers It will help - eventually, when it sinks in what you are telling me ( old dog learning new tricks LOL)
Just realised that i can download the excel sheet from your very helpful Facebook page so will try to work it out tomorrow when this 'ole brain is firing on 4 x cylinders again.
Thank you so much for the personal help - it's a personal goal to create this Invoice to prove to myself I'm not prehistoric!!!!
For sure, you are very welcome and thanks so much
Regarding the Inv#: How do we go about it if we need the invoiceNr to actually be formatted like: "INV0001". How do we adapt the command so we can have as next inv.# "INV0002"
Hi and thanks you can use a helper column in your Invoice database. One column keeps track of the numerical #'s (1, 2, , 3, etc), while another column combines the numerical with the alphanumerical #'s. I am going to be teaching this when I reach the Invoice & Receipts section of the large School Manager series here on RUclips. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for the response and the solution. One of your admins in the FB page suggested to take advantage the Text(row()) function which worked in my case. Ideally I would prefer a solution than "tells" the macro to separate the numerical from the alphanumerical, add 1 for the next row and then re-combine the two. Maybe you could include that in your upcoming series.
Nevertheless, I really appreciate your and your teams responses. I am someone who started programming excel from your videos (and purchased a pack of your files from your website) and have been able to set up a mini ERP (although incomplete) for my business. Sometimes it is hard to adapt some functions to my needs, but it's a fun and ongoing and probably never ending work in progress!
Thanks so much and glad you were able to get a solution. I will try to add a solution for the alphanumeric ID's in the near future.
I hope this helps and thanks so much.
Hi Randy thanks for sharing
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.
Thanks so much for this training. I have a couple of questions though.
You use the cell B5 to check if the invoice was loaded. In VBA you just set B5 to true.
When will it be set to False? And what if i want to add something to my invoice? Adding an item does not load the description, quantity and price. Even if you add a new invoice nr.
Could you check it?
Hi and thanks for your question. B5 should be marked as True at the beginning of the macro and go to False before the macro completed. 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.
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!!!
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.
@@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
Hi, Randy! I wanna know what should be the code if i don't want to include QTY on the INVOICE. Your code for the INVOICE is "Range ("E" & Target.Row & ":G" & Target.Row).Value = Sheet5.Range("C" & ItemRow & ":G" & ItemRow).Value 'Copy over Desc, Qty, Price." On the ITEMS sheet, I removed the QTY column (Column D) and put my "Sales Price" there instead. Your help is highly aprreciated.
HI and thanks if you do not need the Qty then you can get rid of 2 columns (Qty & total) and just use the same. There would be a lot of changes to the code and formulas, and much more than I could explain in a RUclips comment. You could also try defaulting the Qty to 1 via VBA and hiding the price & Qty columns.
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
This is so beautiful. Thanks Randy for this amazing video.
Thanks so much Muzammil (Syed), you changed your name. Thanks and I knew you would like this one. Much appreciated.
@@ExcelForFreelancers No, I haven't changed my name, Syed is Surname, Muzammil is FIrst and Mahasan is Last name.
Welcome Randy
Hi Nice Vedio
However I can not find worksheet object in VB Object menu when I try select it. Pls advise me
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.
Nice to listen that. Thank you Manger. And I appreciate your efforts for all that is made.
For sure, you are very welcome Majed and thanks so much.
Hello Randy, I followed along and built the invoice, however the advanced filter doesn't appear to be working, so the Items, descriptions, quantities and prices are not showing in existing invoices. I downloaded the workbook and checked the VBA and mine seems to be correct. Any thoughts on what I missed?
Thank you for the training.
Hi Mark, thanks for your comment. Can you upload your workbook, and/or screenshots of code to our Excel For Freelancers group here: bit.ly/groupexcel This way me and the members can have a direct look at the issue. I am sure we can get it corrected right away for you.
Thank you for your response, I have requested to join the@@ExcelForFreelancers Facebook group and will upload the workbook as soon as I am able to. I have added a customer # field and a row to add a client's logo, but I believe that I have accounted for them in VBA.
Thank you in advance for the assistance.,
Mark
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 😊
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: ruclips.net/video/9biCBLwEngM/видео.html
I hope this helps and thanks so much.
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
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.
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
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.
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.....
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.
If you fail in the Change Event Worksheet section at 29:00 minutes.
there is an easy way, using IFERROR() and INDEX()
The procedure:
If you have followed the previous tutorial which created a 'Name Manager' for the Customer Name, then you created a new Name Manager specifically for the Customer Address section.
then you click Sheet Row E4 on the Sheet Invoice.
After that use the INDEX() formula
=INDEX(Customer_address;B2;1)
Then you will be able to address the customer according to their name / their data.
B2 is here to identify the customer's name in what row, 1 here is column.
If Empty Will Error? therefore use IFERROR()
then the forum is so
=IFERROR(NDEX(Customer_address;B2;1); " ")
If there is no data then it is not written.
This is an easy way, if you are still confused, try reading about Forumal Index() Excel or watch on youtube about that
Good luck.....
Hi Wakwaw, 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.
Hi Randy, Thank you for the awesome video. When I click the Add New Button, a Run Time Error 13 will pop out for "If Target.Value Empty And Range("B6").Value Empty Then" on the macro worksheet change. Please advice me on how to solve the issue. Thank you :)
Hi it is hard to know since I cannot see your workbook but make sure the cell you are selecting or editing does not contain an error. Please share your entire code screen shots and workbook in 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.
Thank you so much for your work! Just a few questions. Is it possible to have the next available invoice number to be automatically there at H1 when you press add new button? Thanks!
HI Keil, yes, its certainly possible. On the Invoice_New macro, after the fields are cleared, after the ".Shapes("AddNewBtn").Visible = msoFalse" line add
.Range("H1").value = .Range("B6").Value 'Add New Invoice #
Also on the worksheet change event update this line to include one more condition like this
'On Change of Invoice #, Load Invoice
If Not Intersect(Target, Range("H1")) Is Nothing And Range("H1").Value Empty And Range("H1").Value Range("B6").Value Then Invoice_Load 'Load Invoice
@@ExcelForFreelancers It worked! Thank you! I removed the End If below that line because it gives me error when I add a new invoice.
I also had a problem with Inv Load not changing to False when adding a new invoice so I added a line on the Invoice_New like this
.Range("B5").Value = False
Anyway, I really appreciate your work and sharing it so other people would be able to do it and use it.
Thank you very much!
Hello, How would we add a quote to this ? could you maybe do a video where you add a quote page , so that if you create a quote it "holds" the coresponding invoice number so that when the client accepts the quote you could just convert or add that quote to the invoice number?
HI and thanks I have that already in a few other videos. You can search for "Estimate" and "Document Workflow" and "1-Click Estimate, Work Order & Invoice" here: ruclips.net/video/CkbEQ_S91Y0/видео.html
for some videos to help you with that.
Thank you for this tutorial. I did an invoice template in MS Access for my school project and I based it from this tutorial. 🥂
Hi Harvey thanks so much for your comment. Really happy to hear that. Very well done.
it's very helpful-thank sir
For sure, you are very welcome Shekh
thanks Mr RANDY
For sure, you are very welcome Med
very good by show how to add new customer detail and new item
For sure, you are welcome. Thank you for your Likes, Shares & Comments. It really helps.
Does the invoice workbook including in the excel 150 workbook? Don't really have time to create it from scratch and I rather buy it. Thanks
Hi yes this application is included within the 150 Pack. I hope this helps and thanks. You can see a list of all applications within the file here: www.excelforfreelancers.com/product/100-of-my-best-excel-workbooks
Thanks for replying
Once invoice saved, display old invoice and alter item and qty,rate, amount, even delete item with qty , rate, amount...is possible...
Yes it is certainly possible. Adding some additional code. Please feel free to download this application using the link in the description and customize it however you like.
I hope this helps and thanks so much.
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?
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.
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?
Hi that is a great question. I solve that issue in this training: ruclips.net/video/MrAFCI6J_Rc/видео.html
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.
Hi should the invoice number automatically change to the next available invoice number once you press add new invoice I have followed your instructions but mine is not doing so i wondered if you might be able to explain how to do this.
thank you
Hi Megan, thanks for your comment. Make sure you create the new Invoice # using the Max formula and have that new Invoice # added to column A for new 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
Excellent, but how would I include a list to show all of the inv #'s so that the user would be forced to choose from the available inv #'s? Also, would it be a good idea to have a Cust #? Thx
Hi and thanks you can add data validations based on the invoice # named range. I hope this helps and thanks so much.
Hi. this is great video. may i know how to add customer detail exp address phone
HI and thanks so much. You can learn to add customer details in this updated video here: ruclips.net/video/eF678YvQ93g/видео.html
I hope this helps and thanks so much.
I'd like to know if it is possible to use DATE WITHOUT TIME stamped on the invoice? I prefer to use DATE ONLY because I need to calculate my daily sales based on DATE (Excel does not work this way if the date has time included on it). Hope there is a way to solve this issue.
Hi and thanks you can have a date without time simply by making sure the date is a whole number and formatting it without the minutes & seconds in cell formatting. 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
@@ExcelForFreelancers Thank you so much, sir, for helping a lame dog over a stile.
Very helpful indeed. Is it possible to change the "print" button to a "send e-mail" button (and change the code)?
Hi Jos, Thanks very much. Yes certainly its possible. The application is open and you are welcome to customize it as you like. In my Mentorship Program I will be teaching how to create a comprehensive Invoice with Email As, (Picture, Excel, PDF), Save as (Picture, Excel, PDF), Make Recurring, Apply Payments, and a host of other features that will be part of a large accounting application here: bit.ly/MentorshipProgram_YTCom
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?
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.
Incrível como sempre, excel para todas as areas do trabalho.
Bem, você tem que assistir o vídeo primeiro. Talvez seja terrível? :)
Obrigado sempre David
seus videos nunca foram terrivel, é unico canal que fala e debruça sobre o excel em diferentes dominios.
esse canal ja ajudou e empregou de certeza muitas pessoas. Eu sou a prova viva que esse é o maximo, consegui aperfeiçoar o meu excel e ajudar outros tambem mas sempre indicando pessoas para seguiram esse canal.
Que continuem com essa garra e determinacao
sou vosso fãn numero um
Muito obrigado David. Sim, eu estava apenas brincando. Eu sempre aprendo suas amáveis palavras e comentários
This is a great video, but I can’t seem to get the macros to work. It keeps saying duplicate declaration in current scope
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.