excel如何实现在任意单元格中输入内容后自动在输入内容的前面加入从另一sheet中匹配出来字段？

Private Sub Worksheet_Change(ByVal Target As Range)Dim xx As Range, i As LongFor Each xx In Targeti = 2Do While Sheet1.Cells(i, 1).Value "" If Sheet1.Cells(i, 1).Value = xx.Value Then xx.Value = Sheet1.Cells(i, 2).Value & " &quo