Automatization of a table in Excel from the Word document text

The task is to transfer a list of questions (question_1, question_2,...) in different languages (language_1, language_2,...) with the variants of answers (variant_1, variant_2,...) from the Word document to the Excel table so that different translations of one question are positioned horizontally and the variants of answers are positioned vertically under the questions.
To automatize data transfer, a macro for Excel is created that reads a Word document, sets out the text language and text questions, answers options, and forms the final table. If it’s impossible to resolve the complex questions, the macro releases a list of problem lines that can be quickly corrected in the Word document.
#vba #excel #vbaexcel #word