Hi
I'm creating a KPI dashboard for my team (as attached), and I need to find a why where when i put the employee ID number it shows all his scores.
So I need to save the scores of each one and just switch between them using the ID !!
Thanks
Islam
Nothing attached mate.
dont forget to click upload
File added
Hi Islam,
Thanks for sharing your file. If I'm understanding correctly, you want to use the PSD sheet as an input form that then copies the data to another sheet containing the results for all employees which you can then use for analysis?
If so, please refer to these options:
Microsoft Forms for gathering data
I hope that points you in the right direction.
Mynda
Hi Mynda,
Thank you, but I am looking for something different.
I built my sheet so you can select the department name then you got a drop menu with the employee ID number when you select you got his/her data
you start get him a score for his performance.
What I need is after I finish the appraisal of the first employee I select the other one and start giving him his appraisal scores, and also keep all scores so I can switch between them when needed or to analyze the other all appraisals of the department?
Thanks
Hi Islam,
Please don't quote my reply again. It is directly above your reply so is not necessary. I've removed it from this post.
Thanks for clarifying your needs. The solution is still the same. You need to capture data entered and place it somewhere so that you can then enter the ratings for the next employee. In both Forms solutions linked to above you can provide the user with a list of items (employees) to choose from. I think the VBA based form will probably better suit your needs.
This requirement "and also keep all scores so I can switch between them when needed or to analyze the other all appraisals of the department?" will need to be done separately to the data entry form. It will query the data captured in the form so that you can analyse and compare it to the data being entered in the form. You could do this with a PivotTable and use the filters to select the employee you want to view.
Note: the data capture cannot be done with formulas because once you start to enter the next employee the previous employee's data will be lost.
Mynda