Hi,

In this sheet I have a matrix of values indexed from 1 to 30, and its transpose to the right.

Below the first matrix I have created the product of the two matrices. I want to create 98 of those. I tried recording a macro that I could edit to automate the process, but I'm not able to change the parameters for the MMULT function in an appropriate fashion.

The procedure was supposed to be like this:
Productmatrix 1 (in the sheet) : First column of transpose * First row of matrix

Productmatrix 2: Second column of transpose * second row of matrix
etc..

Can anyone help me?

SampleMatrix.xlsx