help creating a question sheet

J

Jason

I need help creating a question sheet. I have a question follwed by a drop
down list for the answer. What I need to do is have the spreadsheet return a
range of cells based on the answer from the drop down list. I could have the
range of cells hiden or on a different worksheet until the option is picked
from the crop down list. Is this possible?
 
J

Jason

Maybe I should be more clear on this.

TYPE OF OWNERSHIP (drop down list)

If the user picks (joint) it would return a range of cells for further
questions
If the user picks (sole) it would return a different range of cells for
further questions
 
O

Otto Moehrbach

Yes, that is possible but you would need to furnish info on all the ranges.
HTH Otto
 
O

Otto Moehrbach

Jason
This looks like a project rather than a question. I have the time to
help you so I will, but it would be better if we did this by email, if you
wish. Send me detail info regarding all the lists and questions and the
dependencies. My email is (e-mail address removed). Remove the
"extra" from this address. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Create a drop-down list from a range of cells 2
How do I create a drop down box within a drop down box? 1
Create two Data validation lists that are linked(Both change toget 2
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Copy corresponding cell in Column B if cell in A contains certain text? 1
Auto Change Formulas - Please Help. 2

Top