Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using the invoice template

Using the invoice template

ResolvedVersion 2003

Mon 23 Mar 2009, 16:39 Delegate 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:57 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

Using the invoice template

Using the invoice template

RE: Using the invoice template

Excel articles

Excel tip:

Create Equations in Excel 2010