|
发表于 2016-3-26 18:28
|
显示全部楼层
本楼为最佳答案
- Sub lqxs()
- Dim Arr, i&, Brr, xs, aa, bb, cc, gg, j&
- Sheet3.Activate
- [a2:ab5000].ClearContents
- Arr = Sheet2.[a1].CurrentRegion
- ReDim Brr(1 To UBound(Arr) - 1, 1 To 28)
- For i = 2 To UBound(Arr)
- Brr(i - 1, 1) = Arr(i, 1): Brr(i - 1, 2) = Arr(i, 2)
- xs = Arr(i, 3)
- aa = Split(xs, "*")(1)
- bb = Split(xs, "#"): Brr(i - 1, 7) = bb(1): Brr(i - 1, 4) = bb(1)
- If InStr(bb(0), "阿迪") Or InStr(bb(0), "Ad") Then
- Brr(i - 1, 3) = "AD": Brr(i - 1, 8) = "阿迪达斯"
- ElseIf InStr(bb(0), "耐克") Or InStr(bb(0), "Ni") Or InStr(bb(0), "NIKE") Then
- Brr(i - 1, 3) = "NK": Brr(i - 1, 8) = "耐克"
- ElseIf InStr(bb(0), "Pu") Then
- Brr(i - 1, 3) = "PM": Brr(i - 1, 8) = "Puma"
- End If
- Brr(i - 1, 9) = xs: gg = Arr(i, 4): Brr(i - 1, 6) = gg
- cc = Split(gg, "/")(1)
- If Brr(i - 1, 8) = "阿迪达斯" Then
- If InStr(cc, ".") Then
- Brr(i - 1, 5) = Split(cc, ".")(0) & "-"
- Else
- Brr(i - 1, 5) = cc
- End If
- Else
- Brr(i - 1, 5) = cc
- End If
- For j = 5 To UBound(Arr, 2)
- Brr(i - 1, j + 5) = Arr(i, j)
- Next
- Next
- [a2].Resize(UBound(Brr), UBound(Brr, 2)) = Brr
- End Sub
复制代码 |
|