Hi, I would like to develop a diagnostic tool on sustainability (similar to the link here: [url removed, login to view])
However, I would like to develop a spreadsheet (not web) based diagnostic with similar design and output to the web-link above (orange themed colour is preferred). At the moment, I have the tabs with questions on each category. For example, one tab is on Environment (this has all questions on Environment). What I want and struggling with the most is the output. I would like the output similar to what happens in the above attached website link. Dashboards would be nice in the output tabs.
In essence, as a client punches in their answers on each tab, the output page will tell them where their current sustainability performance is, where they want to get to, and gaps and opportunities in that space. Hence, macros/VBA as well as design skills are essential.