Deleting rows between specific text

[chadski778]

How do i delete all rows between two specific strings, for example, 'density' and 'flash point' in the whole spreadsheet? The row with 'density' has to be deleted but not the row with 'flash point' on.

Thanks

 

[nightcrawler23]

Can you elaborate a bit. Does 'density' and 'flash point' occur only once in your spreadsheet. Which column is your data in??

 

[chadski778]

Yes they appear just once. They are in column B

 

[Greg Truby]

Do you need to do a lot of this? (Where we might think about helping you put together a macro to automate the task.) Or is this just a one-of situation? (Where we can just tell ya how to do 'er quick.)

 

[chadski778]

I will have to do a lot of this. We take an extract from a database but there is a lot of junk that needs deleting out. Unfortunately, I can't do a record macro because some of the data doesn't always come out in the same place

 

[Greg Truby]

Would you always look for the same word to mark the starting deletion point and the same work to mark the ending deletion point?