I need some code that can loop through Column B and look for
"STANDARD DIVIDEND PAYMENT"
Once found delete that row and move down and keep deleting rows until you find
Once this is found, delete that row as well but sop deleting rows, then restart the above process until it has looped through the count of ColA
Hope that makes sense!