Copy specific column data from one sheet to another sheet using Certain filter Criteria

Hello everyone!
Need your expert help!
I want to copy specific column data from Owner Database sheet to output sheet using Certain filter Criteria the criteria present on Filter Criteria sheet.
Macro first apply filter on Owner Database sheet then look Criteria from Filter Criteria sheet.
e.g = For Tenant ID 1
1st filter Criteria should "city"= Noida and apply this Criteria on Column T of Owner Database Sheet.
2nd Filter Criteria "RENT_SELL_LEASE"= P and apply this Criteria on Column M of Owner Database Sheet.
3rd Filter Criteria "property type,property type1,property type2"=(Residential Apartment,Independent/Builder Floor,Serviced Apartment) and apply this Criteria on Column P of Owner Database Sheet.
4th Filter Criteria "Minimum budget to Maximum Budget"=(7000 to 9000) and apply this Criteria on Column N of Owner Database Sheet.
5th Filter Criteria "Locality" (Range not constant) apply this Criteria on Column U of Owner Database Sheet.
After that copy filter data from these specific column from Owner Database Sheet then paste in Output sheet. Then follow the same procedure for next Tenant ID.

Please find the attached sample file.

here is the macro which i have created to automate this process but I stuck.

Regards,

Xlhelp7

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo,

Thank you for your reply.

I really apreciate your hard work producing this Amazing code.

when i run this code adding some more data in Owner Database sheet the output data which i received did not match the Criteria.

I have added new Expected Output sheet where you can see output result.

Please find the attached file.

Regards,

Xlhelp7

The criteria are located @ row 8
only criteria i see in this row =City Noida, so normal it gives all records with Noida

Kind regards
Leo

Hi Leo,

Thank you for your reply.

I have created a macro by recording but it is working only for 5 Tent ID but there may be more than 5 Tent ID's so i want to run this macro in loop.

I Have no Idea how to create a loop.

Request you to please help!

Regards,

Xlhelp7

Maybe

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo,
Thank you for your reply - much appreciated.
Leo, that is exactly what I am looking for. Works a treat. Thank you!

Regards,

Xlhelp7