Hello everyone.
The purpose of the worksheet is to assist in generating x and y coordinates by entering information at Range C2:C13. The inputs are for:
Rows Per Group
Columns per Group
Starting X-Coordinate
Starting Y-Coordinate
Starting Z-Coordinate
Rectangle Width
Rectangle Height
Distance between horizontal groups
Distance between vertical groups
Number of horizontal groups
Number of vertical groups
Define Quadrant.
Cells in the Range E2:CZ101 calculate the x and y coordinates based on the user defined number of rows and columns per group and the number of groups and the desired orientation.
My challenge is extracting vectors from the multiple dynamic matrices that result from the above information. For example, I have my first 2 row 3 column group at E2:G3, a second group at H2:J3, a third group at K2:M3, a fourth group at E4:G5, and so on till we end with the ninth group at K6:M7.
I would like for the coordinates to list vertically in order by group. The individual groups should take the order of left to right, top to bottom and move to the next group to the right. Referencing the example above, the cell values should appear vertically in this order:
E2, F2, G2, E3, F3, G3, H2, I2, J2, H3, I3, J3, K2, L2, M2, K3, L3, M3, E4, F4, G4, E5, F5, G5, H4, 4I, J4, H5, I5, J5, K4, L4, M4, K5, L5 M5 and so forth until we end with the values at M7.
To whomever is reading this and attempting to help, I appreciate your effort and time. This is my first forum post and I appreciate any advice on posting in the forums. I originally crafted this post with the intent that I would attach my workbook, but then realized I was not able to attach a file.
Thanks again for your help.
The purpose of the worksheet is to assist in generating x and y coordinates by entering information at Range C2:C13. The inputs are for:
Rows Per Group
Columns per Group
Starting X-Coordinate
Starting Y-Coordinate
Starting Z-Coordinate
Rectangle Width
Rectangle Height
Distance between horizontal groups
Distance between vertical groups
Number of horizontal groups
Number of vertical groups
Define Quadrant.
Cells in the Range E2:CZ101 calculate the x and y coordinates based on the user defined number of rows and columns per group and the number of groups and the desired orientation.
My challenge is extracting vectors from the multiple dynamic matrices that result from the above information. For example, I have my first 2 row 3 column group at E2:G3, a second group at H2:J3, a third group at K2:M3, a fourth group at E4:G5, and so on till we end with the ninth group at K6:M7.
I would like for the coordinates to list vertically in order by group. The individual groups should take the order of left to right, top to bottom and move to the next group to the right. Referencing the example above, the cell values should appear vertically in this order:
E2, F2, G2, E3, F3, G3, H2, I2, J2, H3, I3, J3, K2, L2, M2, K3, L3, M3, E4, F4, G4, E5, F5, G5, H4, 4I, J4, H5, I5, J5, K4, L4, M4, K5, L5 M5 and so forth until we end with the values at M7.
To whomever is reading this and attempting to help, I appreciate your effort and time. This is my first forum post and I appreciate any advice on posting in the forums. I originally crafted this post with the intent that I would attach my workbook, but then realized I was not able to attach a file.
Thanks again for your help.
