|
发表于 2013-9-21 17:01
|
显示全部楼层
本楼为最佳答案
两个表的B列数据不对应,如果编号唯一的话就以编号筛选可以吧,附件请测试- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- If Target.Column = 7 And Target.Row > 1 Then
- If Target.Offset(, -6) = "" Then Exit Sub
- Sheets(2).Columns(2).AutoFilter Field:=2, Criteria1:=Target.Offset(, -6)
- Sheets(2).Activate
- End If
- If Target.Column = 6 And Target.Row > 1 Then
- If Target.Offset(, -5) = "" Then Exit Sub
- Sheets(1).Columns(2).AutoFilter Field:=2, Criteria1:=Target.Offset(, -5)
- Sheets(1).Activate
- End If
- End Sub
复制代码 |
|