How do I create an autonumber similar to Access in Excel?
 

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

How do I create an autonumber similar to Access in Excel?
 

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

How do I create an autonumber similar to Access in Excel?
 

See http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DKS" wrote in message
...
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