Find & replace Japanese to English

[my8950]

Trying to create a tool to convert Japanese characters to English.

I use a software tool that generates a CSV file, problem for me is, most of the column names are Japanese.
What I have done so far is copy the Japanese and input to column B in spreadsheet, and then put google translate into column C.
I'm on my 150th term and I still have many to go.
I figured I should start working on this to see if it is logical to even try.
Basically I want to make a tool that will look in the output file and find any of the terms in Column B, and convert them to column C.

Does this sound do-able? I think so, but I'm looking for some suggestions and ideas.

Thank you!

 

[mrmmickle1]

This should be the range you want to replace items in not the find table...

[COLOR=#333333]Set ReplcRng = Sheets("[/COLOR][COLOR=#ff0000][B]find[/B][/COLOR][COLOR=#333333]").Range("[/COLOR][B][COLOR=#ff0000]B2:B117[/COLOR][/B][COLOR=#333333]") 'Your Replace Range Here Change Sheet Name and Range[/COLOR]

These are on a different worksheet with a different range right? The Japanese character range you would like to translate to English based on the find table