Okay, so I tried pivot tables and can't get those to filter correctly, and I tried IF statements and VLookups, and nothing seems to quite work, so I turn to the forum gurus for help.

On Workbook tab 1, I have all of my data. This data has been exported from a database.
On workbook tab 2, I want only records from that data where one of the columns (in this case column E) is "Open".

So as an example, if I have the following:


Release Data
OS-1 OS-2 OS-3 OS-4 OS-5
Property 1 Fix Property 2 Fix Property 3 Fix Property 4 Fix Property 5 Fix
Bug Story Bug Story Story
Open Closed Open Open Resolved
Priority 1 Priority 1 Priority 3 Priority 2 Priority 1


Then on Tab 2, I should only see in rows, the data for OS-1, OS-3 and OS-4, since these are listed as "Open"


I need some help in writing the formula for this in Excel - please bear in mind that I'm NOT a developer, so coding is a bit beyond my reach.

Thanks in Advance,
-KCP