Forum Discussion

safwen's avatar
safwen
Brass Contributor
Jun 02, 2022

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.

    • Teoxengineer2301's avatar
      Teoxengineer2301
      Copper Contributor
      Right, this is main reason. Safwen needs to remove filterer! and he must choose active sheet range then bam
  • Hi,
    Please try to write first page name and "!" and combine it with wanted cell range.

Resources