find word and highlight

Hello

Dear All Member's

I have a box. S/N mention on box (12345 etc...) and (10) boxes more in first box and ESN mention on box. but (10)boxes of ESN Diffrent.i have data on my excel sheet I want, when i find data (ESN) then auto match serial no then auto fill color and auto copy to other sheet.don't move other sheet data.If anyone have VBA code then tell me and tell me about this work if you have any solution


Thanks