Hai,

Im not a good excel user and i have a problem here, please any one.

i got sheet1 with 2 columns like this:

code | item
100 | book2
222 | paper1
101 | book1
333 | pen1

then i got sheet2 with 2 columns like this:

code | item
100 | book2
102 | book3
101 | book1

so i want to extract all possible item and code from sheet1 that match
the code in sheet2. I need to extract the match code and item into new
sheet3.

So for example after we extract the above data i will get sheet3 just
like this:

code | item
100 | book2
101 | book1

Can anyone please help me in this matter? any suggestion with VBA
programming or anything is accepted.

Please.

Thanks.


--
sweetnet
------------------------------------------------------------------------
sweetnet's Profile: http://www.excelforum.com/member.php...o&userid=31809
View this thread: http://www.excelforum.com/showthread...hreadid=515318