View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] amorrison2006@googlemail.com[_2_] is offline
external usenet poster
 
Posts: 53
Default Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows.

Hi everyone

I pretty much summed everything up above.

Thousands of rows of data most of which is useless but I thought the
best way to delete would be to find in column A the word "Initial" and
if the cell immediately after is "Final" delete both rows. If not
then this is a good row and it should continue until it finds the next
occurrence of "Initial"

I hope I make sense,

Thanks alot in advance,

Andrea