Extracting items from a large excel list using a sperate excel list.

[Nambi_]

I have a huge list of products "Big List"

In the big list i have paint codes, these "paint codes".

I have another list "New Formulas" which also has "paint codes"

These sample sheets are available here.

https://www.dropbox.com/s/fcx87ese3z...heets.zip?dl=0

I need to extract all the items from the "Big List" that match the paint codes in the "new formula" list onto a separate sheet.

the Big list is huge! it over 15,000 rows for this example I have scaled it down to under 1000.

Would anyone have a way of doing what I need?

In the big list the same paint code will populate 7-10 rows I would need all the information on these rows.

Similar to this below, This example is for One "paint code" I would need this for all 137 "paint codes"


PN-0887-LT 8 I RM54973 TORON 25 W
PN-0887-LT 7 I RM52862 TORON 25 W
PN-0887-LT 6 I RM51921 TORON 25 W
PN-0887-LT 5 I RM56023 TORON 25 W
PN-0887-LT 4 I RM30758 TORON 25 W
PN-0887-LT 3 I RM37130 TORON 25 W
PN-0887-LT 2 I RM90010 TORON 25 W
PN-0887-LT 1 I RM20118 TORON 25 W


please see the list I attached in dropbox, the zip file contains 2 files the "big list" and the "new formulas"

[LeoTaxi]

with both sheets in same book

Please Login or Register  to view this content.

Kind regards
Leo

[Nambi_]

This Marco worked like a charm this is very much appreciated.

I analyzed the results and it worked 100%

thank you very much!