|
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Address = "$A$1" Or Target.Address = "$A$2" Then
- Dim x, y, rngA, rngB
-
- x = [a1]: y = [a2]
- Set rngA = Range("d3:z4")
- Set rngB = Sheets(x).Range("a:a").Find(y)
- Application.EnableEvents = False
- '分表
- If Not rngB Is Nothing Then rngA.Copy rngB.Offset(0, 1)
- '汇总表
- If Target.Address = "$A$1" Then
- Set rngA = Range("d3:z9")
- Set rngB = Sheets("汇总表").Range("a:a").Find(x)
- If Not rngB Is Nothing Then rngA.Copy rngB.Offset(0, 2)
- End If
-
- Application.EnableEvents = True
-
- End If
-
- End Sub
复制代码
请教:按条件分配数据到各工作表2.rar
(9.02 KB, 下载次数: 7)
|
|