See my attached workbook for an example. The key is that the names in Column A in the Summary Sheet EXACTLY match the names on the worksheet tabs.
It uses the formula:-MooFormula:![]()
=MAX(INDIRECT(A2&"!a:a"))
See my attached workbook for an example. The key is that the names in Column A in the Summary Sheet EXACTLY match the names on the worksheet tabs.
It uses the formula:-MooFormula:![]()
=MAX(INDIRECT(A2&"!a:a"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks