how do i create a report from a matrix
Hello again,
I have a matrix that I want to export into word as a report. I have 3 worksheets in my spreadsheet, 2 are lists with names and other info and 1 matrix (which uses the names from the 2 lists as the headers). I now need to create lists that represent the matrix in text form that also has details from the other 2 sheets. eg My Matrix Dep1 Dep2 Dep3 Dep4 Sw1 x x Sw2 x x x Sw3 x x Sw4 x x Text Form Dep1 - Sw1, Sw1 info, Sw2, Sw2 info, Sw4, Sw4 info Dep2 - Sw2, Sw2 info, Sw3, Sw3 info Dep4 - Sw1, Sw1 info, Sw3, Sw3 info I hope that makes sense, Thanks in advance, d |
All times are GMT +1. The time now is 07:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com