Hi there

I have a spreadsheet containing multiple data across rows. I only want items to appear based on certain text from one column, I want it to appear in chronological order however. This spreadsheet will be used by various people with data being entered daily, so the simple filter option won't work with what I want it to do.

Basically, this is what it currently shows:

Example A Subject A Open
Example B Subject B Open
Example C Subject C Closed
Example D Subject D In Progress
Example E Subject E Closed
Example F Subject F Open

Basically, I only want items that have either Open or In Progress status to appear, so using the above examples, the result should show:

Example A Subject A Open
Example B Subject B Open
Example D Subject D In Progress
Example F Subject F Open

So it stays in alphabetical order, but anything where the status shows Closed does not appear.

Is there a way to do this without the excel file going really slow, please let me know if I might need a macro to do this and I will post this in the VBA forum.

Thanks