|
Roy,下次这种要祭出代码的,就不要拿出来显摆了,Access有VBA,难道Excel没有VBA么?
- Sub Sample()
- Dim MyRow As Long, i As Long
- Dim MyFind As Range
- Range("d1:e1") = Range("a1:b1").Value
- i = 1
- For MyRow = 2 To 28
- Set MyFind = Range("d:d").Find(Cells(MyRow, 1), , , xlWhole)
- If MyFind Is Nothing Then
- i = i + 1
- Cells(i, 4) = Cells(MyRow, 1)
- Cells(i, 5) = Cells(MyRow, 2)
- Else
- Cells(MyFind.Row, 5) = Cells(MyFind.Row, 5) & ";" & Cells(MyRow, 2)
- End If
- Next
- Set MyFind = Nothing
- End Sub
复制代码 |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|