Copy to cell after comparing between two columns data

[reubanrao93]

Column N	Column P	Column R
Housing#VALUEDargon	1	1
2	#VALUEwww.google.comR@ND0M	2
...	...	..

Hi guys,

I'm exploring how to compare data contained in the same row between two columns, then copy to Column C for cell values that don't contain #VALUE in it using VBA and run it all the way down on column R. What's your suggestion on this? Many thanks.

 

[alz]

Hi Try this!
Sub copy_data()
'rows no 5 to 15 ( you need to adjust this part)
For r = 5 To 14

'Column N=14 ,P=16,R=18 ( you need to adjust this part)
If InStr(Cells(r, 14), "#VALUE") > 0 Then
Cells(r, 18).Value = Cells(r, 16).Value
Else
Cells(r, 18).Value = Cells(r, 14).Value
End If
Next r

End Sub