Add 1 to a cell

[Big G]

Hi,
I make Invoices in Excel and need a solution on following small problem:
When I open up a new Excel I want a cell called Invoicenumber to increment 1
to have a new Invoicenumber.
So if previous invoicenumber was 58 I want the new invoicenr to be 59.
I want this to happend automatic, i e it should be trigged by just opening a
new Excel, but how?
Can somebody help me?
Gunnar S

 

[Bob Phillips]

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

 

[T. Valko]

See this:

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