Filter specific table column in excel with two criteria in another sheet

HOW CAN we filter table for two criteria and copy the result in another sheet?

for example wwe have student data table and there is more than 10 columns such as name,student id,phone,address,class,age,birthday, .....

now we want have just student name , birthday and age for students that their age is 15 in another sheet

how can we do this?

i need it for dashboard ,

i can write "for loop" to find the result but i look for better way

Hello Alinaim,

Could you please upload a sample of your workbook so that we can better understand your issue. Instructions on how to upload a sample are described in the gold coloured banner at the top of this page.

Thank you Alinaim.

Cheerio,
vcoolio.

Here is sample file for the question.

Hello dear
thanks for your answer
i think this file will explain the problem

Thanks...
The code works great

but

would you explain the code?
I dont understand the how does it works?

I thought there should be simpler way to do this like using advance filter or object list

and can we solve the problem without evaluate
and solve it wit vba tools not refer it to excel

thanks a lot

and adding to your code
we can use
table.ListColumns("*****").Index
to make it more dynamic

but a question left
would you explain about .parent in this cod?
i have not seen this cod before

thanks, question completely solved