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.
Bookmarks