I have a table (lets call it table 1) with multiple rows and columns on sheet 1.
On sheet 2, I have a second table with a series of cell values (table 2) that correspond to certain cells in table 1.
I would like to use these values to filter the rows that contain these values in table 1 and output them in a separate table (table 3) on sheet 3.
I have done this with an advanced filter, but I need to constantly repeat this step with varying table 2 values.
Ideally, I would like table 3 output to be automatically updated based on changes in table 2.
Can anyone advise me on how I can achieve this with a macro? (PS: I am a total newb with macros - sorry guys)
On sheet 2, I have a second table with a series of cell values (table 2) that correspond to certain cells in table 1.
I would like to use these values to filter the rows that contain these values in table 1 and output them in a separate table (table 3) on sheet 3.
I have done this with an advanced filter, but I need to constantly repeat this step with varying table 2 values.
Ideally, I would like table 3 output to be automatically updated based on changes in table 2.
Can anyone advise me on how I can achieve this with a macro? (PS: I am a total newb with macros - sorry guys)