Hi all,

I am new to using excel and I have come into a small problem.

I have a lot of data and I want to be able to have the filtered data be copied into a separate worksheet

Example
Case subject line read Battlefield is crashing

I want to search using the keyword "crash" grab all the data within the pivot table and copy it over.


Can that be done?

I have tried slicers but it doesn't work.