I need help to pull data that does not have unique values into another page

I have a large data set that has multiple different columns on one sheet labeled "Status".

In column E labeled "Action" there are various inputs and I am trying to pull data(in form of text) from every row that is marked as "ends" to another sheet.

A Vlookup would be ideal but since the characters do not have unique values it will only generate the first row it finds.

The only way I see this to work is you can create a filter for column E Labeled "Action" to sort only "ends". Then copy and past that information onto another sheet.

The "Status" sheet will be updated regularly and new data needs to be able to get pulled.

I hope there is a way to do this as I have been trying everything I can with my knowledge. Please help.

Thanks

could you send a sample?

Here is a sample workbook I created. Thanks for your help looking into this.

based on your sample workbook I created a macro that will copy the data of those records that have "ends" in the action column and flag them with an "*" so they are posted only once. The button executes the macro.

Thanks for the help! This is exatly what I needed. If it is not to hard can you tell me how you did this so I know for the future?

Thanks in advanced!

I'll upload in time a detailed descrition of how I did it.

Cheers,