Forum Discussion
Pull-down "Data Validation List Dropdown" Formula where source lists are horizontal
Here's one solution. I suspect there are others.
I've added a column (which should be hidden in actual use), Column C, on your tab of questions. It contains names that then are used in the data validation for Column D. That formula, in the Data Validation dialog box is =INDIRECT($C2) which can then be copied down to each question row. It thereby automatically is referring to a new "name" as the source for the specific list of answers pertaining to each question
On the answers sheet, those same names have been put in the top row, and then are used as assigned names to the ranges of answers.
I'm quite sure the answer to your question is "Yes."
Although you've done a reasonably good job of describing your workbook's layout, I'm reluctant to try to create my own version of it....is it in any way possible for you to post either your actual workbook (so long as it contains no private or confidential information) OR a reasonable facsimile?
That would help me or others here return with a working example....I think you are already moving in the right direction, but it's just a lot easier to play around--if you'll excuse that phrase--with the real thing, making sure a recommendation actually works.
matheteshey thanks for your reply.
here is an simple example file with the current setup, where we manually change each range for the drop-down in sheet "questions" in column "C".
Here's one solution. I suspect there are others.
I've added a column (which should be hidden in actual use), Column C, on your tab of questions. It contains names that then are used in the data validation for Column D. That formula, in the Data Validation dialog box is =INDIRECT($C2) which can then be copied down to each question row. It thereby automatically is referring to a new "name" as the source for the specific list of answers pertaining to each question
On the answers sheet, those same names have been put in the top row, and then are used as assigned names to the ranges of answers.
thanks, this is simple and works just fine for now!
btw: couldn't download your example, computer said it is "corrupted". However, it got the point using a reference to get my answer lists. perfect, thanks a lot!
