View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Colin Pollard Colin Pollard is offline
external usenet poster
 
Posts: 2
Default 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