none
Autofilter based on 2 cells and comboboxlist to another sheet in excel RRS feed

  • Question

  • Hello,

    I have a question regarding creating macros whereas the scenarios as follows:

    Sheet2
    Upon clicking any cell in Sheet2, it will automatically filter based on cell A3, B3 and combo list.

    Sheet1
    Automatically display filtered criteria based on selection (A3, B3, and combo list ) click from Sheet2.

    For example: when I double click on F3, on Sheet2 will automatically diplay filtered data based on A3, B3 and list in the combo box (Eg:T2)  and same thing goes to if I double clik on F4 on Sheet2 will automatically diplay filtered data based on A4, B4 and list in the combo box.

    As all the data in Sheet1, it should automatically filter up only relevant data.

    Wednesday, November 14, 2012 6:16 AM

All replies