automatic sequential number on invoice or shippers
 

I made and invoice excel template and a shipper excel template. Each time I
open the worksheet to make an invoice, I want the number to change in the
cell on the invoice or shipper. No duplicate numbers. How can I do this?

One way

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards,

Peo Sjoblom

(No private emails please)


"jeannene" wrote in message
...
I made and invoice excel template and a shipper excel template. Each time
I
open the worksheet to make an invoice, I want the number to change in the
cell on the invoice or shipper. No duplicate numbers. How can I do this?

jeannene

Check out John McGimpsey's site for methods.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben Excel MVP

On Thu, 6 Oct 2005 17:34:49 -0700, "jeannene"
wrote:

I made and invoice excel template and a shipper excel template. Each time I
open the worksheet to make an invoice, I want the number to change in the
cell on the invoice or shipper. No duplicate numbers. How can I do this?