tazz
Member
Hello all,
I need help with a matrix assembly. I have a number of matrices with headers named a1, b1, a2, etc and rows matching the headers. I would like the assembly matrix to get in cell corresponding to a1a1 all the values from the matrices and so on until all the values from all matrices go on the right spot. I did this for only 3 matrices (3x3) using index and match but every time I add another matrix I have to rewrite the code.
For a better understanding I attached the file format of my sheet.
Thank you
I need help with a matrix assembly. I have a number of matrices with headers named a1, b1, a2, etc and rows matching the headers. I would like the assembly matrix to get in cell corresponding to a1a1 all the values from the matrices and so on until all the values from all matrices go on the right spot. I did this for only 3 matrices (3x3) using index and match but every time I add another matrix I have to rewrite the code.
For a better understanding I attached the file format of my sheet.
Thank you