Showing a subset of rows from one sheet on another sheet

[XON2000]

Hi.

I'm trying to set up a spreadsheet that has a list of projects on one sheet, and on the other sheets, show a subset of this data based on the project status.

So, for instance, the first sheet might have the following rows:
Project 1 - Pending
Project 2 - Pending
Project 3 - Complete

The second sheet only shows the pending projects, so it would look like this:
Project 1 - Pending
Project 2 - Pending

And the last sheet only shows completed projects, so it looks like this:
Project 3 - Complete

I need the summary sheets to update automatically when the main sheet is modified. Ideally, the summary sheets would be able to be sorted and filtered independently.

Does anyone know if this is possible without programming?

Thanks,

Shawn

[Ruthki]

have you tried using pivot tables to create the second and third sheets?

[XON2000]

It occurred to me, but I wasn't sure if they'd work. Can a pivot table present data in its original form, but simply filtered down to a subset?