Macro to increment invoice number

P

Paul

Hi all,

I have a template that I use for invoices and would like to know how I can
get the invoice number to increment by one everytime I create a new invoice,
I know I have to enter the code into an autoexec macro but what would the
code be to check the last invoice used and then increment this one by 1.

Thanks in advance for any assistance

Paul
 
S

steve

Paul,

With the number in A1

Cells(1, 1) = Cells(1, 1) + 1

where the 1st 1 is the row number of the Invoice Number cell, and the
2nd 1 is the column number.
 

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

Auto increment a cell 14
how to make a cell value increment every time a new worksheet is o 1
Increment invoice number 1
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
Invoice Number duplicate Check 2
Snag in invoice generator. How to change the "series" 5
Invoice 1
How to Run a Macro From WB1 in WB2 Against WB2 5

Top