Create form and Data separately
 

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

Create form and Data separately
 

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

Create form and Data separately
 

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

"Barb Reinhardt" wrote:

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

Create form and Data separately
 

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

Create form and Data separately
 

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