Macro for multiplying two matrices

[Woofy_McWoof_Woof]

Hi, first time user long time admirer.

I'm trying to create some code which will multiply a cell in one matrix by a cell in another matrix. In the example below I would like to create a code which calculates B16=B2*B9, then C16=B2*B9. This would continue all the way along the row until there are no more values in that row, it would then move down the next row automatically and calculate B17=B3*B10 etc. this would continue until there are no more rows to calculate.

I'm currently using a formula to calculate but I have 48 columns and over 10 years worth of days so it is taking up a lot of memory.

I hope that makes sense.

Thanks for your help.

Woof

 

[Woofy_McWoof_Woof]

Hmm, doesn't look like the picture uploaded. Failed straight away