We have a dashboard for displaying end results, but can you use a dashboard to collect data, make a very boring spreadsheet with 300+ questions to something more appealing ?
Hi Mike,
It's difficult to picture what your workbook currently looks like and what you have in mind. Yes, I'm sure you could make it more appealing with various Excel tools. Sorry I'm not more help. It's difficult to say more without a specific question.
Alternatively, you could use Excel survey (requires OneDrive for Business) to collect your data, which you then report on in a dashboard.
Mynda
That's ok....just started your dashboard course, had me thinking. If I am displaying my data from a sheet, could I actually create a front end to actually get data. If you can recall the Cyber assessment I sent recently lots of questions. Something around that.
An alternative to Excel Survey is to build a User Form with VBA that will take the user through the questions and deposit the answers in a table that you can then report on. The downside of both of these options is that the user needs to answer each question before moving on. From memory, your questions are quite complex and having them in a table in the worksheet allows the user to answer them out of sequence. I imagine this is something that typically happens, but could be wrong.
