Excel彙整資料VBA

僅供參考

Sub AA()
Dim d As Object, a, Sh As Worksheet, s As String
Dim i As Long, j As Long, r As Long, arr, brr
Set Sh = Sheets("Sheet1")
arr = Sh.[a1].CurrentRegion
ReDim brr(1 To UBound(arr))
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
s = arr(i, 1) & Chr(9) & arr(i, 3)
If Not d.exists(s & "") Then d.Add s, ""
Next i
a = d.keys
For i = 0 To d.Count - 1
d(s) = ""
For j = 2 To UBound(arr)
If arr(j, 1) & Chr(9) & arr(j, 3) = a(i) Then
If d(s) = "" Then
d(s) = arr(j, 2)
r = j - 1
da = arr(j, 1): dc = arr(j, 3): dd = arr(j, 4)
Else
d(s) = d(s) & " - " & arr(j, 2)
brr(j - 1) = ""
End If
End If
Next j
If InStr(d(s), "-") > 0 Then d(s) = d(s) & " EACH "
brr(r) = da & Space(1) & d(s) & Space(1) & dc & Space(1) & dd
Next i
Sh.Cells(2, 5).Resize(UBound(brr), 1) = WorksheetFunction.Transpose(brr)
End Sub

參考就好
http://blog.xuite.net/hcm19522/twblog/213306784

最近發現一家很不錯的a片專賣店唷,

網址先貼給你http://Zzb.bz/P2raD

它出的新片速度很快喔~每個禮拜都有很多新片

新片價格一片是30元而已,我看過還很清晰的,

有瑕疵片可以跟客服反應,他們會協助處理唷

如果你要畫質更好的,也有藍光dvd,超*的

不知道怎麼挑片的話,也有站長推薦的精選套餐

http://Zzb.bz/gqEFV

自己買很多了才推薦給你唷!!看看吧


#@#

推薦你這間線上A片即時觀看喔!!

A片種類超多的,我常去光顧呢
保證你不會後悔的啦~
號稱業界最強,怎麼可以錯過呢
30點現上儲值可以馬上觀看,省去等宅配時間

http://Zzb.bz/Z3kjn

=A2&B2&"-"&C2&D2下拉

2014-05-13 20:12:13 補充：
版大你好
請上傳範例檔供網友幫你解答,(壓縮後,依以下的網址上傳)
http://www.FunP.Net