How to Pull "Cell" Data from Excel Sheet in Power Pivot to Another Excel Power Pivot Sheet?
Posted on 2013-12-08
I have a Dashboard built using Power Pivot "Pivot Table" data. This "Dashboard" is really just an Excel Sheet that is displayed as a Summary Sheet with certain cells showing the Stop Light info of Red, Yellow and Green. So this is not a true Dashboard that is generated by Power Pivot but rather a Spreadsheet that pulls in data from other Pivot Tables.
Dashboard #1 (1 Excel Sumary Sheet of Data)
10 Pivot Tables
Dashboard #2 (1 Excel Sumary Sheet of Data)
13 Pivot Tables
Dashboard #3 (1 Excel Sumary Sheet of Data)
15 Pivot Tables
1 Single Dashboard (Excel Sumary Sheet of Data)
Get data from Dashboard #s 1-3 to consolidate and compare numbers from all 3 Dashboards into 1 single Dashboard.
QUESTION: What is the best approach to creating the New Requirement of the Single Dashboard using the other 3 Dashboard Data as its Datasource?
Can I use a "VLOOKUP" or "GETPIVOTDATA" kind of approach?