Hi,
I have a formula in cell B5 of the Invoice Template sheet for the Maximum Invoice Number from the Invoice List sheet. This is intended so the next new invoice will be that number + 1.
When running the code by clicking the shape 'Save / Update Invoice' it removes the formula and the next new number is not the highest invoice + 1. In the examples listed it should be Invoice 1018.
Can someone please help?
Thank you
Guessing the problem is because of these lines:
Here you are setting the value of cell B5 to the value of the variable invno plus one. Hence you over-write the formula in B5 with a fixed value.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes that does seem like where the issue is. How can the new invoice be the next higher number?
Can this be done so that cell B5 does not get over written?
Well, the formula in cell B5 returns the maximum invoice used according to the Invoice List. So, logically, it can't be both the maximum invoice number used AND the next invoice number to be used.
Seems like you need to have two cells if you want to display and/or use two different numbers.
Ultimately I would like the new invoice to be the next higher invoice number. Perhaps I am going about this wrong.
In the code what determines the new invoice number?
I found a way to do it. Maybe it is not proper but seems to work.
cell B4 I have the formula: =MAX(Invoice_ID)
cell B5 gets the next new number when running the code.
Please Login or Register to view this content.
You're welcome. Thanks for the rep.
Always best if you can work it out for yourself. Then you have a better understanding of what's going on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks