Hi,
I have the task of creating individual entries in Excel for a bunch of
different variables.
For example, the variables could be:
Color (Green, Red, Blue, Yellow)
Size (1', 2', 3', 4', 5')
Quantity (10, 20, 30, 40, 50)
Now, I would need to create an entry for each possible combination of
these variable. Example:
Green, 1', 10
Green, 1', 20
Green, 1', 30 and so on...
Is there a way in Excel or Access to auto-generate all the possible
combinations into individual rows? I've started by doing a lot of
copying and pasting, but this method seems too time consuming.
Any ideas??!
Thanks!
Dave B.
--
zimbound
------------------------------------------------------------------------
zimbound's Profile:
http://www.excelforum.com/member.php...o&userid=36597
View this thread:
http://www.excelforum.com/showthread...hreadid=563398