Larry of Oz
New Member
- Joined
- Jun 2, 2020
- Messages
- 17
- Office Version
- 2016
- Platform
- Windows
Hello all,
I'm looking for advice on the best way to merge one row of data from multiple tables into one table. I am happy to look up and learn the process, but I'm a bit confused about which option is best so I can direct my learning.
Solution needed for:
1. Workbook containing 6 worksheets, each worksheet is for a different location
2. Each worksheet has a table with identical column headers e.g. 'Month', 'Year', 'Highlight', 'Concerns", 'Risks' and each worksheet is updated monthly by the staff member responsible for that location
3. Once a month a report is required for Executives that pulls the latest month's row from each worksheet resulting in a report for, say January 2024 that contains the January entries for each of the six locations/worksheets
4. It needs to be clean looking, e.g. a snapshot with no need to drill down into information
Is anyone able to suggest the best method to do this so I can focus my learning in that direction? I have already looked into it but am a bit confused about data model, power query or whatever else might be the best solution, even if that is just an Excel formula.
Many thanks in advance for any suggestions.
Lauren
I'm looking for advice on the best way to merge one row of data from multiple tables into one table. I am happy to look up and learn the process, but I'm a bit confused about which option is best so I can direct my learning.
Solution needed for:
1. Workbook containing 6 worksheets, each worksheet is for a different location
2. Each worksheet has a table with identical column headers e.g. 'Month', 'Year', 'Highlight', 'Concerns", 'Risks' and each worksheet is updated monthly by the staff member responsible for that location
3. Once a month a report is required for Executives that pulls the latest month's row from each worksheet resulting in a report for, say January 2024 that contains the January entries for each of the six locations/worksheets
4. It needs to be clean looking, e.g. a snapshot with no need to drill down into information
Is anyone able to suggest the best method to do this so I can focus my learning in that direction? I have already looked into it but am a bit confused about data model, power query or whatever else might be the best solution, even if that is just an Excel formula.
Many thanks in advance for any suggestions.

Lauren