Forum Discussion

Copper Contributor

Nov 20, 2019

Solved

Formulating a report.

Hi, I'm wondering what would be the best way to formulate the following document. In simple terms i want a list of questions which will be answered via drop down yes/no From this i want a ne...

EXAMPLE.xlsx12 KB

excel

Formulas and Functions

Smitty Smith
Nov 27, 2019
Bailey1000 You might be able to do something with Dependent Data Validation, where your first selection automatically populates a second set of selections. But it would still be up to you to make the second selection.

For a more automated approach, you you could use a VBA Change event to search for a certain sentence based on individual Yes responses, but you'd have to let us know where to look and what to look for.

Smitty Smith

Former Employee

Nov 27, 2019

Bailey1000 You might be able to do something with Dependent Data Validation, where your first selection automatically populates a second set of selections. But it would still be up to you to make the second selection.

For a more automated approach, you you could use a VBA Change event to search for a certain sentence based on individual Yes responses, but you'd have to let us know where to look and what to look for.