mklindquist
10-30-2013, 08:58 AM
I'm trying to accomplish two different things with Excel and Drop downs.
1. I have identified data (document type list) on another worksheet in my workbook to use for Sheet1 drop down list (column b). Is it possible to also be able to just enter data into the drop down list cell? Like if there is a new form have the user be able to enter the new document type name instead?
2. From this same drop down list - depending on what document type list is selected in Column B - have another drop down in column C that is specific to that document type (will list documents specific to the document type). For example we have a document type called FA Loan Documents and a subset under that includes: Alternate Loan Documents, Entrance Loan Counseling, Loan Disclosure Statmeents, etc. We have another document type FA Agency Documents and the subset under that includes: Consortium Agreements, Gear Up Verification Form, Housing Development Forms and so on.
1. I have identified data (document type list) on another worksheet in my workbook to use for Sheet1 drop down list (column b). Is it possible to also be able to just enter data into the drop down list cell? Like if there is a new form have the user be able to enter the new document type name instead?
2. From this same drop down list - depending on what document type list is selected in Column B - have another drop down in column C that is specific to that document type (will list documents specific to the document type). For example we have a document type called FA Loan Documents and a subset under that includes: Alternate Loan Documents, Entrance Loan Counseling, Loan Disclosure Statmeents, etc. We have another document type FA Agency Documents and the subset under that includes: Consortium Agreements, Gear Up Verification Form, Housing Development Forms and so on.