Nov 01 2023 01:02 AM
Is there a way we can pop a formula on each tab that calculates the number of associates trained that week along with the average percentage of assessment scores without having to go through each tab individually to pull the information? For reference this is how the master sheet looks like:
Thank you for the help guys!
Nov 01 2023 03:34 AM
@AK_SEHGAL97 You could use the INDIRECT function for that, but your problem is a structure problem.
If you want to easily summarize data it is best to have like data on the same tab in a single table. Add a column to the table which contains the current tab name (such as a company name or a department). Now you can use a pivot table to summarize your data.