Creating Reports in another worksheet in a workbook

[Guest]

Hello and thank you for your time...Here is my question. I have created an
audit for my employees performance using a rating system, (i.e. Meets
expectations, Exceeds expectations, etc) in one worksheet of Excel 2002. I
have created a drop down list for each of the ratings and a list of my
employees.

In another worksheet of the same workbook, I would like to have a report to
record both the individual employees and the ratings of each of my employees.

Can excel record these ratings for each individual separately in another
worksheet while still using the same audit form containing a list of
employees and ratings?

 

[Guest]

You can use "external references" to access cells in another worksheet like
this:

=c:\foldername\[filename.xls]sheet1'!$b$13

 

[Guest]

Thanks dlw....I hope to paste an example of my audit in order for me to
understand your answer:

Worksheet A

Employee name: Drop down list here with names of employees

1. Was live contact established? Rating: Drop down list here
****************************************
Worksheet B of the same workbook contains the report I would like to record
each rating from worksheet A from each individual employee:

Employee Name from the drop down list of worksheet A:________
Meets Expectations:
Exceeds Expectations:
Needs Improvement:
Unsatisfactory:
N/A:

I hope this is clear as it is hard to write what I want!!!

You can use "external references" to access cells in another worksheet like
this:

=c:\foldername\[filename.xls]sheet1'!$b$13

Hello and thank you for your time...Here is my question. I have created an
audit for my employees performance using a rating system, (i.e. Meets
expectations, Exceeds expectations, etc) in one worksheet of Excel 2002. I
have created a drop down list for each of the ratings and a list of my
employees.

In another worksheet of the same workbook, I would like to have a report to
record both the individual employees and the ratings of each of my employees.

Can excel record these ratings for each individual separately in another
worksheet while still using the same audit form containing a list of
employees and ratings?

 

[Guest]

Anyone has a formula or an answer to this? Thanks

Thanks dlw....I hope to paste an example of my audit in order for me to
understand your answer:

Worksheet A

Employee name: Drop down list here with names of employees

1. Was live contact established? Rating: Drop down list here
****************************************
Worksheet B of the same workbook contains the report I would like to record
each rating from worksheet A from each individual employee:

Employee Name from the drop down list of worksheet A:________
Meets Expectations:
Exceeds Expectations:
Needs Improvement:
Unsatisfactory:
N/A:

I hope this is clear as it is hard to write what I want!!!

You can use "external references" to access cells in another worksheet like
this:

=c:\foldername\[filename.xls]sheet1'!$b$13

Hello and thank you for your time...Here is my question. I have created an
audit for my employees performance using a rating system, (i.e. Meets
expectations, Exceeds expectations, etc) in one worksheet of Excel 2002. I
have created a drop down list for each of the ratings and a list of my
employees.

In another worksheet of the same workbook, I would like to have a report to
record both the individual employees and the ratings of each of my employees.

Can excel record these ratings for each individual separately in another
worksheet while still using the same audit form containing a list of
employees and ratings?