Filter specific Text from column and copy to Target sheet

Hello,

I'm using below code to copy the data from "Raw Data" to "ProjectSummary" tab.

Please Login or Register  to view this content.

My further requirement is that, rather than copying all the rows to "ProjectSummary", I want macro to look for a text "Positive" in column AO (Raw Data tab) and only copy the "Positive" row data to "Project Summary" tab. Sample attached for reference.

Please suggest with changes in the above code.

Thanks !

Well ! i've made some changes to the code which I posted in my first thread

Please Login or Register  to view this content.

where can i apply the filter to copy "positive" rows ?

Thanks !

Well ! I added one more filter as :

Please Login or Register  to view this content.

This allowed to copy and paste the Positive row to the target sheet.

But if there is only "Negative" rows in the "owssvr" tab, I should get a msg box as "No Data found"

Thanks !

Hi Sintek,

I made some changes to the code provided by you and was able to fix the issue.

Thanks ! for your support as always.

Cheers.