Find Range and Delete Duplicate Value In Specified Column With VB Macro

[sweetrevelation]

I've searched for many hours and I'm weary. I surrender. I can usually figure things out on my own but this - what seems easy - has me stumped.

Please see attached doc "Find and Delete.xlsx"

Inside, the value in F12 is a very important cell. Using the text value from F12, I first want to use visual basic code to find the range in column B because it will vary. This means the 'text words' column might have 50 words or it might have 2000. I have racked my brain trying to find a universal way to find a variable range.

Then I would like to search for the exact text value within this range in column B. For example, in F12 is the text word 'windows xp registry cleaner' and you can see that this value is in B9.

There will only be one exact match in column B.

I then would like the vb script to delete and remove this found value, then move left one space in column A to also delete the ID number associated with the text word. Then shift both rows up to fill the empty gap.

I have tried numerous different codes but to be honest, I'm not really sure what I'm looking for. I've tinkered with find and replace, vlookup, match, find, search, and many more.

I would be so grateful to anyone that can help me out. You have no idea!

[JONvdHeyden]

Hello

Do you only want to remove the values in F12, or do you want to remove all the words in the list starting in F12. The following fill remove the item referred to in F12 only.

Please Login or Register  to view this content.

[sweetrevelation]

Hello

Do you only want to remove the values in F12, or do you want to remove all the words in the list starting in F12. The following fill remove the item referred to in F12 only.

I want to remove the values after I concatenate the value in F12 with a few other values in my real spreadsheet. You have resolved my question!

Your code JONvdHeyden worked absolutely perfectly! Seriously, it's genius. These words can't express how thankful I am. How can I repay you?

You've given me the essential missing piece I needed to complete my project. There's no way I would have figured out how to write your code. Thank you so much for your assistance.