Compare & change data correct by vba

[ngocanh87]

Hello all,

I have DETAIL (CHI TIET) sheet at O column need to change properly as Sheet1 H&I column. Thank all
Ex: O16: LSD2 -> SS2 (compare with sheet1)
O26: LSD1 -> SS1 (compare with sheet1)
.......

 

[ngocanh87]

I think I can user Vlookup then copy & paste value into O column, but I want aske for vba better, thank you

 

[ngocanh87]

I used vlookup. Thank all