Forum Discussion
safwen
Jun 02, 2022Brass Contributor
function filtre
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
- Riny_van_EekelenPlatinum Contributor
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.
- Teoxengineer2301Copper ContributorRight, this is main reason. Safwen needs to remove filterer! and he must choose active sheet range then bam
- Teoxengineer2301Copper ContributorHi,
Please try to write first page name and "!" and combine it with wanted cell range.- safwenBrass Contributorsame problem