function filtre

[safwen]

Hello guys please i have a question 
why when i try filtre function in the same sheet of table used in the function it works well but when i write it in other sheet it doesn't work.
what is the solution please 

[#2]

Hi,
Please try to write first page name and "!" and combine it with wanted cell range.

[#3]

same problem

[#4]

@safwen Remove the other sheets name in the last argument of the formula

since you want to filter for the value in A2 of the active sheet.

[#5]

Right, this is main reason. Safwen needs to remove filterer! and he must choose active sheet range then bam