Hi guys,

I am trying to solve this but I am not familiar with macros so here I am.

I am trying to translate the document but since there is a lot to work on manually, would like to utilize a macro to solve this, and would like your help.

I have a translation table with somethng about 700 lines
Japanese(column A) to English (column B).

There are multiple sheets, in total of 7 sheets with cells scattered with Japanese texts.

Translation table is like the following.
Column A Column B
1 Aaaaaa Bbbbbb
2 Cccccc Dddddd
3 .... .....
700 Yyyyy Zzzzz

Then other sheets include pictures and text boxes, memos and text cells scattered all over the sheets.

I converted the file into a text file for easier translation and put them back in the excel file after adding a new sheet.

I would like to replace all texts in separate 7 multiple sheets according to the translation table located in the last sheet. Unfortunately I can't disclose the document, but I can prepare a sample if needed.

Also, it might help to replace as if it finds first 15 or less strings of characters in Japanese to replace with english sentences since there are many similar texts.(wildcard-ish behavior)

Could please anyone help? Thank you in the advance!