That works wonderfully as always XLD. Thanks

How can i add another step to go to the next page named "Locations" and do the same things by deleting blank rows by going down column "B".