• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Apply filter selections across different tabs

Otawata

New Member
Hi!

I'm wondering whether it is possible to apply the same filter selections across multiple tabs if the title of the column matches.

I'm trying to make sure that the value filter applied to columns A-F in the attached example carry through to the same columns in the other tabs. I'm not sure this is possible. If it is, I'd appreciate the help! Thank you.
 

Attachments

  • Example 2.xlsx
    13.2 KB · Views: 8
You should be able to do that using the new Filter() function

You'll need Excel 2021 or 365

or via VBA
 
Back
Top