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