Entering values in a list into a macro

[Setofskills]

I have a macro that will run through a computation given two inputs on the main tab. I'd like make a matrix in a new tab with all of variable A entries across the top row and the variable B entries down the side column. I'm trying to make nested For loops to run the macro through all the possibilities and enter the resulting values in the matrix. This is proving to be outside of my abilities, any help would be greatly appreciated.

 

[Setofskills]

I have a macro that will run through a computation given two inputs on the main tab. I'd like make a matrix in a new tab with all of variable A entries across the top row and the variable B entries down the side column. I'm trying to make nested For loops to run the macro through all the possibilities and enter the resulting values in the matrix. This is proving to be outside of my abilities, any help would be greatly appreciated.

I asked too soon, I solved it with a modified version of below:

Dim r As Integer
Dim c As Integer

For r = 1 To 6

For c = 1 To 30

Worksheets("Summary").Range("a1").Value = Worksheets("Matrix").Range("c2").Offset(0, c - 1).Value
Worksheets("Summary").Range("a2").Value = Worksheets("Matrix").Range("b3").Offset(r - 1, 0).Value
Calculate
Worksheets("Matrix").Range("c3").Offset(r - 1, c - 1).Value = Worksheets("Summary").Range("g41").Value
'could be h if adjusted value was desired

Next c

Next r