asked on How to Pull "Cell" Data from Excel Sheet in Power Pivot to Another Excel Power Pivot Sheet?
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.
Example:
Dashboard #1 (1 Excel Sumary Sheet of Data)
10 Pivot Tables
20 Datasources
Dashboard #2 (1 Excel Sumary Sheet of Data)
13 Pivot Tables
25 Datasources
Dashboard #3 (1 Excel Sumary Sheet of Data)
15 Pivot Tables
27 Datasources
NEW REQUIREMENT:
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?
Thanks
Example:
Dashboard #1 (1 Excel Sumary Sheet of Data)
10 Pivot Tables
20 Datasources
Dashboard #2 (1 Excel Sumary Sheet of Data)
13 Pivot Tables
25 Datasources
Dashboard #3 (1 Excel Sumary Sheet of Data)
15 Pivot Tables
27 Datasources
NEW REQUIREMENT:
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?
Thanks
Microsoft ExcelMicrosoft Office
Last Comment
Marcus Aurelius
ASKER
I'm not as experienced in POWER PIVOT as other software.
So, I have different "projects" for each Dashboard in Excel. Do I move all Dashboard "project sheets" into a single Excel Workbook,....OR....?
Another concern is optimization of the project so that it doesn't run slow etc...
Also, the final solution will need to be consumed via Sharepoint....
Thanks for the input.
So, I have different "projects" for each Dashboard in Excel. Do I move all Dashboard "project sheets" into a single Excel Workbook,....OR....?
Another concern is optimization of the project so that it doesn't run slow etc...
Also, the final solution will need to be consumed via Sharepoint....
Thanks for the input.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Nice work Jerry, much, much appreciated! Cheers!
Use VLOOKUP, SUMIF, SUMIFS, COUNTIF, LOOKUP, SUMPRODUCT, INDEX & Match, etc... to pull data from an Excel List or Excel Table (List of data in rows and columns)