I have a workbook, each sheet is a departmental list of tasks. Each task has a text status, a target date, a completion date (if done) and a column for "O" or "C" outstanding or complete.

Question, how can I create another worksheet, within or outside of the existing workbook, that automatically generates based on the O/C indicator being "O"? The workbook when printed is 42 pages, the outstanding list is only two or three. I am not a power user of excel.

Thank you.