- Aug 20, 2013
I would like to find the largest value across multiple sheets and return the sheet name where the value is located in. The issue is that each week a new sheet is added so I can't create a static list of sheet names. The data are located in the same cell across sheets in cell B10. I have hidden blank sheets called "First" and "Last" at the beginning and end of each week's sheet ("Week 1" -- "Week N") so I can use the formula MAX(First:Last!B10) to get the largest value. How can get the sheet name where it's located when the sheets are continuously added? Thanks.