Hi there! I am trying to create a code that will generate a new invoice number on my worksheet. I have cell H4 with a vendor number that is four digits long. I would like the invoice number to include the vendor number somehow 5647-78 for example. Could you please help me?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
I tried the code. I got an error message. So i tried removing the first part of the code and i was able to get a number (vendor-01) but the 01 is not changing as i create a new invoice.
When i change the vendor and run the macro, it gives me the same thing (vendor -01). How can i make it keep counting or simply adding a 1 to the previous invoice?
When i change the vendor and run the macro, it gives me the same thing (vendor -01). How can i make it keep counting or simply adding a 1 to the previous invoice?
Upvote
0
Excel Facts
Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,140
- Office Version
- 365
- Platform
- Windows
What exactly did you remove?
What does your current code look like?
Please put the code back to where I had it, and let me know the following:
- What is in cells HJ3 and H4 to start?
- What is the exact error message you are receiving?
- If you click on the "Debug" option when you get the error message, what line of code does it highlight?
Upvote
0
