Sorry relationships is probably the wrong word to use. For something specific
to my business, I need to submit a request to a team that basically says what
product one person can transfer to from another. At the end of the day I need
to supply to the team that updates a table an excel file in the format

Column A Column B Column C
Orig Product Allow/Don't Allow Desitnation Product

Column B must be manual, but I was hoping there might be a way to
pre-populate the template with A and C so I didn't have to copy and paste so
many times.

Thanks for your help.



"Dave Peterson" wrote:

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