Index Generator - Help with Permutations

[StaufferLasagna]

Hello,

I just joined because I need help with an index generator that I am working on.

I have been asked to create an index of all possible combinations of atributes from different sheets. For example, I may have three sheets:

Size Sheet
Small
Medium
Large

Magnitude Sheet
Dark
Dim
Average
Bright

Weight Sheet
Light
Manageable
Heavy

I would need to assign unqiue index numbers to each line item on each sheet (which I have already done), and create a macro which lists every possible combination of the attributes on another sheet (the index). An example index might look like this:

ID Description
01_01_01 Small_Dark_Light
....
...
03_01_02 Large_Dark_Manageable
....
....

and so on, but for ALL possible combinations of the attributes. You should know that I have far more line items than I list in the example here, but the total number of line items should fall below the excel max of 65k.

I would post my current VBA code for his, but I am so sure its completely wrong that I would prefer a fresh start.

Any help that someone could give would be much appreciated.

Regards,

Garrett

 

[StaufferLasagna]

Let me know if you need more information, and I will do my best to provide it.

Thanks again.

Garrett