*****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
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!
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).
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
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?
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?
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!
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!
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 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.
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
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!!!
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
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.
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
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
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
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 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 ... 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
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..........
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.
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. 🙏
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.
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???
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
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.
*****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
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.
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
It works perfect. Thank you. Question - how to make next invoice number to have leading zero in front of the invoice number?
excellent work and very helpful. you are an amazing source of information and help. thanks so much!!!
this video is so useful to make an automatice invoice.
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).
A great video！ Thank you！
What if there is no email. how to clear return value and make the cell blank?
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
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?
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?
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!
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?
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
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
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.
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
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
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!!!
Thanks again, Chester! Great tutorial!
Thank You Very Much! Learned and Applied... God Bless!
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
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.
it is great series >>>Thanks
A perfect work, you rock! Thanks man.
😎
is there a way to have a dropdown text on the list like "Select an option" when it is empty?
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
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
Great! Thanks Chester. Thumbs up!!
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?
This is exactly what I have been looking for. Can I purchase this template from you?
Really helpful
please add feature in which we can maintain and delete the records as well customer wise
i need help doing this with merged cells without losing my formulas or data validations
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
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 😢
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
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!
Thank you so much sir
🔥🔥🔥
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
dear @ChesterTugwell sir, my invoice number is showing only 1 after running vba, rest everything is fine. Please help
How do you increment an alphanumerical invoice number?
It is possible to create an alphanumeric digit/Number.please
I'm having a problem with its saying it can't do it to a merged cell. Is there a way to fix this?
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..........
Great! Thanks a lot mate‘
Thank you for this ❤️
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
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?
fabulous
Hi im getting this error
Run-time error '1004':
we can't do that to a merge cell.
Hello Sir I am using this formula =IFNA(VLOOKUP($B$9,Cust_list,2,0),"") but it is coming #Name?. How to solve this
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
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.
Somehow the (Save as PDF, and Save as .xlsx) doesn't work in my macbook.
How to use multiple VLOOK multiple time in a cell, Like City,provine, postal code
Oh no that clearContent erased all formulas that i had done and saved it, there was no undo option. I'm using excel 2007
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
How to add a alphabet before the invoice number?
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
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.
i found your valuable video and i learned a lot from it. Thank you so much
Im stuck on the clear contents part.
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
❤❤
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