Hi

I'm trying to delete rows in excel which meet certain criteria without much success.

I have a spreadsheet with 13 columns and column F is an indicator which contains either "mortgage" or blank.

I need to delete all the rows in the spreadsheet that contain nothing in column F. The data will be refreshed on a daily basis so will have a varying number of rows.

I'm trying to create a macro in Excel 97, that when run, will delete all the rows but my VB knowledge is very limited.

Any help will be much appreciated.

Thanks