Posted to microsoft.public.excel.misc
|
|
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
|