Cleanup Credit Card Merchant Names Using VBA

[austinb]

Hello all,

I'm basically looking to create a macro that will search a column of cells for text from a list located on another tab and if found, replaces the text in the original cell with the text from the cell in the other tab.

For example,in Sheet1, B2 = 7-ELEVEN 38587 00073PITTSBURGH PA & B3 = 7-ELEVEN 38671 00073COPPELL TX

I would like the macro to search data found in Sheet2 for "7-ELEVEN" (not case sensitive) and replace both cells B2 & B3 in Sheet1 with just "7-Eleven".

This is somewhat of a continuation of a posted question that hasn't been updated since August of 2019 (Bank Transaction Description/Merchant Cleanup & Auto Categorize (like Mint)).

I am a VBA newbie and any help would be greatly appreciated. Thank you

-Austin

 

[ER_Neha]

Hi Neha,

Thank you for your time however I could not get this to work for me. It doesn't appear to be doing anything when I run it.

You have to change the sheet name according to your workbook, then it will work for you.

The code line - sheets() , here inside parentheses you have to mention your sheet number or name accordingly.