Set Filter conditions for excel workbook

I have data with 5000 rows, I filter the rows to be left with 100-200 rows.

My question is :
Is it possible to set predefined filters and only keep the filtered rows, the rest should be deleted (not even hidden)

I tried using advance filter but after I filter everything goes blank.

EDIT:
How I plan to use the file:
1) download raw data from web
2) copy and paste the data in my excel workbook
3) click 1 button to filter the data as per my pre defined conditions
or
4) just paste the data and upon pasting only the filtered data remains, rest is deleted.


Any help on this will be greatly appreciated.

Thanks & regards,
Mukul

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Making a few assumptions.
1. New data is always pasted into the same sheet
2. Symbol names are unique
3. When new data is pasted it is not in table format.
If all of that is true then on a separate sheet (Sheet2) the following could be placed once and left in place:
1. Column headers in A1:P1
2. Formula for A2:A250

Formula:

Please Login or Register  to view this content.

3. Formula for B2:P250 =IF(A2="","",INDEX('sec_bhavdata_full (1)'!B$2:B$2000,MATCH($A2,'sec_bhavdata_full (1)'!$A$2:$A$2000,0)))
Let us know if you have any questions.