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


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to reference Assemblies in the GAC
http://www.eggheadcafe.com/tutorials...-assembli.aspx