Using Excel VBA with advanced filter At my workplace I often investigate a lot of different aspects of the data. One important moment is when I need to filter out and examine lots of different unique factors that corresponds to a specific event (I won’t go into detail regarding the actual real data due to secrecy in the workplace).
I noticed that my colleagues used Excels table and filter function and simply copy and pasted the results into a new sheet with the filtered data.