Hi,
I'm looking for a macro for question and answer population in excel and word.
The macro will ideally search for the list of questions (whatever they are) dropped into a table in excel and the search for the same text questions and associated answers in a database set up in a .docx file.
The reason for the use of a .docx file is that some of the answers will have images and tables as part of them.
I would then like the macro to open a new word document and drop each question and answer into it. Either in a table as question/answer or in text - with question above and answer below format.
Thank you so, so much for your help!!
I'm looking for a macro for question and answer population in excel and word.
The macro will ideally search for the list of questions (whatever they are) dropped into a table in excel and the search for the same text questions and associated answers in a database set up in a .docx file.
The reason for the use of a .docx file is that some of the answers will have images and tables as part of them.
I would then like the macro to open a new word document and drop each question and answer into it. Either in a table as question/answer or in text - with question above and answer below format.
Thank you so, so much for your help!!
