I think you'll have to share how you came up with the relationships in your
sample data.

I don't see anything that could help me figure it out.



jlburak wrote:

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!

--

Dave Peterson