Can you automate numbers in Excel?

[Heather Stokes]

I need a number to automatically populate a cell with a unique number
each time the worksheet is opened. The number being populated needs to
populate in numerical order. For example, I have a worksheet that is
being used as a form which requires a unique number to be used as the
"ticket number". Each time the form is pulled up and used in Excel as
an official "ticket", it needs to have a different number; each
subsequent ticket shall follow the ticket number before it. The first
ticket number would be 1. Then when the same form was opened up to be
used the second time, the ticket number would be 2 and so on.

Can such a function be accomplished in Mircrosoft Excel?

Thanks in advance.

Heather Stokes

 

[Bob Phillips]

take a look at See http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Heather Stokes"

 

[Guest]

But this works in one workbook only. How to make it available in all workbooks.

take a look at See http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Heather Stokes"