You need to store the "next available number" at a secure place in your .xls
(say another sheet with all your parameters).

Every time you generate an invoice you need to assign the next available
number to the new invoice; and then increment your counter by 1 and save the
new "next available number" so that you have it when you create a new invoice.

Hope this helps.

"awebb" wrote:

I need to be able to create an autonumber on an invoice in a Spreadsheet
using MS Excel 2003.
--
Netty