7 Replies Latest reply on Jan 7, 2013 1:53 PM by Yigang Chen

    How to use filtered values in one worksheet as the filter in another worksheet?

    Yigang Chen



      In one of my worksheets I have a table showing some campaign categories by a date range filter:


      I'd want to (1) use these categories (Combo, HE, and Tech) as the filter in another worksheet. Further, I'd want to (2) be able to select the categories. So ideally this table would be something similar to a quick filter:


      Is there a way to achieve these two goals?

      Your help is greatly appreciated.