Hello,
I created a scenario summary and in the Result Cells column, all I get is a cell reference.
Is there any way I can do a look up of that cell number located in the other tab so that the "Defined Name" of that cell displays where I wrote the "?"?
I've been searching the web for days, no luck, maybe I am not asking the right question, but I think it should be doable, right?
I also downloaded the Kutools toolbar but I don't think that would help.
PS: I don't know how to do macros, so if your solution involves a macro, please keep that in mind when explaining to me. I am willing to try anything as long as the steps are clear
Thanks so much in advance!
Laure
I created a scenario summary and in the Result Cells column, all I get is a cell reference.
Is there any way I can do a look up of that cell number located in the other tab so that the "Defined Name" of that cell displays where I wrote the "?"?
I've been searching the web for days, no luck, maybe I am not asking the right question, but I think it should be doable, right?
I also downloaded the Kutools toolbar but I don't think that would help.
PS: I don't know how to do macros, so if your solution involves a macro, please keep that in mind when explaining to me. I am willing to try anything as long as the steps are clear
Thanks so much in advance!
Laure