[I-Hate-Hulse]

So I've got an Excel question for the gurus on this board. I'm guessing it's a simple thing but honestly, my Excel kung-fu is not so good.

Here's the situation.

Tab1 has the following data in Column C (in their respective rows)

Risk: Cash is Stolen
Person signs cheques
Bank Rec's reviewed
Risk: Exchange Rates are Calculated Wrong
Calculations reviewed
Computer rejects unreasonable calcs
Risk: Cash not Deposited in Bank
Bank Rec's reviewed
Person signs cheques

Here's the thing. On a seperate tab (Tab2) within the workbook, I'd like to have the data from Tab1, Column C there, but with:

-All duplicate rows removed
-All rows that start with "Risk:" removed

So the data on tab 2 would look like:


Person signs cheques
Bank Rec's reviewed
Calculations reviewed
Computer rejects unreasonable calcs


Here's the thing, the new data on Tab2 should be dynamic, and not need manual refresh or macro triggering to work. If something changes on tab1 (insert/delete/change), it needs to change on tab 2 as well, subject to the above requirments.

I've tried a combination of autofiltering and if/then statements but can't put it all together - any help would be appreciated! Thanks!