Getting rid of unwanted data

I know some about macros but I can't figure out how to do this properly and neatly.

Each week I import some data into my workbook (its financial-imports stock names, identiy codes and stock type). I've added a formula which calculates the credit ratings of each stock type, and then conditional formatting to highlight any credit ratings which are less than my required rating.

Further to this I need to get rid off all the rows which which have an stock type "No Asset Class".

I cant use auto-filter because there are too many other stock types which I need to be included.

Any help would be much appreciated.

Tks
Caroline

Hi Caroline

Would you mind explaining why you can't use Autofilter? If you mean by 'get rid of' actually deleting the line then Autofilter would seem the obvious choice (filter on "No asset class" and then delete the visible lines).

Richard