Generate number NOT using a form

[DavisC]

Hi,
I've searched hi an low on this site and others, and the nearest match was a
question from Galaxykid in November.

I'm running Office 2000 and have used the Template Wizaed to create a
template that is used as a form to input data into another spreadsheet. I
would like one field on the template (which appears as a spreadsheet NOT an
Excel Form) to generate sequential numbers for each new record that is
entered and saved using my template.

I know it can't be that hard but I've been trying to figure this out for two
days! Help!!!!!

Thanks in advance.

Davis

[Roger Govier]

Try looking at the following link
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards
Roger Govier
"DavisC" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I've searched hi an low on this site and others, and the nearest match was
> a
> question from Galaxykid in November.
>
> I'm running Office 2000 and have used the Template Wizaed to create a
> template that is used as a form to input data into another spreadsheet. I
> would like one field on the template (which appears as a spreadsheet NOT
> an
> Excel Form) to generate sequential numbers for each new record that is
> entered and saved using my template.
>
> I know it can't be that hard but I've been trying to figure this out for
> two
> days! Help!!!!!
>
> Thanks in advance.
>
> Davis

[DavisC]

Awesome!! Thanks very much, Roger, I really appreciate it.

"Roger Govier" wrote:

> Try looking at the following link
> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>
> --
> Regards
> Roger Govier
> "DavisC" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I've searched hi an low on this site and others, and the nearest match was
> > a
> > question from Galaxykid in November.
> >
> > I'm running Office 2000 and have used the Template Wizaed to create a
> > template that is used as a form to input data into another spreadsheet. I
> > would like one field on the template (which appears as a spreadsheet NOT
> > an
> > Excel Form) to generate sequential numbers for each new record that is
> > entered and saved using my template.
> >
> > I know it can't be that hard but I've been trying to figure this out for
> > two
> > days! Help!!!!!
> >
> > Thanks in advance.
> >
> > Davis
>
>
>