Thank you so much for this video! It helped me a ton with creating automated invoices for my home business. I use Excel on a MacBook, and I ran into a few challenges since the ribbon layout is a bit different, and my Excel skills are pretty basic. But your clear instructions made it so much easier to follow. I really appreciate the time and effort you put into making this tutorial-it's been a game changer for my workflow! I’m only on lesson 3 of the 6 lessons, but fingers crossed I can finish the whole series! I did have an issue clearing out the client name and message text box, so I just removed them, and the macros still worked. It’s not exactly as you designed, but it’s better than nothing. Thank you again... now moving on to lesson 4!
Becoming more familiar. I'm playingyour videos over and over, stopping and starting... So useful. I'm doing this instead of paying for an invoice app. Using a lot of grey matter but even I csn understand. Thank you so much!
*****If you are having trouble with your logo being deleted use this code:***** For Each shp In ActiveSheet.Shapes If shp.Type msoPicture Then shp.Delete Next shp
Thanks for your tutorial it has been amazing as I am just starting out in my business, it has helped me alot I can not imagine now not using this excel spreedsheet
You will be in dis-belief what VBA-Excel can do. I'm advsbced/expert and I am just thrilled of what I did. No other software can do such amazing things (of course C, C++ are at the core of everything but it takes huge time, many people and organization to create a tool like MS Excel).
beautiful video hopefully you can help If I have a large order with more than a hundred different items, how should I add the line with s/n product description, QTY, unit price at the top of page 2 of the invoice? Is there a way for this to happen automatically?
Sir please reply me I have question that in add to record option how to prevent duplication of record as if we press that twice it should through a error some what like that please And thankyou It was one of the best playlist of excel I've ever watched and was a lot useful
Hi Chester! I am stuck in IFNA function (6:49) of this video. Not sure why it doesn't work - an error message #NAME? pops up and cannot carry on! Please help!
Hi. Thank you so much for these videos. But I'm having an issue. When i play it, it keeps telling me Run-time error '1004': We can't do that too a merged cell. When i click debug it referenced the clear contents line. Please help 😢
Hi there! I'm a newbie and I'm trying to use python and it's libraries as my go-to. I was wondering if you had any documentation for this or any of your other videos in this playlist? I really appreciated the vid so thank you!
Thanks for the great content. I’m wondering how to avoid the problem of starting the new invoice without ripping out of the formulae? I mean the sum function in the description box. Thanks!
Try not including the column with the formula (such as the VLOOKUP one, e.g) in the ClearContents command, just clear Column B or whatever column the formula refers to.
@@7073cain Exactly! I found this out the hard way. I originally put all my columns to cleat content and it deleted all my formulas. I'm pulling all my info from a price sheet using part numbers. If you just clear the part number column then it will clear your invoice without messing with your formulas
Dear Mr Chester Tugwell thank you so much for such a informative video . I replicated your sheet and I am having problem when i do clear invoice contents. When i do ".clearcontents", the formulae in the invoice sheet disappear. The sum formulae i mean. For every new invoice , i have to put sum formulae manually. Please help me in automate my sheet. I would be very thankful to you.
Thanks Chester, I would like to add the Service Usage & Discount History Graphical View to the Invoice with Recurring Invoicing System can you please share a video linking the same to the Invoice
Thank you for this amazing explanation. When I run this it says "Compile error: Invalid use of property" and highlights the first line which is "sub CreateNewInvoice()". How can I fix this? Thank you in advance
Love your videos! They have been extremely helpful! But I'm having a problem with the "Create New Invoice" and the new invoice number, I've followed your video, but when it creates a new invoice it is creating invoice number 1 over and over. If my first invoice is 10001 the next invoice should be 10002, but it changes it to 1 each time I hit the Create New Invoice macro, I can't figure it out?
Thank you for the videos. It's priceless! Quick question I am getting an error "We can't do that to a merged call." There could be a work around but I am concerned how it will affect the previous settings. Thank you.
Make sure all the columns are included in the Macro line where you did the ClearContents. For example, My merged cell spanned columns A to D, instead of A to C so error was fixed when I made that change.
your videos are excellent- on the create new invoice button when it opens and new invoice the customer name disappears but the remainder of their details turns to a date and i cant work out why despite trying the IFNA function can you help
Great Chester, I am following your video and practicing but I am facing problem at "StartNewInvoice()" VBA Code, against a cell associated with Customer Name. where it says "we can't do that to merged cell" Runtime error 1004. Request your advice
Hi Chester! This video has helped me a lot! Only one issue, my invoice number does change when I click the macro button, but the message box always says "your next invoice is 1" haha. Please help me with this issue! Love your videos by the way!
Dear sir.... thank you so much for your beautiful and sophisticated method of building the invoice but I have a requirement. After pressing the "Start New Inv" button, that button will be hidden or not operate until the next session. what is the procedure?.please make a video sir on that topic.
I love your videos, and I'm learning a lot, but when I make the next invoice number module code, and try to run it, it gives me an error, telling me that can't be done because cells are merged What do I do? Please help
this has made me feel like I know what I'm doing when using excel, even though I have no clue!! Thanks. HOWEVER I am having difficulty when I do clear invoice contents the ".clearcontents" clears the quantity and unit price numbers aswell as the formulas and I have to reinstate formulas every new invoice. what is the code to just clear the numerical entries and not the formula sums???? PLEASE HELP!!!
is there a way to generate an invoice with sequential numbers for all the customers at the same time? like monthly group invoices - I'm trying to avoid doing one customer at a time :D
Sir please help me... I was try taxable invoice for Grocery shop...... If I was make invoice and click button "Go" , save this in invoice move in second sheet automatically after click button......... How to possible this macro.........I need invoice sheet invoice number wise set..........
Hi ... new to modules ... when I insert for Module 2, the visual basic for module 1 disappears...eek...what have i done? Also new to youtube...lol...wondering how I'll know if you answer...oh dear...not my night
Please help. I mean how should I add a new invoice number if it looks like this: NPJ/001/2023. I want to add 1 which is NPJ/002/2023???? Please reply. 🙏
If i want to add some alphabate in my invoice no. like, GHH/2023-24/005 and next invoice like , GHH/2023-24/006 and next is , GHH/2023-24/007 . Mean i want to increage only last digite of my Number . So what code I have to right ? Reply in comment.
HELP, please help me. I created my boss a template that increments the invoice number by watching your video but he/we mistakenly hit "security warning macros have been disabled, enable content" at the top of one of the invoices we were working on and now for the life of me, i can not figure out how to fix it. I went to options and trust then macros and disable w/VBA notifications also tried w/o but neither worked. What am I doing wrong???
When I use your formula to clear the #N/A in B10, it gives me #NAME? It doesn't clear the cell like in your video. Any help or suggestions would be appreciated. Thank you.
Fantastic! amazing can you make a video on creating a unique customer ID that is alphanumerical. which can be used as a invoice number which increment by 1 in sequence every times we process the invoices for the particular customer
2 questions from my side. When you save to excel, is there a way to keep a button? I would like to keep the save to PDF button on the save to excel version, as I would like to still modify the quotation and then save the final as PDF. second question I have the following, which keeps my logo and removed the buttons when you save, but I inserted my banking details at the bottom in a shape box and I tried adding a png at the bottom, but when I save it as excel, it removed the bottom part, this, however, doesn't happen when I save to pdf, it retains the detail at the bottom Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type msoPicture Then shp.Delete 'This line is modified so that is doesn't delete the logo Next shp
This has got to be the best instructional series I've ever found on UA-cam ... Thank you SOOOO much
Thank you so much for this video! It helped me a ton with creating automated invoices for my home business. I use Excel on a MacBook, and I ran into a few challenges since the ribbon layout is a bit different, and my Excel skills are pretty basic. But your clear instructions made it so much easier to follow. I really appreciate the time and effort you put into making this tutorial-it's been a game changer for my workflow! I’m only on lesson 3 of the 6 lessons, but fingers crossed I can finish the whole series! I did have an issue clearing out the client name and message text box, so I just removed them, and the macros still worked. It’s not exactly as you designed, but it’s better than nothing. Thank you again... now moving on to lesson 4!
your videos are not getting enough recognition! I know nothing about VBA and I am learning so much
This guy. This guy is the bee's knees. I hope the world is one day full of people as kind as him.
Hello Sir Thank you for your great videos , very well informed I appreciate your time and efforts to help us
Becoming more familiar. I'm playingyour videos over and over, stopping and starting... So useful. I'm doing this instead of paying for an invoice app. Using a lot of grey matter but even I csn understand. Thank you so much!
Sarah, hope you get your head around it and save yourself pennies on an invoice app. Thanks for your comment.
*****If you are having trouble with your logo being deleted use this code:*****
For Each shp In ActiveSheet.Shapes
If shp.Type msoPicture Then shp.Delete
Next shp
Thanks for your tutorial it has been amazing as I am just starting out in my business, it has helped me alot I can not imagine now not using this excel spreedsheet
You are welcome
Best explanation by far for us totally new to the software, thanks for your ti man, really looking forward to learning how to make so
You will be in dis-belief what VBA-Excel can do. I'm advsbced/expert and I am just thrilled of what I did. No other software can do such amazing things (of course C, C++ are at the core of everything but it takes huge time, many people and organization to create a tool like MS Excel).
excellent work and very helpful. you are an amazing source of information and help. thanks so much!!!
It works perfect. Thank you. Question - how to make next invoice number to have leading zero in front of the invoice number?
beautiful video
hopefully you can help
If I have a large order with more than a hundred different items, how should I add the line with s/n product description, QTY, unit price at the top of page 2 of the invoice? Is there a way for this to happen automatically?
Sir please reply me I have question that in add to record option how to prevent duplication of record as if we press that twice it should through a error some what like that please
And thankyou It was one of the best playlist of excel I've ever watched and was a lot useful
Hi Chester! I am stuck in IFNA function (6:49) of this video. Not sure why it doesn't work - an error message #NAME? pops up and cannot carry on! Please help!
Hi. Thank you so much for these videos. But I'm having an issue. When i play it, it keeps telling me
Run-time error '1004':
We can't do that too a merged cell.
When i click debug it referenced the clear contents line. Please help 😢
Have you happened to figure out a solution for this? I am getting the same error..
Hi did you find any solution for this i am also getting the same error
Thank You Very Much! Learned and Applied... God Bless!
Hi there! I'm a newbie and I'm trying to use python and it's libraries as my go-to. I was wondering if you had any documentation for this or any of your other videos in this playlist? I really appreciated the vid so thank you!
Thanks for the great content. I’m wondering how to avoid the problem of starting the new invoice without ripping out of the formulae? I mean the sum function in the description box. Thanks!
Thats happening to me also. I tried different clearxxx but it deletes everything or nothing
Try not including the column with the formula (such as the VLOOKUP one, e.g) in the ClearContents command, just clear Column B or whatever column the formula refers to.
@@7073cain Exactly! I found this out the hard way. I originally put all my columns to cleat content and it deleted all my formulas. I'm pulling all my info from a price sheet using part numbers. If you just clear the part number column then it will clear your invoice without messing with your formulas
A great video！ Thank you！
What if there is no email. how to clear return value and make the cell blank?
Great! Thanks Chester. Thumbs up!!
Dear Mr Chester Tugwell thank you so much for such a informative video . I replicated your sheet and I am having problem when i do clear invoice contents. When i do ".clearcontents", the formulae in the invoice sheet disappear. The sum formulae i mean. For every new invoice , i have to put sum formulae manually. Please help me in automate my sheet. I would be very thankful to you.
Hi, need help. Did you find a solution to your issue? I have been facing the same issue
Could please help me on the range to clear when opening a new invoice, for mine it’s showing as we can’t do clear content for merged cell 😢
Thanks again, Chester! Great tutorial!
is there a way to have a dropdown text on the list like "Select an option" when it is empty?
Thanks Chester, I would like to add the Service Usage & Discount History Graphical View to the Invoice with Recurring Invoicing System can you please share a video linking the same to the Invoice
Thank you for this amazing explanation. When I run this it says "Compile error: Invalid use of property" and highlights the first line which is "sub CreateNewInvoice()". How can I fix this? Thank you in advance
Love your videos! They have been extremely helpful! But I'm having a problem with the "Create New Invoice" and the new invoice number, I've followed your video, but when it creates a new invoice it is creating invoice number 1 over and over. If my first invoice is 10001 the next invoice should be 10002, but it changes it to 1 each time I hit the Create New Invoice macro, I can't figure it out?
Thank you for the videos. It's priceless! Quick question I am getting an error "We can't do that to a merged call." There could be a work around but I am concerned how it will affect the previous settings.
Thank you.
Make sure all the columns are included in the Macro line where you did the ClearContents. For example, My merged cell spanned columns A to D, instead of A to C so error was fixed when I made that change.
this video is so useful to make an automatice invoice.
it is great series >>>Thanks
your videos are excellent- on the create new invoice button when it opens and new invoice the customer name disappears but the remainder of their details turns to a date and i cant work out why despite trying the IFNA function can you help
Im stuck on the clear contents part.
Great Chester, I am following your video and practicing but I am facing problem at "StartNewInvoice()" VBA Code, against a cell associated with Customer Name. where it says "we can't do that to merged cell" Runtime error 1004.
Request your advice
Hi Chester! This video has helped me a lot! Only one issue, my invoice number does change when I click the macro button, but the message box always says "your next invoice is 1" haha. Please help me with this issue! Love your videos by the way!
same have you sorted it?
A perfect work, you rock! Thanks man.
😎
Dear sir.... thank you so much for your beautiful and sophisticated method of building the invoice but I have a requirement. After pressing the "Start New Inv" button, that button will be hidden or not operate until the next session. what is the procedure?.please make a video sir on that topic.
i need help doing this with merged cells without losing my formulas or data validations
Excellent...
I successfully made an auto receipt number for my form through your tutorial. If I have any problem in VBA can you help me?
Thanks
I love your videos, and I'm learning a lot, but when I make the next invoice number module code, and try to run it, it gives me an error, telling me that can't be done because cells are merged
What do I do? Please help
Really helpful
please add feature in which we can maintain and delete the records as well customer wise
this has made me feel like I know what I'm doing when using excel, even though I have no clue!! Thanks. HOWEVER I am having difficulty when I do clear invoice contents the ".clearcontents" clears the quantity and unit price numbers aswell as the formulas and I have to reinstate formulas every new invoice. what is the code to just clear the numerical entries and not the formula sums???? PLEASE HELP!!!
How do you increment an alphanumerical invoice number?
dear @ChesterTugwell sir, my invoice number is showing only 1 after running vba, rest everything is fine. Please help
I'm having a problem with its saying it can't do it to a merged cell. Is there a way to fix this?
It is possible to create an alphanumeric digit/Number.please
what if you accidently click button and add same record 2-3 times, is there a logic that can prevent you from adding duplicated records?
is there a way to generate an invoice with sequential numbers for all the customers at the same time? like monthly group invoices - I'm trying to avoid doing one customer at a time :D
This is exactly what I have been looking for. Can I purchase this template from you?
Hi, my invoice has a letter in the front and then a number, how do i write a macro to keep the letter but change the number only...thank you
I want to know too
Thank you so much sir
🔥🔥🔥
Hi im getting this error
Run-time error '1004':
we can't do that to a merge cell.
i found your valuable video and i learned a lot from it. Thank you so much
Sir please help me...
I was try taxable invoice for Grocery shop......
If I was make invoice and click button "Go" , save this in invoice move in second sheet automatically after click button.........
How to possible this macro.........I need invoice sheet invoice number wise set..........
I can't get through this part somebody help me,most especially the MsgBox code part , whenever I run ,a compile error displays.
Somehow the (Save as PDF, and Save as .xlsx) doesn't work in my macbook.
Great! Thanks a lot mate‘
Hi ... new to modules ... when I insert for Module 2, the visual basic for module 1 disappears...eek...what have i done? Also new to youtube...lol...wondering how I'll know if you answer...oh dear...not my night
double click on module 1
Hello Sir I am using this formula =IFNA(VLOOKUP($B$9,Cust_list,2,0),"") but it is coming #Name?. How to solve this
How to add a alphabet before the invoice number?
Please help. I mean how should I add a new invoice number if it looks like this: NPJ/001/2023. I want to add 1 which is NPJ/002/2023???? Please reply. 🙏
Did you find how to add alphabets . reply
If i want to add some alphabate in my invoice no. like, GHH/2023-24/005 and next invoice like , GHH/2023-24/006 and next is , GHH/2023-24/007 . Mean i want to increage only last digite of my Number . So what code I have to right ? Reply in comment.
I have the same issue here
Did you find the solution?
Thank you for this ❤️
How to use multiple VLOOK multiple time in a cell, Like City,provine, postal code
HELP, please help me. I created my boss a template that increments the invoice number by watching your video but he/we mistakenly hit "security warning macros have been disabled, enable content" at the top of one of the invoices we were working on and now for the life of me, i can not figure out how to fix it. I went to options and trust then macros and disable w/VBA notifications also tried w/o but neither worked. What am I doing wrong???
U supposed to enable the macros anyways
Oh no that clearContent erased all formulas that i had done and saved it, there was no undo option. I'm using excel 2007
fabulous
guys get this message when i run it
Run-tim error '1004':
we can't do that to a merge cell.
how can i fix this?
hi did you find any solution im also getting same error because i wanna use merged cells in my sheet.
Want Alphanumeric Serial
SHP/22-23/0001
SHP/22-23/0002
Only serial no. Has to change in this context
How to do this is that possible. . ???
did you find how to add alphabets so reply
When I use your formula to clear the #N/A in B10, it gives me #NAME? It doesn't clear the cell like in your video. Any help or suggestions would be appreciated. Thank you.
❤❤
Fantastic! amazing
can you make a video on creating a unique customer ID that is alphanumerical. which can be used as a invoice number which increment by 1 in sequence every times we process the invoices for the particular customer
2 questions from my side.
When you save to excel, is there a way to keep a button? I would like to keep the save to PDF button on the save to excel version, as I would like to still modify the quotation and then save the final as PDF.
second question
I have the following, which keeps my logo and removed the buttons when you save, but I inserted my banking details at the bottom in a shape box and I tried adding a png at the bottom, but when I save it as excel, it removed the bottom part, this, however, doesn't happen when I save to pdf, it retains the detail at the bottom
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
If shp.Type msoPicture Then shp.Delete 'This line is modified so that is doesn't delete the logo
Next shp