Picture this - I want to be able to create a (...non-VBA solution would be preferred...) table of X- and Y-coordinates based on user input for up to a 5x5 grid. The user enters the number of rows (say 2) and then the spacing between each. They do the same thing for number of columns (say 3) with the required spacing. I already set up data validation so that the number of rows and columns do not exceed 5. So in theory there can be a 1x1 or a 5x5 and everything in between.
My question is this - how can I then use that input to create a table of X- and Y-co-ordinates for the full ranges of values? Assume that the first point (row 1, column 1) starts at 0,0. For example if the user inputs:
Number of rows = 2
Number of columns = 3
Spacing between rows = 125mm
Spacing between columns = 150mm, I would expect the table to return these values:
X Y
0 0
150 0
300 0
0 125
150 125
300 125
Bonus for 20 points - how could I then plot these as discrete points on a chart?
My question is this - how can I then use that input to create a table of X- and Y-co-ordinates for the full ranges of values? Assume that the first point (row 1, column 1) starts at 0,0. For example if the user inputs:
Number of rows = 2
Number of columns = 3
Spacing between rows = 125mm
Spacing between columns = 150mm, I would expect the table to return these values:
X Y
0 0
150 0
300 0
0 125
150 125
300 125
Bonus for 20 points - how could I then plot these as discrete points on a chart?