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
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,171
- 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
Similar threads
- Question
