Replicate spreadsheet box over a spreadsheet with Macros/VBA

JimBar

New Member
Joined
Feb 12, 2015
Messages
2
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.
tzIwitY.png
0AXY6OO.png
sYxN8zX.png
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top