What I sent was tested and will work, without any sorting, if properly
modified to your data.

--
Don Guillett
SalesAid Software

"Oreg" wrote in message
...

anilsolipuram & Don, Neither macros were working for me so I went back
to my original message and noticed I mixed up my columns and should
have been more descriptive. I tried to modify your macros with no
luck.. Column (F) is a list of IDs. Example: IWEC432151,
IWEC968489..... In column (F), each IWEC # shows up twice. In Column
(G) are other numbers associated to the IWEC #. Example: 1,2,5,15....
The outcome I am hoping for is a macro to search column G, list each
IWEC number once in column (H), match the data in Column (G) and list
it in Columns (I) & (J).

Example:
Columns F G H I J
IWEC456934 1 IWEC456934 1 5
IWEC790234 2 IWEC790234 2 15
IWEC456934 5
IWEC790234 15

Thanks,
Oreg


--
Oreg
------------------------------------------------------------------------
Oreg's Profile:
http://www.excelforum.com/member.php...fo&userid=9195
View this thread: http://www.excelforum.com/showthread...hreadid=380308