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

Originally Posted by akhtar151

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

akhtar, your post didn't make much sense!, also a pdf is of no use to us you need to upload a sample workbook for people to help you with!