View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default increasing a cell value on each use


You might want to give this site a look.

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

HTH
Regards,
Howard

"dave" wrote in message
...
I want to have a rolling total on 1 cell...such as an invoice number, each
time I open a worksheet. Is there a way to do this?