|
Sub cdsr()
Dim Wb As Workbook
Dim sht As Worksheet
Dim d As Object
Dim arr, i
Application.ScreenUpdating = False
Set d = CreateObject("scripting.dictionary")
'1)
Set Wb = Workbooks.Open(Filename:=ThisWorkbook.Path & "\附表3:前端点位材料明细清单.xlsx")
For Each sht In Sheets
arr = sht.[a1].CurrentRegion
For i = 2 To UBound(arr)
d(arr(i, 2)) = arr(i, 6) '2表示设备名称 , 6表示合计
Next
Next
Wb.Close False
'2)
ThisWorkbook.Activate
Sheets("张家边派出所").Activate
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
Cells(i, "E") = d(Cells(i, "B").Value) 'B表示设备名称 , E表示数量
Next
End Sub
楼主自己再改吧
|
|