|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
a = Sh.Name
If Sh.Name <> "一览表" Then
Rrow = ActiveSheet.UsedRange.Rows.Count
If Target.Row = Rrow Then
If Target.Column = 2 Then
ThisWorkbook.Sheets("一览表").Range("a100000").End(xlUp).Offset(1, 0).Value = Target.Value
End If
If Target.Column = 6 Then
ThisWorkbook.Sheets("一览表").Range("b100000").End(xlUp).Offset(1, 0).Value = Target.Value
End If
If Target.Column = 8 Then
ThisWorkbook.Sheets("一览表").Range("c100000").End(xlUp).Offset(1, 0).Value = Target.Value
End If
If Target.Column = 20 Then
ThisWorkbook.Sheets("一览表").Range("d100000").End(xlUp).Offset(1, 0).Value = Target.Value
End If
If Target.Column = 24 Then
ThisWorkbook.Sheets("一览表").Range("e100000").End(xlUp).Offset(1, 0).Value = Target.Value
End If
End If
End If
End Sub
输入代码即可 |
|