Creative Scorecard with dynamic elements
Please note that the board shown in the attached picture is an overview of what I can do with excel, The board currently have the following functionality: - there is a cell to select team from teams list - teams list is updated automatically when new teams are added - all cells are formulas depending on selected team from list (as shown in attached picture) - dynamic pie chart to show more detailed scores (passed, passed with resolution, remaining score of tests score) - updated scorecards on the right (changed fonts, colors, and used lookup formulas instead of manual input) What can be achieved more? - we can make the scorecard dynamic as well! which adds new team cards to the board as it is added in its sheet. However, this will require VBA code, and time to achieve, so I can't create that unless you need it. If you are interested in hiring me, please feel free to contact me to discuss any details or requirements. Have a lovely day, Osama.
