|
Sub 提出数据()
Dim d, k, sht, n&, br, arr
Set d = CreateObject("scripting.dictionary")
Sheets("流动资产方").Activate
For Each k In Range(Range("a3"), Range("a33")).Cells
Set d(k.Text) = CreateObject("scripting.dictionary")
With Sheets(k.Text)
arr = .Range(.Range("a1"), .Range("a6").End(xlDown).Offset(, 9))
End With
' n = 10
' Do While arr(n, 1) <> ""
' d(k.Text)(arr(n, 1)) = arr(n, 7) & arr(n, 8)
' n = n + 1
' Loop
For n = 10 To UBound(arr)
d(k.Text)(arr(n, 1)) = arr(n, 7) & arr(n, 8)
Next
Next
For Each sht In Array(Sheets("流动资产方"), Sheets("流动负债方"))
If sht.Name = "流动资产方" Then br = Array(2, 4, 7, 8, 9, 14) _
Else br = Array(2, 4, 5, 6)
Set Rng = sht.Range(sht.Range("a1"), sht.Range("a3:a33").Offset(, 16))
For I = 3 To Rng.Rows.Count
For j = 0 To UBound(br)
With Rng
dt = Format(Rng(I, 1))
.Cells(I, br(j)) = d(dt)(.Cells(2, br(j)).Text)
End With
Next
Next
Next
End Sub |
|