Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Reports in Excel 2002
Hello and thank you for your time...Here is my scenario. I have created an
audit in one worksheet of Excel 2002. The audit in worksheet A contains a drop down list to display each of the ratings (i.e. meets expectations, needs improvement, etc) and another drop down list to display a list of my 10 employees. What I would like to know is, how do I create a report from worksheet A in lets say worksheet B, to reflect each individual employee and their ratings everytime I choose an employee from the drop down list and keep some kind of a rolling report whenever I choose a certain employee on the same audit form? I would be willing to email someone my report for more clarity on this issue. Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Reports in Excel 2002
Sorry, I forgot to leave my email address....please write to me so I could
send my workbook for you to review and Just remove the .nospam before the @ sign Thanks "Somewhere In Excel 2002" wrote: Hello and thank you for your time...Here is my scenario. I have created an audit in one worksheet of Excel 2002. The audit in worksheet A contains a drop down list to display each of the ratings (i.e. meets expectations, needs improvement, etc) and another drop down list to display a list of my 10 employees. What I would like to know is, how do I create a report from worksheet A in lets say worksheet B, to reflect each individual employee and their ratings everytime I choose an employee from the drop down list and keep some kind of a rolling report whenever I choose a certain employee on the same audit form? I would be willing to email someone my report for more clarity on this issue. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 creating reports for diffrerent products one at a time | Excel Discussion (Misc queries) | |||
Generating reports from an Excel 2002 worksheet | New Users to Excel | |||
Creating Reports in Excel | Excel Programming | |||
Creating Reports from Excel data to Word | Excel Discussion (Misc queries) | |||
Creating sveral reports from one excel file | Excel Programming |