I have two worksheets, each having the primary key values stored in
column A. I want to create a new worksheet wherein each value in Column
A of worksheet 1 should join against each value in Column A of worksheet
2 and be stored in column A and B of the new worksheet.

Therefore, if Worksheet 1 and 2 look like:
Wk1-Col-A Wk2-Col-A
100 23
101 45
60
Wk3-Col-A-and-B should look like:
100 23
100 45
100 60
101 23
101 45
101 60

Any idea how to do this using macros or any other worksheet function?

Thanks so much for your help!


--
rkg
------------------------------------------------------------------------
rkg's Profile: http://www.excelforum.com/member.php...o&userid=22818
View this thread: http://www.excelforum.com/showthread...hreadid=570446