技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 1810
|
2#
發(fā)表于 2016-9-16 13:53:31
|
只看該作者
本帖最后由 access新新新手 于 2016-9-16 13:55 編輯
Sub 匯總工作薄數(shù)據(jù)()
Dim br
Sheets("匯總").Range("a2:d65536").ClearContents
br = [{"序號","客戶名稱","平臺名稱","應(yīng)收金額","實(shí)收金額"}]
Range("A1:E1") = br
Dim sht As Worksheet, xrow As Integer, Rng As Range
For Each sht In Worksheets
If sht.Name <> "匯總" Then
Set Rng = Range("a65536").End(xlUp).Offset(1, 0)
xrow = sht.Range("a1").CurrentRegion.Rows.Count - 1
sht.Range("a2").Resize(xrow, 5).Copy Rng
End If
Next
End Sub
|
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒有帳號?注冊
x
|