Forum Discussion
Setting up a dashboard based on multiple workbooks
I'm wanting to setup a dashboard showinh test results from different sites. My vision is that each site would have their own workbook that they input data on, but every site would be inputting in a t...
See attached Excel file, provided that you can consolidate the various workbook data tables into a source sheet within the existing workbook. From there, you can use an OFFSET with nested MATCH functions. The 'dashboard' sheet in the enclosed file will make it clearer (and this is without using the potential benefits of tables).
If you want users to maintain separate workbooks, you'd be able to use the data tables, their columns, and rows as unique identifiers to do the same with MATCH functions.
I hope this helps, but if you'd like to go into more detail, happy to.