I need to develop a tool that will be able to check text, I only care about checking words. An Excel sheet will serve as the GUI, or if you have a better idea where to place it, I will be grateful. On the left there is text to be checked, on the right there is text from the pattern/template that is correct. Currently, the program is not immune to noise caused by separators, spaces, enters, tabs, and double spaces. Maybe someone was developing a similar text analyzer. I want him to mark repeated words in green.

PYTHON CODE:

> `https://pastebin.com/zrJgPdRS`

VBA CODE:

 > `https://pastebin.com/w8B5CqkR`

enter image description here
enter image description here