Thread: Add 1 to a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Big G[_2_] Big G[_2_] is offline
external usenet poster
 
Posts: 3
Default 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