OK...

From the "Whenever possible, let Excel do the work instead of a Macro"
department:

Goal: All the unanswered questions  in another list  with no blank lines.

As I believe you describe, a macro *could* be written to scan through the
questions and
store the un-answered ones in the other sheet  in sequential cells.

However, how about simply sorting the questions by your "Answered Flag" ...
that's
whatever you mentioned that you can make True or False depending on whether a q
is
answered.
You may need to copy the full list then sort.

I have sorted lists (with screen updating off) done  things as desired, then
"Un-Sorted" it
back to orginal. I add a column containing sequential numbers, to the original
list, to sort
on for the "Un-Sort" to go back to original. I also Named the Range containing
the list.

I have also used command buttons at the top of colums to sort the respective
columns.

I even wrote it so the cell selected after the sort is the same one selectd
before the sort,
so the user is in the "same place" (contents-wise).