Create a KPI dashboard|Dashboards & Charts|Excel Forum|My Online Training Hub

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

Forms (VBA)

I hope that points you in the right direction.

Mynda

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