Excel VBA - Clear Invoice and Automate Next Invoice Number

[@CandiAnne]

This has got to be the best instructional series I've ever found on KZbin ... Thank you SOOOO much

[@Mitzi712]

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!

[@gabz1989a]

your videos are not getting enough recognition! I know nothing about VBA and I am learning so much

[@chrisespitia537]

This guy. This guy is the bee's knees. I hope the world is one day full of people as kind as him.

[@ChesterTugwell]

*****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

[@sarahbaskerville4615]

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!

[@ChesterTugwell]

Sarah, hope you get your head around it and save yourself pennies on an invoice app. Thanks for your comment.

[@timwest9300]

Hello Sir Thank you for your great videos , very well informed I appreciate your time and efforts to help us

[@ttvKernal]

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

[@ChesterTugwell]

You are welcome

[@balabalan1846]

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

[@Info-God]

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).

[@allyssalopez2125]

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!

[@cd5380]

excellent work and very helpful. you are an amazing source of information and help. thanks so much!!!

[@DraganTanevski-bq2uf]

It works perfect. Thank you. Question - how to make next invoice number to have leading zero in front of the invoice number?

[@muhammedaslam5937]

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 😢

[@ikspeel]

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?

[@landryilunga1818]

is there a way to have a dropdown text on the list like "Select an option" when it is empty?

[@mohammedakhtar5203]

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

[@azragamieldien2342]

Im stuck on the clear contents part.

[@mammapineapple6243]

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 😢

[@kathleenrussell3422]

Have you happened to figure out a solution for this? I am getting the same error..

[@harrydhinjan7446]

Hi did you find any solution for this i am also getting the same error

[@leonzhou3346]

A great video！ Thank you！ What if there is no email. how to clear return value and make the cell blank?

[@fareedquraishi]

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

[@francesfletcher9180]

Thanks again, Chester! Great tutorial!

[@mituldesai7918]

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

[@RedTDA]

i need help doing this with merged cells without losing my formulas or data validations

[@HannifMala]

Thank You Very Much! Learned and Applied... God Bless!

[@rahuljangidfitness]

this video is so useful to make an automatice invoice.

[@abidj.guerrero1992]

A perfect work, you rock! Thanks man.

[@ChesterTugwell]

😎

[@zeeshanrashid495]

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.

[@jhonnybajaj90]

Hi, need help. Did you find a solution to your issue? I have been facing the same issue

[@ImranKhan-qw7ge]

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

[@Alan-1970]

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?

[@chunking5447]

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!

[@bp_hr]

Thats happening to me also. I tried different clearxxx but it deletes everything or nothing

[@7073cain]

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.

[@Alan-1970]

@@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

[@sweetaliena]

How do you increment an alphanumerical invoice number?

[@MarkBlakeman-mt8mb]

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

[@officialmikedl]

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!

[@polyvspavel]

same have you sorted it?

[@jigarparikh4417]

dear @ChesterTugwell sir, my invoice number is showing only 1 after running vba, rest everything is fine. Please help

[@harrydhinjan7446]

Hi im getting this error Run-time error '1004': we can't do that to a merge cell.

[@catcharella1961]

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!!!

[@wayneedmondson1065]

Great! Thanks Chester. Thumbs up!!

[@mattkriese7170]

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!

[@rosieval6994]

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

[@motazyamin]

it is great series >>>Thanks

[@coolraghumiskin09]

It is possible to create an alphanumeric digit/Number.please

[@blessedrukundo5805]

I can't get through this part somebody help me,most especially the MsgBox code part , whenever I run ,a compile error displays.

[@alekyeremeef1152]

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?

[@anthonymounts3567]

I'm having a problem with its saying it can't do it to a merged cell. Is there a way to fix this?

[@tonamiali]

Somehow the (Save as PDF, and Save as .xlsx) doesn't work in my macbook.

[@amanuelyohannes7151]

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.

[@7073cain]

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.

[@janaknagwani3690]

Really helpful please add feature in which we can maintain and delete the records as well customer wise

[@tomchmiel9947]

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

[@mardarose1]

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

[@antoniyayotsova5473]

I want to know too

[@krmotionexcel]

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..........

[@Prasad-q5x]

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.

[@coolag74]

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

[@affandimajid]

i found your valuable video and i learned a lot from it. Thank you so much

[@arcaarya1787]

Thank you so much sir 🔥🔥🔥

[@karishmakhorasi]

Hello Sir I am using this formula =IFNA(VLOOKUP($B$9,Cust_list,2,0),"") but it is coming #Name?. How to solve this

[@DM.10]

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. 🙏

[@rahuljangidfitness]

Did you find how to add alphabets . reply

[@rahuljangidfitness]

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.

[@sooengui]

I have the same issue here

[@SaberSediqi-z8e]

Did you find the solution?

[@jamesselmon8104]

This is exactly what I have been looking for. Can I purchase this template from you?

[@lovelymusic5672]

How to add a alphabet before the invoice number?

[@powerflex500]

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.

[@createistudyo1055]

Thank you for this ❤️

[@maxkollek8138]

Great! Thanks a lot mate‘

[@tanianethercote8194]

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

[@fazwansulaiman]

double click on module 1

[@KyprianouSpyros]

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?

[@harrydhinjan7446]

hi did you find any solution im also getting same error because i wanna use merged cells in my sheet.

[@alekyeremeef1152]

Oh no that clearContent erased all formulas that i had done and saved it, there was no undo option. I'm using excel 2007

[@larissahawkins5857]

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???

[@muhammedalameenakoo630]

U supposed to enable the macros anyways

[@ehanusman9462]

How to use multiple VLOOK multiple time in a cell, Like City,provine, postal code

[@This_Planet]

fabulous

[@coolraghumiskin09]

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. . ???

[@rahuljangidfitness]

did you find how to add alphabets so reply

[@AndoGamingTv]

❤❤

[@gabz1989a]

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

[@Tate.Central]

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