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" wrote:

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