Edi
07-10-2011, 11:49 PM
Hi,
I have a list of the following variables:
Geography: AU, NZ, UK, HK, TW, SING
Camp: Global,Local,Regional
Capacity:1,2,3,....,60
Is there a quick way to create a list of the possible combinations of these variables in vba? For example,
AU-Global-1
AU-Global-2
...
AU-Global-60
AU-Local-1
...
SING-Regional-60
Thanks!
I have a list of the following variables:
Geography: AU, NZ, UK, HK, TW, SING
Camp: Global,Local,Regional
Capacity:1,2,3,....,60
Is there a quick way to create a list of the possible combinations of these variables in vba? For example,
AU-Global-1
AU-Global-2
...
AU-Global-60
AU-Local-1
...
SING-Regional-60
Thanks!