How do you set a cell to increase numerical sequence?
 

I am trying to set a cell in Excell to automatically increase in value
everytime I open the worksheet. For example, it is an invoice, and I want the
invoice number to increase when I open the worksheet for a new invoice.

How do you set a cell to increase numerical sequence?
 

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

--


Regards,


Peo Sjoblom


"Nan" wrote in message
...
I am trying to set a cell in Excell to automatically increase in value
everytime I open the worksheet. For example, it is an invoice, and I want
the
invoice number to increase when I open the worksheet for a new invoice.

How do you set a cell to increase numerical sequence?
 

See this:

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

--
Biff
Microsoft Excel MVP


"Nan" wrote in message
...
I am trying to set a cell in Excell to automatically increase in value
everytime I open the worksheet. For example, it is an invoice, and I want
the
invoice number to increase when I open the worksheet for a new invoice.