Thanks for the idea...but...this is a user checklist - others will be
using the checklist for projects (making a copy of my file to save
for their projects). So I need to be able to automate it as much as
possible and get the list  of missing/unanswered questions  on one
sheeet in a short simple list that then can be emailed out
automatically to managers to update them on the project's progress.
I have done  a worksheet with all the questions and whether or not
they have been answered but I would like to shorten it up so the user
can just look at the unanswered questions and not have to scan the
entire list. And I can't sort the checklist - there are control
buttons, textboxes, etc. all over the sheet. The checklist also has
links to other worksheets that are initiated when a user clicks a
OptionButton. Eventually the checklist will be a vb form with tabs
for the five sections but I didn't have the time to get my skill
level up on forms in time to meet the deadline for a checklist so I
put it in an excel sheet.

If there is a way to attach a sample of my workbook to show you what
I have going on let me know - I am new to this group and clueless
about what and how I can send attachments if at all!