Auto Generate Numbers

B

Biff

Hi Dane,

Here's a couple of ways:

If you already have your application in use and the order#
is in column C, you could use a formula like either of
these:

=C1+1 Simply add 1 to the next entry

OR

=MAX(C:C)+1 Basiclly does the same thing

Then just copy down as needed. You can suppress the
display if the other pertinent info for that transaction
has not been entered by doing something like this:

=IF(ISBLANK(A1),"",C1+1))

Biff
 
Top