View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
masoud12345
 
Posts: n/a
Default Excel function to return tab name


I have a spreasheet with multiple tabs. I am getting the maximum value
of a table in a summary tab. The table is present in each tab with
different values. I would like to know if there is a way to know from
which tab that maximum value came from. (since the table is present in
tab1, tabb2 , tab3 for example and the max comes from tab3, how can I
know without going through each tab myself, from which tab the value
came from?).
Thanks for your help.


--
masoud12345
------------------------------------------------------------------------
masoud12345's Profile: http://www.excelforum.com/member.php...o&userid=32622
View this thread: http://www.excelforum.com/showthread...hreadid=524217