I am in need of a way to dynamically build a table based on the a few parameters that I enter in my worksheet. For example, say that I have a cell that allows me to enter the number of names per team and another cell that asks how many teams...so I put in [5] names per team and [3] teams. I would like to be able to dynamically create a table that in the first column contains the team number (1 through 3) and the second column contain the number of the name (1 through 5) like so:
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
2 4
2 5
3 1
3 2
3 3
3 4
3 5
But if I change the number of names per team to [10] it expands the second column to allow for 10 values. I can do this using VBA but I was wondering if there was a trick using formulas.
BTW, I am using 2003 for now. Thank you in advance for your help.
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
2 4
2 5
3 1
3 2
3 3
3 4
3 5
But if I change the number of names per team to [10] it expands the second column to allow for 10 values. I can do this using VBA but I was wondering if there was a trick using formulas.
BTW, I am using 2003 for now. Thank you in advance for your help.