G Guest Sep 10, 2005 #1 How can I set up a serial number cell such as an invoice number that automatically increases by one each time I need a new invoice?
How can I set up a serial number cell such as an invoice number that automatically increases by one each time I need a new invoice?
R Richard Buttrey Sep 10, 2005 #3 How can I set up a serial number cell such as an invoice number that automatically increases by one each time I need a new invoice? Click to expand... How are you setting up a new invoice? Are you for instance using a VBA macro attached to a button which opens up an invoice template? If so you could hold the invoice number variable in a named cell, and simply increase it with an extra line of code in the macro. e.g. Range("InvoiceNoVariable")=Range("InvoiceNoVariable") + 1 HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
How can I set up a serial number cell such as an invoice number that automatically increases by one each time I need a new invoice? Click to expand... How are you setting up a new invoice? Are you for instance using a VBA macro attached to a button which opens up an invoice template? If so you could hold the invoice number variable in a named cell, and simply increase it with an extra line of code in the macro. e.g. Range("InvoiceNoVariable")=Range("InvoiceNoVariable") + 1 HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
