Combine Multiple Sheets with Live Data using Data Mesh
I have 5 Metric Sheets that come from a Master form sourced sheet.
I want to combine the 5 Metric Sheets into one Master Metric sheet that updates live WITH the formulas that are already in the metric sheets.
I have combined all 5 Metric Sheets into one Master Metric Report and tried Data Mesh, into a blank Master Metric Sheet, but issue I am finding is that I will have to create 15 different configurations because I have 15 columns with 123 rows per sheet.
Is there a better solution to this or am I going to have to make 15 different Data Mesh configurations to accommodate my problem?
Answers
-
15? I count 5…one for each of the 5 Metric Sheets. Each DM config would be a source of one of the 5 sheets and the destination of the Master Metric sheet. In each configuration you can specify the key value to match the rows between sheets then map source columns to destination columns (you can add more as needed, not sure of limit but it is much more that 15).
Second option would be to create cell-links from the Master Metric Sheet back to the individual Metric Sheets, or even using INDEX/MATCH or INDEX/COLLECT formulas to display the data from individual sheets in the master sheet.
Please let me know if I am misunderstanding your question.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives