View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_3_] Peo Sjoblom[_3_] is offline
external usenet poster
 
Posts: 136
Default 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.