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
|