I want a macro for a workbook that would essentially do this.
The main sheet would have 4 variables in it. The variables are shown in cells C2:C5 and there corresponding values in cells D2:D5. There would also be 2 macro buttons on the main page. The first button would create a 3X3 box, with K as the column variables and L as the row variables.
When the variables are written in, the second macro button is applied. This creates a sheet; 1,1 ( the Top Right Hand Corner value). This replicates the values M times as columns and N times as rows. I would like the value in the centre box to increase by A units to the right and B units Down along the sheet.
I would then like the second sheet; 1,2 (The column next to the top Right hand Corner) To then replicate what is shown in 1,2. It is essentially built like a matrix.
Attached is a file and photos of the document I would like. Appreciate the help I get. Thank You.
Here are the three Images of what the workbook looks like.
The main sheet would have 4 variables in it. The variables are shown in cells C2:C5 and there corresponding values in cells D2:D5. There would also be 2 macro buttons on the main page. The first button would create a 3X3 box, with K as the column variables and L as the row variables.
When the variables are written in, the second macro button is applied. This creates a sheet; 1,1 ( the Top Right Hand Corner value). This replicates the values M times as columns and N times as rows. I would like the value in the centre box to increase by A units to the right and B units Down along the sheet.
I would then like the second sheet; 1,2 (The column next to the top Right hand Corner) To then replicate what is shown in 1,2. It is essentially built like a matrix.
Attached is a file and photos of the document I would like. Appreciate the help I get. Thank You.
Here are the three Images of what the workbook looks like.
