|
Sub test()
Dim A, i, j, k, wk
Sheets(1).Select
i = Range("a65536").End(xlUp).Row
Range("c6:h" & i) = ""
A = Range("A1").CurrentRegion
For i = 6 To UBound(A)
If A(i, 1) <> "" Then
'1)路径
Set wk = Workbooks.Open(A(i, 1))
'2)选择
For k = 1 To 4
If A(i, 2) = A(k, 1) Then Exit For
Next k
'3)取值
For j = 3 To UBound(A, 2)
If A(k, j) <> "" Or A(k + 1, j) <> "" Then
'A(i, j) = 工作簿.工作表.单元格
A(i, j) = wk.Sheets(A(k, j)).Range(A(k + 1, j))
End If
Next j
wk.Close 0
End If
Next i
Range("A1").Resize(UBound(A), UBound(A, 2)) = A
End Sub
2.rar
(73.03 KB, 下载次数: 6)
|
|