I'm looking for a piece of software that will come up with
combinations of two separate lists.  For instance, let's say I have
the following lists:

List A
------
Blue 
Red 
Yellow

List B
-----
Plane
Car 
Boat

I want a piece of software that will automatically output the
following list:

List C
------
Blue Plane
Blue Car
Blue Boat
Red Plane 
Red Car
Red Boat
Yellow Plane
Yellow Car
Yellow Boat

Alternatively if this could be done using Excel or Word then that also
would be an acceptable answer.  I can't believe this is too hard to do
but haven't been able to figure it out on my own.

---

Request for Question Clarification by answerguru-ga on 12 Aug 2003 19:16 PDT

Hello,

While this is possible in both MS Excel and Access, you may want to
consider re-evaluating your price as the Excel solution would require
some VBA programming. The Access solution is a little more straight
forward but you have not indicated whether or not you have this
software.

answerguru-ga

---

Clarification of Question by jpbischke-ga on 14 Aug 2003 02:45 PDT

Unfortunately I don't have Access and even if I did I haven't used it
very much so I'm guessing that might be a bit more difficult for me.

On the other hand, I have done VBA programming in Excel so I might be
more comfortable with that solution.

---

Request for Question Clarification by answerguru-ga on 14 Aug 2003 07:12 PDT

OK, in that case I can offer two options:

1. Creation of a VBA procedure that performs this process

2. A description of how a VBA procedure would go about accomplishing
this task

Considering your list price, it seems that (2) is the most appropriate
choice, however, if you want a complete VBA macro to do this I suggest
you re-evaluate your list price to account for the level of effort and
time required to complete this type of task.

Thanks,

answerguru-ga

---

Clarification of Question by jpbischke-ga on 14 Aug 2003 08:35 PDT

Option #2 would be sufficient as my guess is that I would be able to
figure it out from there.  And if isn't sufficient then I can create a
new question asking for the actual procedure code.

Hi jpbischke-ga,

As requested, here is an outline of how to write a VBA procedure that
will accomplish your desired result:

The best way to go about this is to create two nested 'for' loops such
that "List B" is scanned completely for each row in "List A". Within
the nested loop, you will be able to obtain both the values necessary
to create a concatenation. The resulting string can then be stored in
the appropriate row in "List C". There are a couple ways to determine
the appropriate row for outputting the result (assuming the column
would remain constant):

1. Define a counter that increments each time one iteration of the
inner loop completes and then use that value as your row.

2. Perform a calculation using the indices in your two 'for' loops to
determine the correct row - it seems this would be similar to the
following:

((currentOuterLoopIndex - 1)*totalElementsInListB) +
currentInnerLoopIndex

Hopefully that should get you started - have fun :)

Cheers,

answerguru-ga

Great answer.  Thanks for the concise explanation!