templates and Forms
 

I am trying to build a form in Excel that will track the entries into the
form in a list format on a worksheet. I would like to save the form as a
shared file so multiple users can use the form for data entry (like a true
database form).

In help there is mention of the "template wizard with data tracking". Where
can I get this template. It is not in templates on my computer, nor can I
find it on microsoft.com.

Is this worth trying, or should I recommend that they use the built in form
that Excel provides for lists. Any tricks there?
--
Thanks, Allison

templates and Forms
 

Alison
The template wizard does not contain a template, you create the form you
need in Excel, save it, then using the template wizard convert your form into
a template(this can be made public) that stores any data entered into a
database using the same headings as your form. (you'll need to create this
also beforehand), have fun.
--
Colin Pollard


"Allison" wrote:

I am trying to build a form in Excel that will track the entries into the
form in a list format on a worksheet. I would like to save the form as a
shared file so multiple users can use the form for data entry (like a true
database form).

In help there is mention of the "template wizard with data tracking". Where
can I get this template. It is not in templates on my computer, nor can I
find it on microsoft.com.

Is this worth trying, or should I recommend that they use the built in form
that Excel provides for lists. Any tricks there?
--
Thanks, Allison