moving text based on formula

A

abailey

OK, I am going to try and explain this best that I can to see if it i
possible. I would appreciate any advice that can be given. Thanks i
advance.

This is what I am trying to accomplish.

I am creating a checklist. The checklist consists of different task
with an option for the user to select “Completed” “Not Completed”

Example:

(Pull down menu with text “Completed” “Not Completed” - Remove th
trash from the building.

I have over 100 questions, listed in the same format. What I am tryin
to do is if a question is answered “Not Completed”, I want the actua
question (In this case “Remove the trash from the building” to b
copied and moved to a different location where it will list al
questions that have be labeled “Not Completed”. It has to handle i
all question were answered “Not Completed”

I also need the formatting of the text to be a certain way. I want i
to list it one question under the other.

Example:

The following tasks have not been completed.

Remove the trash from the building
Was all the window
 
J

Jason Morin

Without getting into complicated macros, I'd suggest just
applying a filter (Data > Filter > AutoFilter) and filter
for "Not Completed" to create your list.

HTH
Jason
Atlanta, GA
 
Top