sequential invoice numbering

  • Thread starter Thread starter Scott Davidson
  • Start date Start date
S

Scott Davidson

How do I formulate a cell to add one to the previous invoice# each
time the "xxxx" invoice file is opened. Please and thank you
 
Scott

You could add code to the workbook_open event, thus (to add this open the
VBE (Alt+F11) and right click on the ThisWorkbook entry for the file name.
Paste the code in the resultant window, close the VBE and save the workbook.
(Change the references accordingly)

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Scott

You could add code to the workbook_open event, thus (to add this open the
VBE (Alt+F11) and right click on the ThisWorkbook entry for the file name.
Paste the code in the resultant window, close the VBE and save the workbook.
(Change the references accordingly)

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("A1").Value =
Worksheets("Sheet1").Range("A1").Value + 1
End Sub
Click to expand...


I think I did as shown exept changed "A1"s to "J5"s (the cell that I
would like to have the invoice # in). changed security to accept the
macro but get a syntax error with the value= line highlited
thanks again
Scott
 
Scott

Did you put the two main lines of code on one line? (Outlook Express breaks
the line of text at 50 characters or so).

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
The codes given by Nick works fine if you use it the first
time. But if you do intend to save the invoice and open it
later. The invoice no. will increase as well.

I'm not sure and I maybe wrong.
 
Rick

You are correct. As far as I remember the Op wanted to increment the number
each time the workbook was opened. That's what the code does.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Nick thanks a million or two ,putting the code on one line worked
perfectly. you are truly skilled
Thanks again for your time
Scott
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuous Invoice Nos. 3
Numbering Excel template 2
template creates invoice - how to create summary worksheet? 13
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
VBAscript for data matching excels 0
How do I set up excel invoice t/plate with sequential numbering 1
NAME SHEETS sequentially 4
Auto Number 1

Back
Top