Forum Discussion
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 new tab where there are more questions are supplied BASED on the answer to the sheet 1, these questions are found in the database
Then when these questions are answered i want this to produce a report, before i did this using an IF function, where if the answer was "yes" then i would input a few sentences for the report.
With the extra "filtering" of questions im unsure of how this is going to filter and create my report.
Can anyone help please?
Thanks
Bailey
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.
1 Reply
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.