Deleting rows between
 

I am using Excel 97, I have a text file which I am trying to clean up.

I need to keep all the rows that commence with 'Ser No', then there are a
number of rows between the next row that I need to keep namely 'Result Code'
that need deleting.

Can some one please provide me with some code which will do this?
--
Mark

Deleting rows between
 

Do you really need code?
Sort the data based on that column, then delete the unecessary rows.

If necessary, add a new column with a simple index to sort the data back to
the same order after the rows are deleted.

"Mark" wrote:

I am using Excel 97, I have a text file which I am trying to clean up.

I need to keep all the rows that commence with 'Ser No', then there are a
number of rows between the next row that I need to keep namely 'Result Code'
that need deleting.

Can some one please provide me with some code which will do this?
--
Mark