Hi,
I am actually trying to get the minimum value for a particular entry across 500 sheets, I am not really sure how to go about it, but i tried some MIN(A:ZTS!) formula and got an error. Basically this did not solve my problem.
Some more details:
I have a value in cell O11 across 500 sheets. I want to compare through all the sheets and find the minimum value. Also i need to know from which sheet does that minimum value come from.
This cell O11 has a result that has been calculated using a formula and data on that particular sheet.
Please let me know if i need to explain anything more. I am relatively new to working with multiple sheets and vba and my first assignment is with 500 sheets.
Thank you for the help in advance.
Bookmarks