Mylifedesire
New Member
Hi All,
This is my first question to this excellent Excel forum. I am new to Excel Macros and want to learn how to build a Team Skill Index in a excel with following features:
1) First column displays skills area
2) Second column displays Weightage values on scale of 100 divided into each areas but this column should be invisible to end user who would fill his/her rating values on scale 0-10 drop down values.
3) Third column displays drop down values on scale 0-10 where user could select any value from drop down and this column is visible to end users.
4) Forth column will multiply the second and third column to get the scores and this column should be invisible to end users.
5) There is one button that is only visible to Administrator and once he clicks the button he should get the chart or report of all the end users final scores that would be on scale of 0-10 taken from forth column. This should display only final score of all the end users in the class.
6) After getting individual's final scores, there is another button to show the average of scores from each class of 10 end users.
This is my first question to this excellent Excel forum. I am new to Excel Macros and want to learn how to build a Team Skill Index in a excel with following features:
1) First column displays skills area
2) Second column displays Weightage values on scale of 100 divided into each areas but this column should be invisible to end user who would fill his/her rating values on scale 0-10 drop down values.
3) Third column displays drop down values on scale 0-10 where user could select any value from drop down and this column is visible to end users.
4) Forth column will multiply the second and third column to get the scores and this column should be invisible to end users.
5) There is one button that is only visible to Administrator and once he clicks the button he should get the chart or report of all the end users final scores that would be on scale of 0-10 taken from forth column. This should display only final score of all the end users in the class.
6) After getting individual's final scores, there is another button to show the average of scores from each class of 10 end users.
