Hi All
I need assistance with the following:
I need to search Sheets("ITEM LIST") for the products in Sheets("SUPPLIER BREAKDOWN") and copy then paste the relevant code from Sheets("ITEM LIST") to Column Code in Sheets("SUPPLIER BREAKDOWN").
I have attached a sample worksheet with example of outcome in Sheets("SUPPLIER BREAKDOWN") .Range("A3") & Range("C3").
The above example result comes from Sheets("ITEM LIST").Range("A102") & Range("A144")
Thank you in advance.
Bookmarks