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.
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.
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
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
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: ua-cam.com/video/MrAFCI6J_Rc/v-deo.html
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: ua-cam.com/video/_botNdkRzzk/v-deo.html I hope this helps and thanks so much.
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!!!!
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 ua-cam.com/video/SbjBgqzbA3w/v-deo.html 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.
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.
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.
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
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.
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
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 👍.
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.
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.
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 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
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 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.
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: ua-cam.com/video/ymrwA6_Ko4c/v-deo.html I hope this helps and thanks so much.
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.
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.
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.
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 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/
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 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: ua-cam.com/video/_botNdkRzzk/v-deo.html I also show you how to email this on my Patreon channel here: www.patreon.com/ExcelForFreelancers
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.
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.
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.
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 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 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 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/
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 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
Hi Randy! I love your tutorials. I have a question regarding this tutorial, hope you could help me. In the line of code that say (at 1:00:40) If.Range(“B3”).value = Empty Then Msgbox “Pleases select correct invoice number” Exit sub End if. This code executes only when it Run through VBA . It does not work if we put the wrong Invoice number. Pleased guide Thanks
Hi and thanks. On the On sheet Code you can just update the line even simpler such as If Not Intersect(Target, Range("H1")) Is Nothing Then Invoice_Load 'Load Invoice Then remove the rest of the code. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
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
HI Tony thanks so much. You can use an advanced filter to search for a partial name. I show you how in this video: ua-cam.com/video/YuCrEWU2Tm0/v-deo.html
Hi you can add an inline button to remove or add new. You can use this training here to help you: ua-cam.com/video/xOWJIlG8XEE/v-deo.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
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 🥺
Hi and thanks, please see my updated POS training on how to add discounts here: ua-cam.com/video/SbjBgqzbA3w/v-deo.html I hope this helps and 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: ua-cam.com/video/3BrscsEln7k/v-deo.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
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.
Hi there just found you and actually ran into a hiccup. At 32:41 you are making the code that copies everything over onto the invoice sheet from the item list. My excel keeps singling out the ":G" saying they need a separator or ( I honestly have no idea on what is stopping this.
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 50,000 Members who would love to help you with this. Thanks so much.
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 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.
Hi and thanks very much. You can go to the cell properties and make sure the cell is locked and then protect the sheet. I show you how to do this in this training: ua-cam.com/video/NXNA2uyCyJo/v-deo.html 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
Hello sir thank u so much: Sir can I make a video on Excel that has the following features: 1.where we can make automatic invoice like above. 2.where items automatically deduct in stock sheet. 3. Where we will write hsn code of item and all the details of that item will automatically be showed. I mean to say that it must be like an application that comes on net.
Yes sure you can do all of that, No problem at all. IF you need help with this, feel free to request help in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
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!
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/
Good day Randy, as i was doimg the InvoiceMacros, the address 1 and 2 os not filling up and there is this "Yellow arrow key pointing towards Private Sub Worksheet_SelectionChange (ByVal Target As Range) " what does that mean?
Hi and thanks that means there is some issue with the selection change macro. 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. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount
Hi Randy, Your video tutorial was excellent and was very simple to understand in min 44:15 If LastItemRow < 8 Then GoTo Noitems popup message error when Continue Run *Compile Error: Label Not Defined* can you help be to Solve it And This all code for this part 'Add/Update Invoice Items LastItemRow = .Range("D27").End(xlUp).Row 'Last Invoice Item Row If LastItemRow < 8 Then GoTo Noitems For ItemRow = 8 To LastItemRow If .Range("I" & ItemRow).Value Empty Then 'existing Row InvItemRow = .Range("I" & ItemRow).Value Else 'New Row InvItemRow = Sheet3.Range("A9999").End(xlUp).Row + 1 'Fist AvailRow Sheet3.Range("A" & InvItemRow).Value = .Range("H1").Value 'Invoice# .Range("I" & ItemRow).Value = InvItemRow 'Invoice Item Row Sheet3.Range("G" & InvItemRow).Value = "=Row()" 'Add Row# End If
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.
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! 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 UA-cam 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
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
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: ua-cam.com/video/9biCBLwEngM/v-deo.html I hope this helps and 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!
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.
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 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.
Hi and thanks so much for your comment. When deleting an invoice item you would just have to delete the original database item based on the database row. I am teaching full Invoicing features in my Mentorship Program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hi Randy, I stumbled on your video and it's amazing. I am half way through following along building this. I think I need help making the tool that I am envisioning though. Can you tell me what's the best way to find someone like you to develop a quoting tool/invoice tool that is customized to my needs? If you are interested, let me know. Thanks!
Hi James, thanks so much and glad you love the training. The best way would be to write up a detailed scope of your requirements then email them to me along with your budget. I can then forward it to a qualified developer. Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
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.
Hi Randy can you start adding a small part at the beginning where you show the finished product's functionalities. I find myself having to scroll through the video to see if certain methods are included
HI Saul, thanks for your comment. I do that mostly now with my newer videos, where I use a sample workbook to show all the features, before closing it and working on a blank one. Make sure to check out the POS With Inventory video launching in 14 hours right here: ua-cam.com/video/SbjBgqzbA3w/v-deo.html
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
For sure, you are very welcome Jan. I am happy to help and share. I have a brand new Invoice from scratch coming out next week which will include Installment payments. Thank you for your Likes, Shares & Comments. It really helps.
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.
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.
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
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 UA-cam. 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.
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
Hi and thanks the formulas should work regardless of the version of Excel, however in some language packs or regional settings you may have to make adjustments to the formulas. 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 all, Thank you all for the opportunity to learn and be able to produce a worthwhile product. I am a 73 year old and have only taken up Excel in the last 15 months to stimulate the brain and fulfill my fascination with VBA. I have made and converted Randy's invoice to a service invoice for my son who is a fiberglass caravan and motor home repairer. I have the invoice up and running with a number of extra requirements in the sales: Insurance - Customer area. My question to you is: To keep invoice rows contained to the least number required for a given quote/invoice, is it possible to add a VBA formula that can automatically increase rows and formulas as required and then when the invoice is saved revert back to the original size invoice. I have managed to insert a manual solution with a button but if there is a solution to my request can you advise me where I may find such information. Many thanks to you all
Hi Ian, thanks so much. I really appreciate your comments. It is a great question for sure. What you can do is create a Shape-based, floating footer, which will be positioned based on the last row of content. This is what I have done for the Invoice that I am designing in the Accounting Application in our Mentorship program. You can find a picture of that Invoice sample here: www.dropbox.com/s/cu61b33iq4rxk1n/Invoice_SS.jpg?dl=0 More information on our Mentorship Program here: bit.ly/MentorProgram_YTComment I hope this helps and thanks so much
@@ExcelForFreelancers Thank you for your reply, I look forward to seeing your application of the floating footer and trying to use it in my invoice. Meanwhile I will keep on learning more VBA to satisfy my fascination with Excel
🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm
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.
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.
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
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.
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.
Randy thank you for this classes online I have learned a lot from your videos.
You are very welcome Cyrill
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. 😂
UA-cam 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 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.
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 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: ua-cam.com/video/MrAFCI6J_Rc/v-deo.html
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: ua-cam.com/video/_botNdkRzzk/v-deo.html
I hope this helps and thanks so much.
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
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 ua-cam.com/video/SbjBgqzbA3w/v-deo.html
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.
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.
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
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
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.
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
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 Mr.randy for your useful lesson
You are very welcome, and I am happy I could help
I am grateful to have come across your channel. Great work!
Thank you so very much, I really appreciate that Cha
well done, very good training. God bless you
For sure, you are very welcome Mohammad
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.
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.
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.
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
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.
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.
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: ua-cam.com/video/ymrwA6_Ko4c/v-deo.html
I hope this helps and thanks so much.
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.
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.
Nice invoice setup !!
Thank you Joe, I am glad I could help
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.
Thank you so much . I'm from vietnam's fan
Cam On Em. I live in Da Nang. Nice to have you here.
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: ua-cam.com/video/nyjk7_J7a_A/v-deo.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
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/
Simply Amaizing thank you for share your knowledge
Thank you very much. I do appreciate that.
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
Very intersting. Nice Work.
Thank you very much. I do appreciate that Chris
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: ua-cam.com/video/_botNdkRzzk/v-deo.html
I also show you how to email this on my Patreon channel here: www.patreon.com/ExcelForFreelancers
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.
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.
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.
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.
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 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.
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.
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
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/
@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.
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
Hi Randy! I love your tutorials. I have a question regarding this tutorial, hope you could help me.
In the line of code that say (at 1:00:40)
If.Range(“B3”).value = Empty Then
Msgbox “Pleases select correct invoice number”
Exit sub
End if.
This code executes only when it Run through VBA . It does not work if we put the wrong Invoice number. Pleased guide
Thanks
Hi and thanks. On the On sheet Code you can just update the line even simpler such as
If Not Intersect(Target, Range("H1")) Is Nothing Then Invoice_Load 'Load Invoice
Then remove the rest of the code.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Excel For Freelancers
It worked Randy.... Thank you sooo much
Excel For Freelancers
It worked but it created a new problem, when i press “Add New” button the message also appears.
Excel For Freelancers
Hi Randy! It worked great but the error message also appears when i press “Add New Button” How do i resolve the issue?
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
Thank you for much for this tutorial. my only question is how do you do a quick search in the customer name?
HI Tony thanks so much. You can use an advanced filter to search for a partial name. I show you how in this video: ua-cam.com/video/YuCrEWU2Tm0/v-deo.html
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: ua-cam.com/video/xOWJIlG8XEE/v-deo.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
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.
hi sir thanks for your hard work to teach us. please give formula to add discount tab at different percentage. Thank you sir. God lees you
Hi and thanks, please see my updated POS training on how to add discounts here: ua-cam.com/video/SbjBgqzbA3w/v-deo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks a lot sir
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: ua-cam.com/video/3BrscsEln7k/v-deo.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
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
Hi there just found you and actually ran into a hiccup. At 32:41 you are making the code that copies everything over onto the invoice sheet from the item list. My excel keeps singling out the ":G" saying they need a separator or (
I honestly have no idea on what is stopping this.
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 50,000 Members who would love to help you with this. Thanks so much.
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 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.
This Invoice is very nice creation. I want to how can I restrict the entries in cells which are not meant for data entry please
Hi and thanks very much. You can go to the cell properties and make sure the cell is locked and then protect the sheet. I show you how to do this in this training: ua-cam.com/video/NXNA2uyCyJo/v-deo.html
I hope this helps and thanks so much.
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
Hello sir thank u so much:
Sir can I make a video on Excel that has the following features:
1.where we can make automatic invoice like above.
2.where items automatically deduct in stock sheet.
3. Where we will write hsn code of item and all the details of that item will automatically be showed.
I mean to say that it must be like an application that comes on net.
Yes sure you can do all of that, No problem at all. IF you need help with this, feel free to request help in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 50,000 Members who would love to help you with this. Thanks so much.
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
Nice work. Keep it up😊
Cam On Em :)
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☺️
Good day Randy, as i was doimg the InvoiceMacros, the address 1 and 2 os not filling up and there is this "Yellow arrow key pointing towards Private Sub Worksheet_SelectionChange (ByVal Target As Range) " what does that mean?
Hi and thanks that means there is some issue with the selection change macro.
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.
You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount
Hi Randy,
Your video tutorial was excellent and was very simple to understand
in min 44:15
If LastItemRow < 8 Then GoTo Noitems
popup message error when Continue Run *Compile Error: Label Not Defined*
can you help be to Solve it And This all code for this part
'Add/Update Invoice Items
LastItemRow = .Range("D27").End(xlUp).Row 'Last Invoice Item Row
If LastItemRow < 8 Then GoTo Noitems
For ItemRow = 8 To LastItemRow
If .Range("I" & ItemRow).Value Empty Then 'existing Row
InvItemRow = .Range("I" & ItemRow).Value
Else 'New Row
InvItemRow = Sheet3.Range("A9999").End(xlUp).Row + 1 'Fist AvailRow
Sheet3.Range("A" & InvItemRow).Value = .Range("H1").Value 'Invoice#
.Range("I" & ItemRow).Value = InvItemRow 'Invoice Item Row
Sheet3.Range("G" & InvItemRow).Value = "=Row()" 'Add Row#
End If
Hi and thanks for your comment. You will want to add "NoItems:" before the macro ends.
I hope this helps and thanks so much.
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.
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! 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 UA-cam 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
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
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: ua-cam.com/video/9biCBLwEngM/v-deo.html
I hope this helps and 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!
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.
it's very helpful-thank sir
For sure, you are very welcome Shekh
Very nice explanation .please share this sample template 😊
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
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.
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.
Very Useful,
It would great, If you could provide delete invoice item event, Can you assist me that same..
Hi and thanks so much for your comment. When deleting an invoice item you would just have to delete the original database item based on the database row. I am teaching full Invoicing features in my Mentorship Program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
Hi Randy, I stumbled on your video and it's amazing. I am half way through following along building this. I think I need help making the tool that I am envisioning though. Can you tell me what's the best way to find someone like you to develop a quoting tool/invoice tool that is customized to my needs? If you are interested, let me know. Thanks!
Hi James, thanks so much and glad you love the training. The best way would be to write up a detailed scope of your requirements then email them to me along with your budget. I can then forward it to a qualified developer. Randy@ExcelForFreelancers.com
I hope this helps and thanks so much.
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.
Hi Randy can you start adding a small part at the beginning where you show the finished product's functionalities. I find myself having to scroll through the video to see if certain methods are included
HI Saul, thanks for your comment. I do that mostly now with my newer videos, where I use a sample workbook to show all the features, before closing it and working on a blank one. Make sure to check out the POS With Inventory video launching in 14 hours right here: ua-cam.com/video/SbjBgqzbA3w/v-deo.html
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
This is a great tutorial. Thank you very much.
For sure, you are very welcome Jan. I am happy to help and share. I have a brand new Invoice from scratch coming out next week which will include Installment payments. Thank you for your Likes, Shares & Comments. It really helps.
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.
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.
Nice tutorial, thanks
Thank you so very much, I really appreciate that.
Another great lesson Randy, thanks!
Thank you so very much, I really appreciate that Rob and always appreciate your help and support.
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
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 UA-cam. 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.
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
Hi, nice work but is it possible that the formulas you used don't work in Excel V2021? I'm also working on a Mac. Thx :)
Hi and thanks the formulas should work regardless of the version of Excel, however in some language packs or regional settings you may have to make adjustments to the formulas. 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 all,
Thank you all for the opportunity to learn and be able to produce a worthwhile product.
I am a 73 year old and have only taken up Excel in the last 15 months to stimulate the brain and fulfill my fascination with VBA.
I have made and converted Randy's invoice to a service invoice for my son who is a fiberglass caravan and motor home repairer.
I have the invoice up and running with a number of extra requirements in the sales: Insurance - Customer area.
My question to you is: To keep invoice rows contained to the least number required for a given quote/invoice, is it possible to add a VBA formula that can automatically increase rows and formulas
as required and then when the invoice is saved revert back to the original size invoice.
I have managed to insert a manual solution with a button but if there is a solution to my request can you advise me where I may find such information.
Many thanks to you all
Hi Ian, thanks so much. I really appreciate your comments. It is a great question for sure. What you can do is create a Shape-based, floating footer, which will be positioned based on the last row of content. This is what I have done for the Invoice that I am designing in the Accounting Application in our Mentorship program. You can find a picture of that Invoice sample here: www.dropbox.com/s/cu61b33iq4rxk1n/Invoice_SS.jpg?dl=0
More information on our Mentorship Program here: bit.ly/MentorProgram_YTComment
I hope this helps and thanks so much
@@ExcelForFreelancers Thank you for your reply, I look forward to seeing your application of the floating footer and trying to use it in my invoice.
Meanwhile I will keep on learning more VBA to satisfy my fascination with Excel
Thanks so much Ian. :)