- 帖子
- 5923
- 主題
- 13
- 精華
- 1
- 積分
- 5986
- 點名
- 0
- 作業系統
- win10
- 軟體版本
- Office 2010
- 閱讀權限
- 150
- 性別
- 男
- 來自
- 台灣基隆
- 註冊時間
- 2010-5-1
- 最後登錄
- 2022-1-23
        
|
4#
發表於 2014-6-24 10:47
| 只看該作者
回復 3# ii31sakura - Sub Ex()
- Dim Ar(), i As Integer, S As String, Rng As Range, ss
- With Sheets("比對data").Range("A" & Sheets("比對data").Rows.Count).End(xlUp).Resize(, 4)
- S = Join(Application.Transpose(Application.Transpose(.Value)), "")
- '"比對data"最後一筆的("A~D")的資料
- End With
- With Sheets("總整理")
- .Cells.Clear
- .Range("A1").Resize(, 7) = Sheets("來源data").Range("A1").Resize(, 7).Value '表頭
- Ar = Sheets("來源data").Range("A1:D5").Value 'sheet"來源data"中("A~D")
- For i = 1 To UBound(Ar)
- If S = Join(Application.Index(Ar, i), "") Then
- Set Rng = Sheets("來源data").Cells(i, "A").Resize(, 7)
- MsgBox "在 第" & i & " 列 找到 " & Join(Application.Transpose(Application.Transpose(Rng.Value)), ",")
- .Range("A" & .Rows.Count).End(xlUp).Offset(1).Resize(, 7) = Rng.Value
- End If
- Next
- End With
- End Sub
複製代碼 |
|