Find Product Details in Another Sheet based on Product ID and Copy some Fields From there

Hi Excel Expert,


I have a list of products with Product ID and some other fields. I have another excel file which contains same products list with some extra fields which are not in first list.

The order of product listing is not same in both the list, means Product001 is on 10th row in first list while same product reside on 50th row in second list. I want extra fields to be merged in first product list.

One solution is that one needs to search for each product id in second list and copy that fields value in first list. The list contains more than 4000 products so this method is time consuming.


Is it possible to make macro which takes product id from first list search it in second list and copy appropriate fields in first list opposite to the correct product id.


I am very thankful if some one give me sample macro code or any suggestions.

Thanks dilipandey,

The code is working for product listing. I appreciate your effort to help me.

Regards,
Keval

@ kevalkothari

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.