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.


--
exceluser111
------------------------------------------------------------------------
exceluser111's Profile: http://www.excelforum.com/member.php...o&userid=37817
View this thread: http://www.excelforum.com/showthread...hreadid=573774