Macro to filter, sort, and then display top 20 rows based on value in particular cell

[shaunguyver]

I have a work sheet called 'Risk Register' with a data range comprising 100 rows, and 36 columns.

I would like to have a macro that does the following:

1) Filters the range to show only those with 'Threat' in column C

2) Of those showing after step 1, filters OUT rows with 'Removed/Passed' in column D

3) Sorts the range according to values in column Q, with largest at the top

4) Finally, filters the data range to show only the top 10 values based on column Q (still in ascending order)

... I would also like some code that clears the effects of the above macro.

I have tried doing this myself, and was successful up until point 4. However I fear that successful implementation of point 4 will require a re-think of points 1-3, hence why I'm turning to Excel Forum for help!

I attach the spreadsheet.

Many thanks in advance for whoever cracks it!

[Parth007]

Hi Shaun,

The file is password protected...

[shaunguyver]

Apologies - I knew I'd forgotten something!

Please find attached version without password protection.

[shaunguyver]

Is this not possible?