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.
"Sunday88310" wrote:
Take a look and see if this can be used
http://office.microsoft.com/en-us/te...CT101481371033
--
William<"M"
"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