'VBA:请将下列加于表2的 Worksheet_Change事件中 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Dim x%, y% y = 2 While Not IsNull(Sheets("表1").Cells(y, 1)) x = 2 If Sheets("表1").Cells(y, 1).Value = Target.Value Then While Not IsNull(Sheets("表1").Cells(y, x)) Sheets("表2").Cells(Target.Row, x).Value = Sheets("表1").Cells(y, x).Value x = x + 1 Wend End If y = y + 1 Wend End If End Sub