I'm not sure if this is possible, but I figured this is the place to find out. So here goes. The end result of my Excel sheet will be 3 columns, which I will eventually send to .csv format.

I have Main Entities (call them numbers), sub entities of the number (uppercase letters), and sub-entities of that (lowercase letters). Confused yet?

I want a prompt that asks how many main entites the user has......i.e. 3
and how many subentities....say 4
and how many sub,sub entities....2

Based on these I want a sheet that produces the following results:
1,1,1
1,1,2
1,2,1
1,2,2
1,3,1
1,3,2
1,4,1
1,4,2
2,1,1
2,1,2
2,2,1
2,2,2
2,3,1
2,3,2
2,4,1
2,4,2

So the first three columns of the sheet present every possible combination.

If this is possible, can anyone tell me how? Thanks!!!