I haven't seen this anywhere. I'd like to combine a group of single arrays to
a multi-dimension. The item array(s) have 5 characteristics (e.g. A,B,C,D,E).
I'd like to make a new product family array that consists of all the item
arrays
(e.g. A,B,C,D,E
F,G,H,I,E
A,G,H,J,K)
Then I could use the product family array as a look up table to extract
info. I'd like to get away from creating a worksheet to store the info, since
it would only be temporary. Also, since new items are introduced every 6
months I can just add a new single item array, and then rebuild the product
array.
Any ideas?
TIA,
SK