All
I've got a score grid, say B2-V22(with the 1st row&col with names.) So if Team A plays Team G, you just look for TeamA in the first col and then Team G in the First Row. And where they intersect you enter the score.
What I want to do is that say I click cell J12 I want to be able to have a Function that will tell me the two teams involved.
So as I select other cells the names displays will also change.
I think "active cell" might play a part, but i'm not sure how.
BP
I've got a score grid, say B2-V22(with the 1st row&col with names.) So if Team A plays Team G, you just look for TeamA in the first col and then Team G in the First Row. And where they intersect you enter the score.
What I want to do is that say I click cell J12 I want to be able to have a Function that will tell me the two teams involved.
So as I select other cells the names displays will also change.
I think "active cell" might play a part, but i'm not sure how.
BP