Help with a formula



I want to create a formula that will automatically increase a number
value by one each time new information is entered.
For example I have an invoice on sheet 1(cell A1 is the invoice #)
I would like that number to increase each time the template invoice is




3 possible options?

1. Check out the excel template INVOICE.XLT,
usually found at path:

C:\Program Files\Microsoft Office\Templates\Spreadsheet

This template has the option to generate unique sequential numbers.

2. Try :

where MVP Leo Heuser provides 2 subs

3. A non-macro way suggested by MVP Norman Harker previously (below):
From: Norman Harker ([email protected])
Subject: Re: invoice number macro
View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2001-08-21 04:52:34 PST

Hi Ruud!

For any given number of invoices the possibility of non-unique numbers being
generated using random numbers increases with the number of invoices.

I would suggest a non-random method:

returns 37124908872

This returns a number that will be unique as long as no-one generates
another invoice within 1/100th of a second (assuming their computer clock is
in synchronization with yours).

You could say that it has an advantage in that with the invoice number you
can determine the date and time of issue.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question