[算表] VBA轉置貼上另存新檔
軟體:excel
版本:2016
原檔:
https://imgur.com/JdfTA4n
想把原檔案轉至後貼到另一個新檔案,並且按照分公司名稱存檔
有嘗試爬文來修正,但一直失敗...
遇到有合併的存儲格無法抓取,也不知道怎麼轉置
想請教各位大大幫忙
Sub Macro1()
Dim rLastCell As Range
Dim strName As String
Dim lLoop As Long
Dim wbNew As Workbook
Dim cnt As Integer
With ThisWorkbook.Sheets(1)
Set rLastCell = .Cells.Find(What:="*", After:=[A1], _
SearchDirection:=xlPrevious)
For lLoop = 2 To rLastCell.Row
cnt = WorksheetFunction.CountIf(Range("c:c"), Range("c" & lLoop))
Set wbNew = Workbooks.Add
試跑到這邊都是正常的,但後續就不知道如何處理了
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.71.215.170 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1600617478.A.3D5.html
→
09/21 00:51,
3年前
, 1F
09/21 00:51, 1F
→
09/21 00:51,
3年前
, 2F
09/21 00:51, 2F
→
09/21 00:51,
3年前
, 3F
09/21 00:51, 3F
→
09/21 00:51,
3年前
, 4F
09/21 00:51, 4F
→
09/21 00:51,
3年前
, 5F
09/21 00:51, 5F
→
09/21 00:51,
3年前
, 6F
09/21 00:51, 6F
→
09/21 00:51,
3年前
, 7F
09/21 00:51, 7F
→
09/21 00:51,
3年前
, 8F
09/21 00:51, 8F
→
09/21 05:45,
3年前
, 9F
09/21 05:45, 9F
→
09/21 05:47,
3年前
, 10F
09/21 05:47, 10F
→
09/21 05:48,
3年前
, 11F
09/21 05:48, 11F
→
09/21 17:28,
3年前
, 12F
09/21 17:28, 12F
→
09/21 17:28,
3年前
, 13F
09/21 17:28, 13F
→
09/21 17:28,
3年前
, 14F
09/21 17:28, 14F
→
09/21 17:28,
3年前
, 15F
09/21 17:28, 15F
→
09/21 17:28,
3年前
, 16F
09/21 17:28, 16F
→
09/21 17:28,
3年前
, 17F
09/21 17:28, 17F
→
09/21 17:28,
3年前
, 18F
09/21 17:28, 18F
→
09/21 17:28,
3年前
, 19F
09/21 17:28, 19F
→
09/21 23:19,
3年前
, 20F
09/21 23:19, 20F
→
09/21 23:19,
3年前
, 21F
09/21 23:19, 21F
→
09/22 07:21,
3年前
, 22F
09/22 07:21, 22F
→
09/22 07:21,
3年前
, 23F
09/22 07:21, 23F
→
09/22 07:21,
3年前
, 24F
09/22 07:21, 24F
→
09/22 07:21,
3年前
, 25F
09/22 07:21, 25F
→
09/22 07:21,
3年前
, 26F
09/22 07:21, 26F
→
09/22 07:21,
3年前
, 27F
09/22 07:21, 27F
→
09/22 07:21,
3年前
, 28F
09/22 07:21, 28F
→
09/22 07:21,
3年前
, 29F
09/22 07:21, 29F
→
09/22 07:21,
3年前
, 30F
09/22 07:21, 30F
→
09/22 07:21,
3年前
, 31F
09/22 07:21, 31F
→
09/24 22:53,
3年前
, 32F
09/24 22:53, 32F