Thanks Glenn....now let me show my real ignorance. Just how would I go about
doing that? (I've gone to the Help in Excel, and opened the Advance on the
filter tool, but I'm real confused :-()

Thanks.
--
Bill


"Glenn" wrote:

Bill638 wrote:
Glenn,

Many thanks. That solved that problem. Now, a larger challenge (but then
again, maybe not). If the answer to the question on the checklist page is
YES, then there is no need for the auto-populated recommendation on the
report worksheet.

What can I do to have that question totally ignored on the report worksheet.
Now, if the answer is YES on the checklist worksheet, I get blank cells (an
empty row) in the report worksheet, which necessitates manually deleting all
such rows.

Again, many thanks for your quick response.

Bill


I would probably use an AutoFilter to hide all blank rows.