|
发表于 2014-7-1 14:59
|
显示全部楼层
本楼为最佳答案
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim x, rg As Range, rgs As Range, S1, S2
- If Target.Row = 1 Then
- If Target.Column = 8 Or Target.Column = 10 Then
- Range(Range("F4:i4"), Range("F4:i4").End(xlDown)).Clear
- x = Me.Range("a" & Cells.Rows.Count).End(xlUp).Row
- S1 = Me.[H1].Value
- S2 = Me.[J1].Value
- For Each rg In Me.Range("a2:a" & x)
- If rg.Value = S1 And rg.Offset(0, 2).Value = S2 Then
- If rgs Is Nothing Then Set rgs = rg.Resize(1, 4) Else Set rgs = Application.Union(rgs, rg.Resize(1, 4))
- End If
- Next rg
- If rgs Is Nothing Then Exit Sub
- rgs.Copy
- Me.Range("f4").PasteSpecial
- End If
- End If
- End Sub
复制代码 |
评分
-
查看全部评分
|