??Repot sheet name W/ A function on a different sheet??

N

n5jhx

Hello,
I have a question. What I'm working on is a budget, spending plan.
have a sheet for every month, named by the month. I also have a yea
end report sheet. On the year end report sheet I have a column name
"Maximum Spent Amount". I know how to tell excel to get the MAX amoun
from the months sheets, but I also want it to tell me what sheet th
MAX amount is on. Or month that it is in. I'm clueless here. Thanks i
advance.

N5JH
 
Top