We have a large spreadsheet at work which has a lot of tabs of data. I wanted to create a "dashboard" to put some, not all, of the information at easy reach.
So you would pick a name and certain cells would contain specific information.
But I want it to look nice, not just a plain excel looking list.
Something like this (minus graphs):
dashboard_gray_grey.png
How easy is it to do something like that? And does it need VBA? I really rather not use VBA if I can help it, as it would change the extension which will cause my boss some headache (the file is on sharepoint with many versions).
All help is really appreciated.
Bookmarks