Hi,
I have two tabs - a tab called "Pricing" and a tab called "Funds to be removed"
I am trying to find all instances that occur within a cells in column H on the Pricing tab and delete that row if part of the cell is in column A on the "Funds to be removed tab.
For example: Funds to be Removed tab in column a would show "Jon" - in column H on Pricing there will be multiple instances of with the word "Jon" in column H like "12368_Jon", "6548244_Jon", etc
The code below is what I have written and seems to work but for some reason it does not delete all instances from the pricing tab. I wonder if there is something wrong with either the code or perhaps merged cells or blank rows are screwing up the code.
Any assistance would be greatly appreciate!
Bookmarks