Taking text from multiple cells and adding to a different cell.

[abailey]

I am trying to create the following scenario. I am unsure if it is
possible thing to do and would greatly appreciate any info that anyon
might have.

Excel Sheet
The format is of a checklist style. There are multiple groups o
questions (over 100) that require the user to select a correspondin
text next to it (using a drop down menu).

Example:

YES/NO “Has Step 1 been completed”

What I am trying to do is if a user selects NO from a drop down menu
the text “Has Step 1 been completed” is displayed in a different cell.
I want this to happen for all of the questions that NO is selected.
Since I have over 100 questions I need the cell to handle up to 10
questions being displayed.

Thanks

 

[Anders Silven]

Not sure if I understand what you mean by "a different cell", is that on the
same row as the question?
If so, try
=IF(A1="No","Has Step 1 been completed","")
in cell C1 and fill down, assuming the questions begin in cell A1.

Otherwise post back with more details.

HTH
Anders Silven

 

[abailey]

Thanks Anders!

Unfortunately I have a few more questions.

The other cell would actually be on a different page. I want t
display all of the questions that NO was answered too for a quic
reference.

I want the page to display all NO questions one underneath each other.

Example: This would be listed for all questions that were answered N
(In this case Question 1, 2, and 3)

Question 1
Question 2
Question 3

How can I maintain a format of each NO question being displaye
underneath each other? Since I have over 100 questions that I woul
like to do this with, it has to handle if all question were asked NO.
I know I can use individual cells for each question, but I want t
avoid having question being displayed in designated cells.

Example:
If question 100 was the only question answered as NO, I don’t want i
to be displayed on the 100th row down. I want it to be displayed th
same as if NO was selected on question 1. If multiple questions ar
selected as NO, than have then display in numerical order.

Thanks Again!!!!!

 

[Anders Silven]

Hi again abailey,

One way is to use an Advanced Filter to copy the "NO" rows to the other sheet.
There are some good instructions here:
http://www.contextures.com/xladvfilter01.html#ExtractWs

You can also use a VBA macro to do this, or both.

HTH
Anders Silven

 

[abailey]

I will give that a try