|
- Sub Macro2()
- Dim arr, brr, crr, i&, x&
- arr = Sheet1.Range("a1").CurrentRegion
- [a2:h20000].Clear
- For i = 2 To UBound(arr)
- If Not Sheets(arr(i, 3)) Is Nothing Then
- brr = Sheets(arr(i, 3)).Range("a1").CurrentRegion
- ReDim crr(1 To UBound(brr) - 1, 1 To 2)
- For j = 2 To UBound(brr)
- crr(j - 1, 1) = arr(i, 2)
- crr(j - 1, 2) = arr(i, 1)
- Next
- x = Cells(Rows.Count, 1).End(xlUp).Row + 1
- Cells(x, 2).Interior.ColorIndex = 6
- Cells(x, 1).Resize(UBound(crr), 2) = crr
- Sheets(arr(i, 3)).Range("a1").CurrentRegion.Offset(1, 0).Copy Cells(x, 3)
- End If
- Next
- [h2] = "=IF(MID(E2,1,7)=""001.03."",I2*G2,ROUND(J2/1000*G2,2))"
- [h2:h20000].FillDown
- End Sub
复制代码 |
|