请大侠帮忙，判断A列与C列，若匹配，按照B列内容填充

staryd

请大侠帮忙，通过判断A列与C列是否匹配，按照B列将内容填充，效果如D列
我写的VBA代码如下，不知道哪里出了问题，总是不对，求大侠指教：

Sub Macro3()
Dim i, j
i = 365
Do While Range("C" & i).Value <> "" And Range("C" & i).Value = Range("A" & i).Value
j = i
    Do Until Range("A" & j + 1) <> ""
        If Range("A" & i + 1).Value = "" Then Range("C" & i + 1).Value = Range("B" & i + 1).Value
    Loop
i = i + 1
Loop
End Sub

Yaong_3

1. Sub yy()
   
2. Dim i%
   
3. For i = 2 To [C65536].End(xlUp).Row
   
4. If Cells(i, 1) = Cells(i, 3) And Not IsEmpty(Cells(i, 3)) Then Cells(i, 4) = Cells(i, 2)
   
5. Next
   
6. End Sub

复制代码