请问指定表一路径的是哪一段代码?
追答晕,搞错了,你是两个工作簿是吧?这个代码是在同一工作簿中的两个工作表的。
追问是的,在这里我传不上附件,可加你QQ吗,我的451730539
追答Private Sub Worksheet_Change(ByVal Target As Range)
Dim Lj As String
Lj = "D:\我的文档\表2.xls"
If Target.Column = 1 And Target.Count = 1 Then
Workbooks.Open Lj
With Workbooks("表2.xls").Sheets("sheet1")
For x = 1 To .Range("A65536").End(xlUp).Row
If .Cells(x, 1) = Target.Value Then
.Rows(x).Copy Target.Rows
Exit Sub
End If
Next x
End With
Workbooks("表2.xls").Close True
End If
End Sub
成功了,非常感谢,有一点我想改进,复制后希望返回的是表二,不是表一的结果