Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Matrix Problem | Excel Discussion (Misc queries) | |||
Create a report from different files | Excel Discussion (Misc queries) | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) |