こんな感じでどうでしょうか。
Sub test()
Dim Rng As Range
Dim RngB As Range
Dim B As Range
Dim Rw As Long
Dim N As Long
Set RngB = Range("B1", Range("B65536").End(xlUp))
Rw = 1
For Each Rng In Range("A1", Range("A65536").End(xlUp))
If IsNumeric(Rng) Then
Range("C" & Rw) = Rng.Value
Rw = Rw + 1
Set B = RngB.Find(Rng.Value, lookat:=xlWhole)
If Not B Is Nothing Then
N = 1
Do Until IsNumeric(B.Offset(N).Value)
Range("C" & Rw).Value = B.Offset(N).Value
N = N + 1
Rw = Rw + 1
Loop
End If
Else
Range("C" & Rw) = Rng.Value
Rw = Rw + 1
End If
Next Rng
Set RngB = Nothing
End Sub
お礼
ありがとうございました。 うまくいきました!