|
- Sub 复制()
-
-
- FIR = 3
- Set SH0 = Worksheets("库存汇总")
- SH0.Range("A" & FIR & ":HZ1048576").Clear
- For Each SH In Worksheets
- If SH.Name <> SH0.Name Then
- COLmax = SH0.UsedRange
- LASTSH0 = UBound(COLmax, 1) + 1
- COLmax = SH.UsedRange
- LASTSH = UBound(COLmax, 1)
- For ICOL = 1 To SH.Range("HZ1").End(xlToLeft).Column
- If Val(SH.Cells(1, ICOL).Value) > 0 Then
- SH.Range(SH.Cells(FIR, ICOL).Address & ":" & SH.Cells(LASTSH, ICOL).Address).Copy SH0.Range(SH0.Cells(LASTSH0, Val(SH.Cells(1, ICOL).Value)).Address)
- End If
- Next
- End If
- Next
- End Sub
复制代码 |
|