- Joined
- Apr 25, 2018
- Messages
- 3
- Reaction score
- 0
Hi,
I've an Excel file in which there is a huge matrix (close to 70 rows and 25 columns, mostly Y/N). I need to add this to a Word document. Since this is a living file, inserting as attachment is not an option. Normal copy/paste or creation of table is also out of the question since it looks untidy and is difficult to comprehend.
I was thinking about this solution. Create a table with three or four important columns with corresponding entries. And, create two drop-down lists in the next column for each row, one with the remaining column title entries, and the other with the corresponding value (Y/N, other values). How can this be done?
I can create a list and populate with the column titles (first list). How can I create another list by its side, where when in a specific row a specific title from the first list is created, corresponding row value should appear in the second list?
I've an Excel file in which there is a huge matrix (close to 70 rows and 25 columns, mostly Y/N). I need to add this to a Word document. Since this is a living file, inserting as attachment is not an option. Normal copy/paste or creation of table is also out of the question since it looks untidy and is difficult to comprehend.
I was thinking about this solution. Create a table with three or four important columns with corresponding entries. And, create two drop-down lists in the next column for each row, one with the remaining column title entries, and the other with the corresponding value (Y/N, other values). How can this be done?
I can create a list and populate with the column titles (first list). How can I create another list by its side, where when in a specific row a specific title from the first list is created, corresponding row value should appear in the second list?
