Sub test()
Dim A, d, i, j, k
Set d = CreateObject("scripting.dictionary")
'写字典
A = Sheets(2).Range("a1").CurrentRegion
For i = 2 To UBound(A)
If A(i, 1) = "" Then A(i, 1) = A(i - 1, 1)
d(A(i, 1) & A(i, 2)) = i '行
Next
'查字典
A = Sheets(1).Range("a1").CurrentRegion
A(2, 3) = Replace(A(2, 3), "月", "") + 1 '表
A(2, 4) = Replace(A(2, 4), "日", "") + 3 '列
For i = 4 To UBound(A)
For j = 3 To UBound(A, 2)
k = A(i, 2) & A(3, j) 'd(k)查出行
If d.exists(k) Then Sheets(A(2, 3)).Cells(d(k), A(2, 4)) = A(i, j)
Next
Next
End Sub
出入库日报填入2.rar
(46.16 KB, 下载次数: 29)
|