Woofy_McWoof_Woof
Board Regular
- Joined
- Oct 7, 2016
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
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
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