Hi All,

I dont know how to explain this so here is the example.

This contains 2 lists.
List1 is column A&B unique ID in A.
List2 is column C&D unique ID in B.
A B C D
1 Value 1 Apples Value 2 Basket 2
2 Value 2 Pears Value 3 Basket 3
3 Value 4 Oranges Value 5 Basket 5
4 Value 6 Bananas Value 6 Basket 6
5 Value 7 Figs Value 8 Basket 8


I would like to run a routine so the result is as follows:
A B C D
1 Value 1 Apples
2 Value 2 Pears Value 2 Basket 2
3 Value 3 Basket 3
4 Value 4 Oranges
5 Value 5 Basket 5
6 Value 6 Bananas Value 6 Basket 6
7 Value 7 Figs
8 Value 8 Basket 8

Does anybody have any code that does something like the above or can point
me in the right direction?

The list is likely to contain up to 2000 rows and may have more that 1
column which is an attribute of the unique ID.

Any help gratefully received

Regards

Michael Beckinsale