new sheet with data from other sheets

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.

How about keeping all the data in the same location.

But then select your range and then use Data|Filter|Autofilter.

You can use the dropdown arrows to show just the rows you want.

And when you want to see all the data, just use Data|Filter|Show All.

====
There are routines available that will create separate sheets, but then it can
get dangerous. If someone updates the wrong version, your real data will be out
of sync.

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

exceluser111 wrote:
>
> 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

--

Dave Peterson

appreciate the insights to my attempt to create a summary list of Outstanding items from numerous sheets in a workbook.