Invoice Numbering
 

How can I set up on invoice on excel to where I get automatic sequential
numbering each time the spreadsheet is opened?

Amber,
A simple way would be to use something like this, call it form the workbook
open event.
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1

For other ways to do this or if this is going to be used in a temple have a
look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Amber" wrote in message
...
How can I set up on invoice on excel to where I get automatic sequential
numbering each time the spreadsheet is opened?

Amber: Try the methods used in this workbook (or just use the workbook).
http://www.officearticles.com/downloads/invoices.zip
************
Anne Troy
www.OfficeArticles.com

"Amber" wrote in message
...
How can I set up on invoice on excel to where I get automatic sequential
numbering each time the spreadsheet is opened?

Amber

See John McGimpsey's site for help on this.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 13:31:09 -0700, "Amber"
wrote:

How can I set up on invoice on excel to where I get automatic sequential
numbering each time the spreadsheet is opened?

Invoice Numbering
 

I have tried link below - Mcgimpsey? and got dead end??

Is it just down for moment?

"Paul B" wrote:

Amber,
A simple way would be to use something like this, call it form the workbook
open event.
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1

For other ways to do this or if this is going to be used in a temple have a
look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Amber" wrote in message
...
How can I set up on invoice on excel to where I get automatic sequential
numbering each time the spreadsheet is opened?