sequential number

[Malissa]

I want to a sequential number to fill in automatically each time the form is
filled out.

[JE McGimpsey]

Take a look here:

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

In article <382597DC-F82C-46F1-A18D-4624D2292F15@microsoft.com>,
"Malissa" <Malissa@discussions.microsoft.com> wrote:

> I want to a sequential number to fill in automatically each time the form is
> filled out.

[Gord Dibben]

Check out John McGimpsey's site for method.

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


Gord Dibben Excel MVP


On Mon, 15 Aug 2005 13:22:04 -0700, "Malissa"
<Malissa@discussions.microsoft.com> wrote:

>I want to a sequential number to fill in automatically each time the form is
>filled out.

[Paul B]

Malissa,
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


--
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

"Malissa" <Malissa@discussions.microsoft.com> wrote in message
news:382597DC-F82C-46F1-A18D-4624D2292F15@microsoft.com...
> I want to a sequential number to fill in automatically each time the form
is
> filled out.