呵呵 我编了几行代码大概可以实现将分散的PN和ID整理出来,大家可以试着使用优化一下啊 :),至于结合站位,需要从吸取数据中提取...和PN link起来就可以...
源代码如下
××××××××××××××××××××××××××××××××××××××
Option Explicit
Public Sub Pick()
Dim r1, r2, r3 As Range
Dim i, j, k As Integer
Dim S As String
Dim C As Range
Set r2 = Range("E:E")
Worksheets(1).Activate
ActiveSheet.Range("E:F").ClearContents
Cells(1, 5).Value = "PN"
Cells(1, 6).Value = "ID"
i = 2 ' start from 2nd row
Dim NumRow As Integer
NumRow = Cells(2, 1).End(xlDown).Row
Set r1 = Range(Cells(2, 1), Cells(NumRow, 1))
For Each C In r1
If r2.Find(C.Value, LookAt:=xlWhole) Is Nothing Then
Cells(i, 5).Value = C.Value
Cells(i, 6).Value = C.Offset(0, 1).Value
i = i + 1
Else
Cells(r2.Find(C.Text, LookAt:=xlWhole).Row, 6).Value = Cells(r2.Find(C.Text, LookAt:=xlWhole).Row, 6).Value & "," & C.Offset(0, 1).Value
End If
Next C
End Sub
[ 此贴被zh98340555在2008-10-28 16:32重新编辑 ]