Hi,
I have this excel sheet,where in sheet 1,I have a search option,If I give a 8 digit unique letter in the search option,in the sheet it will search for that item in column D of sheet 2 and if it gets that it will copy that row and paste it in sheet 1 row 5