Hi, i have attached the excel workbook. it has 2 sheets. the requirement is copy the product id from sheet TRS and search in sheet AP and if found copy the value present under that number highlighted in yellow and paste it in sheet TRS under offshore column. i want to loop this until the product id is finished using VBA.