hello, i am putting together a Request for Proposal form in excel.
The part that i am struggling with is creating a drop down list that triggers other fields. For example there's 2 type of Request (Quote & Service Agreement). When the selection is made for Quotes - i want this selection to trigger other fields/drop down based on the type of request in this case Quotes. Also, i want to LEARN how to do this part on my own. This project is not a big project.
I want someone to teach me how to work with drop down list to trigger other drop down.