¦p¦ó±q¦r¦ê¤¤¤ñ¹ï«á§ì¥X»Ý¨Dªº¸ê®Æ
- ©«¤l
- 76
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 145
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2014-6-24
|
¦p¦ó±q¦r¦ê¤¤¤ñ¹ï«á§ì¥X»Ý¨Dªº¸ê®Æ
¦p¦ó±NLÄæ¦ì¦r¦ê»P¤u§@ªí"û¤u¦W³æ"¤ñ¹ï¡A
¤ñ¹ï¨ì¬Û¦Pªº¦W¦r§ì¨ìAIÄæ¦ì
°ÝÃD¦pªþ¥ó |
|
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 1# lone_tiger0303
¸ê®Æ¶q¤j °õ¦æ¸û¶g- Sub zz()
- Application.ScreenUpdating = False
- Dim Rng As Range, Ar
- Set Rng = Sheets("DMS").[L2]
- Range(Rng, [L65536].End(xlUp)).Offset(0, 23) = ""
- Do
- If InStr(Rng, ",") Then
- Ar = Split(Rng, ",")
- For I = 0 To UBound(Ar)
- Set X = Sheets("û¤u¦W³æ").UsedRange.Find(Ar(I), , xlValues, xlWhole)
- If Not X Is Nothing Then
- Rng.Offset(0, 23) = Rng.Offset(0, 23) & X & " "
- End If
- Next I
- Else
- Set X = Sheets("û¤u¦W³æ").Cells.Find(Rng, , xlValues, xlWhole)
- If Not X Is Nothing Then
- Rng.Offset(0, 23) = Rng
- End If
- End If
- Set Rng = Rng.Offset(1)
- Loop Until Rng(1) = ""
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X
2012-01_DMS·~¥NÁÒ°Ï.rar (76.38 KB)
|
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¦^´_ 1# lone_tiger0303 - Sub nn()
- With Sheets("DMS")
- For Each a In .Range("L2", .[L2].End(xlDown))
- .Cells(a.Row, "AI") = ""
- ar = Split(a, ",")
- For Each b In ar
- Set c = Sheets("û¤u¦W³æ").Cells.Find(b, lookat:=xlWhole)
- If Not c Is Nothing Then .Cells(a.Row, "AI") = IIf(.Cells(a.Row, "AI") = "", c, .Cells(a.Row, "AI") & "," & c)
- Next
- Next
- End With
- End Sub
½Æ»s¥N½X |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# lone_tiger0303 - Option Explicit
- Sub Ex()
- Dim Ar, xA, xF As Range, xS As Integer
- With Sheets("DMS")
- Ar = Application.Transpose(.Range("L1", .[L1].End(xlDown)).Value)
- Ar = Join(Ar, ",")
- Ar = Split(Ar, ",")
- With .Range("IR1")
- .Resize(UBound(Ar)) = Application.Transpose(Ar)
- .Resize(UBound(Ar)).Offset(, 1) = 1
- xA = .Resize(UBound(Ar)).Resize(, 2).Address(, , 0)
- .Offset(, 2).Consolidate xA, xlSum, 0, 1 '·Jºâ¥X¤£«½Æªº¦W³æ
- Erase Ar
- For Each xA In .Offset(, 2).Resize(Rows.Count, 1).SpecialCells(xlCellTypeConstants)
- If xA.Row <> 1 And xA <> "" Then
- Set xF = Sheets("û¤u¦W³æ").Cells.Find(xA, lookat:=xlWhole)
- If Not xF Is Nothing Then
- ReDim Preserve Ar(xS)
- Ar(xS) = xA
- xS = xS + 1
- End If
- End If
- Next
- .CurrentRegion = ""
- End With
- If xS > 0 Then
- .Range("AI2:AI" & Rows.Count) = ""
- .Range("AI2").Resize(xS).Value = Application.Transpose(Ar)
- End If
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 145
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2014-6-24
|
·PÁ¤T¦ì¦Ñ®vªº«ü¾É~~
¥t¥~¡AGBKEE¦Ñ®v~~§Ún¤@¹ï¤@~~«½Æªº¦W³æ¤£¥Î§R°£¡A¥B¤£¥Î©¹¤W²¾ |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 145
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2014-6-24
|
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 7# lone_tiger0303 - Option Explicit
- Sub Ex()
- Dim Ar(), xR As String, xF As Range, xS As Integer
- With Sheets("DMS")
- Ar = .Range("L2", .[L2].End(xlDown)).Value
- For xS = 1 To UBound(Ar)
- xR = Split(Ar(xS, 1), ",")(0)
- Set xF = Sheets("û¤u¦W³æ").Cells.Find(xR, lookat:=xlWhole)
- If Not xF Is Nothing Then
- Ar(xS, 1) = xF
- Else
- Ar(xS, 1) = ""
- End If
- Next
- .Range("AI2:AI" & Rows.Count) = ""
- .[AI2].Resize(UBound(Ar)) = Ar
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 145
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2014-6-24
|
|
|
|
|
|
|