|
本帖最后由 chensir 于 2014-5-13 08:51 编辑
把表1中店的批注内容,放入到表2相应店的批注里。
由于店4店5无批注,因此要求表2中的店4店5也无批注。
- Sub test()
- 'On Error Resume Next
- Dim r As Long, rng As Range, cmt As String
- With Sheets("表2")
- Set rng = Nothing
- For r = 2 To .Range("A65536").End(xlUp).Row
- .Cells(r, 2).ClearComments
- Set rng = Sheets("表1").Range("A:A").Find(.Cells(r, 1).Value, , , xlWhole)
- If Not rng Is Nothing Then
- cmt = rng.Offset(, 1).Value
- If Len(cmt) > 0 Then .Cells(r, 2).AddComment cmt
- End If
- Next
- End With
- End Sub
复制代码
|
|