Many spread sheets results consolidated into a Master Sheet

Question

Many spread sheets results consolidated into a Master Sheet

Robin Smith 20

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

Barry Schwarz 3,736 Reputation points

2024-03-12T14:57:47.2166667+00:00

Formulas in one spreadsheet can reference cells in other spreadsheets. What have you tried? Can you provide an example of what you mean by consolidate?

Accepted answer

0 additional answers

Your answer

Barry Schwarz 3,736 Reputation points

2024-03-12T14:57:47.2166667+00:00

Formulas in one spreadsheet can reference cells in other spreadsheets. What have you tried? Can you provide an example of what you mean by consolidate?

Answer 1

Jiajing Hua-MFST 17,965 Microsoft External Staff

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.

Jiajing Hua-MFST 17,965 Reputation points Microsoft External Staff

2024-03-19T07:40:20.5433333+00:00

Hi @Robin Smith

If you have further issues, you may let us know.
Robin Smith 20 Reputation points

2024-03-19T14:35:07.2733333+00:00

Thanks for all the help, I had to make direct links because of the sporatic rows that were required. Fortunately, it's only 35 rows. Thanks again.

Share via

Many spread sheets results consolidated into a Master Sheet

0 additional answers

Your answer