Many spread sheets results consolidated into a Master Sheet

Robin Smith 20 Reputation points
2024-03-12T14:28:56.35+00:00

I have a Master Spreadsheet and other spreadsheets into teams. I want to consolidate the information from the teams spreadsheets into the Master Spreadsheet.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,448 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
{count} votes

Accepted answer
  1. Jiajing Hua-MFST 4,600 Reputation points Microsoft Vendor
    2024-03-13T02:27:45.3366667+00:00

    Hi @Robin Smith

    Please check out Barry Schwarz's reply. For better analysis, you may share us with more details, such as the data samples.

    Generally, we may use Excel formulas and Power Query to process and integrate data to one sheet.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



0 additional answers

Sort by: Most helpful