Thread: How do you add 1 to an invoice number in Excel. Formula for this?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
  
Posts: 221
Default How do you add 1 to an invoice number in Excel. Formula for this?
This wil probably help you a lot, Susan:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=348

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Susan" wrote in message
...
I'm trying to set up my own invoices. What I can't seem to do is create a
cell for my invoice number, that every time I open the file it adds 1
(0ne)
to the invoice number. Does anyone have a macro - formula for doing this?
Thank you


Reply With QuoteReply With Quote