Add 1 to a cell
 

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

Add 1 to a cell
 

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

--
__________________________________
HTH

Bob

"Big G" wrote in message
...
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

Add 1 to a cell
 

See this:

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

--
Biff
Microsoft Excel MVP


"Big G" wrote in message
...
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