Thread: How do you add 1 to an invoice number in Excel. Formula for this?
View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
  
Posts: 271
Default How do you add 1 to an invoice number in Excel. Formula for th
This works perfect, add a (me.save) on the end and it makes a perfect
template for all my invoices. Thank you so much. It's hard to do this coming
from Lotus, but I'm slowly getting the hang of it. Thanks again!

"bhawane" wrote:


Simple solution ...

Private Sub Workbook_Open()
MyInv = Sheets("Sheet1").Range("A1").Value
MyInv = MyInv +1
Sheets("Sheet1").Range("A1") = MyInv
End Sub


--
bhawanePosted from http://www.pcreview.co.uk/ newsgroup access


Reply With QuoteReply With Quote