I want to set up a running invoice number.
like the date function each time you open the template a new date appears.
eg if i start with an invoice number say 1000 the next invoice i start will
show 1001
I am using excel 2000
thank you