Forum Discussion
How to consolidate data in an Excel file coming from 20 sub groups?
I monitor an Excel file consolidating data coming from 20 sub groups hosted in separated Teams channels. For confidentiality reasons, sub groups should only report their data without accessing the en...
You can create one sheet in each group. Then create a 21th sheet that only you can see and filled via formulas by the other 20. Still in this sheet, on the Data tab, in the Data Tools group, click Consolidate
