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

      Hi,

       

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

      capture.20130107.PNG

      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:

      capture_20130107_2.PNG

      Is there a way to achieve these two goals?

      Your help is greatly appreciated.