Sequential Numbering

I would like to know the formula for making a cell be able to do sequential
numbering such as for purchase orders.

Tom,

A simple way would be to use something like this, you could assign it to a
button, an open or before print event.

Sheets("Sheet1").Range("A1").Value = _

Sheets("Sheet1").Range("A1").Value + 1



For other ways to do this or if this is going to be used in a temple have a
look here

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



And if you are new to macros you may also what to have a look here on
getting started with macros

http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Tom" <Tom@discussions.microsoft.com> wrote in message
news:7721387B-7289-4D63-822A-76A665AE9A43@microsoft.com...
>I would like to know the formula for making a cell be able to do sequential
> numbering such as for purchase orders.

Paul B wrote:

> Tom,
>
> A simple way would be to use something like this, you could assign it to a
> button, an open or before print event.
>
> Sheets("Sheet1").Range("A1").Value = _
>
> Sheets("Sheet1").Range("A1").Value + 1
>
>
>
> For other ways to do this or if this is going to be used in a temple have a
> look here
>
> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>
Is this a religious thing?

Hi

A worksheet formula can't handle that itself, you need some code solution.
See
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

HTH. Best wishes Harald

"Tom" <Tom@discussions.microsoft.com> skrev i melding
news:7721387B-7289-4D63-822A-76A665AE9A43@microsoft.com...
> I would like to know the formula for making a cell be able to do
sequential
> numbering such as for purchase orders.

"cschiller1<at>earthlink.net earthlink.net >" <"cschiller1<at> skrev i
melding news:eeUgNwVxGHA.4872@TK2MSFTNGP02.phx.gbl...
> > http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
> >
> Is this a religious thing?

Most things are. Or almost none. Depending on how you look at it.

HTH. Best wishes Harald