Create form and Data separately

[Marilyn]

Hello
I need to create a form for employees to complete, print and save in the
computer.
This form will be in a common drive so all employees have access to the form.
After the form is completed, the employee will “save as†the form with a new
name in the common drive
Next employee will use the same form …

For my records, I need to have all the information in the form in an excel
file . Not a copy of the form, just a file with the data.

Lets say at the end of the month 30 people completed the form I should
have an excel sheet with the data of the 30 forms.

Not sure how to do this?
Do I need two worksheets, one with the form, one hidden with the data in the
form?
How do I get the data from the form to the other spreadsheet?

Is there a book or a site that can help me with this? Thanks in advance

 

[Barb Reinhardt]

You're going to have to determine a number of things:

1) Is all of the data stored in the same folder or in multiple locations?
2) If it's in a folder, is it the only type of data there?
3) Are there multiple worksheets in the workbook?
4) Are there named ranges tied to the cells with the information you want
to extract?

 

[Marilyn]

Barb Reinhardt
Thanks.....Since I have not started this project, I have a blank slate.
Open to all suggestions/help

 

[Sunday88310]

Take a look and see if this can be used
http://office.microsoft.com/en-us/templates/TC060889361033.aspx?pid=CT101481371033

 

[Marilyn]

Hello Let me clarify... Employees will be completing a form, which I will
create, I need to know how to extract the data/information on the form into
an excel spreadsheet.