R
rtilghman
Been struggling with this for a few hours and not making much
progress, hoping someone can help me out.
I've got an analysis XLS that has a bunch of interviews and a bunch of
analysis pages that look at aggregate responses for the questions
across all the scripts. What I'm trying to do is build a section in
each of the question analysis pages that will allow the user to select
one of the other questions from a drop-down menu/list and then see the
intersection between the current page's question and the selected
question.
For example, say the user is on the sheet for "Question 36" and wants
to see how people who answered this question answered Question 43. I
want to allow them to pick Question 43 in the pull-down and then have
that selection cause both the vertical key (labels) and data points to
change commensurately.
The easiest way to do this (in my mind) is to tie each list entry to
the question number and appropriate row, and then to reference them
centrally from teh analysis fields. That way when the user changes it
and updates, the calculations should all refer to the new variable.
What I can't figure out is how to do this in Excel... I basically need
a list with a label and two hidden values, and I then need a way to
reference those values from the various dependant cells.
Thoughts? Is there a good way to do this? Also, how do you create
lists that can be shared between sheets? Having trouble just figuring
that out...
Thanks for any help.
-rt
progress, hoping someone can help me out.
I've got an analysis XLS that has a bunch of interviews and a bunch of
analysis pages that look at aggregate responses for the questions
across all the scripts. What I'm trying to do is build a section in
each of the question analysis pages that will allow the user to select
one of the other questions from a drop-down menu/list and then see the
intersection between the current page's question and the selected
question.
For example, say the user is on the sheet for "Question 36" and wants
to see how people who answered this question answered Question 43. I
want to allow them to pick Question 43 in the pull-down and then have
that selection cause both the vertical key (labels) and data points to
change commensurately.
The easiest way to do this (in my mind) is to tie each list entry to
the question number and appropriate row, and then to reference them
centrally from teh analysis fields. That way when the user changes it
and updates, the calculations should all refer to the new variable.
What I can't figure out is how to do this in Excel... I basically need
a list with a label and two hidden values, and I then need a way to
reference those values from the various dependant cells.
Thoughts? Is there a good way to do this? Also, how do you create
lists that can be shared between sheets? Having trouble just figuring
that out...
Thanks for any help.
-rt