98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using the invoice template
Using the invoice template
Resolved · Low Priority · Version 2003
Mon 23 Mar 2009, 16:39Delegate Charlie said...
Charlie has attended:
Excel Intermediate course
Using the invoice template
How would you get it to drive individual invoice numbers
Mon 23 Mar 2009, 18:57Trainer Amanda said...
RE: Using the invoice template
Hello Charlie
Thank you for your question and welcome to the forum.
This is more complex than what it might sound, as Excel is automatically checking to see what the previous invoice number is; and then increasing that by 1 (I assume).
It may be possible to do this by creating a macro using the macro recorder; or it might have been programmed into the spreadsheet using VBA code (which is the most likely option).
Sorry I don't have an easy answer for you on this one.
Kind regards
Amanda
Mon 30 Mar 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
