Hello,
I am trying to generate multiple tables in word document from a table in excel.
I have included a mock-up version of the excel file that is my starting point and an example of my desired word output. In the first 3 columns of the excel file I have Controls, Tests, and Results (CTR). Columns 4 to 9 are criteria. For each row, I have determined if the CTR applies to each of the criteria. I need one row for each CTR that has a "YES" for each criteria.
How can I go about creating a macro to take this information from excel and move it to multiple tables in a word document?
Ultimately, I will apply this to excel files with approximately 80-100 CRTs and 80-120 criteria. So this macro would ultimately create 80-120 tables in the word document (3 columns and approximately 2-5 rows)...
Any thoughts are greatly appreciated!!!
Bookmarks