Creating Combinations from Two Lists
I have data in two lists on two different worksheets. The data is laid out as:
Worksheet A
A
B
C
Worksheeet B
X
Y
Z
I need to define the relationship between each element in a vertical
setting, In the past I have used cut and paste but am hoping to write a macro
that would create the relationships for me. For example:
Col A Col B Col C
A X
A Y
A Z
X A
Y A
Z A
Does anyone have any thoughts if this is feasible or not?
Thanks!
|