I just learned about VBA and Macros. I was able to make minor adjustments but I am struggling to figure out the conditional logic. Here is my example
I want to be able to loop through Col B, find cells that have Manual listed, upon match take value from Col A and paste it in Col C. If not, then leave the existing value. I tried the following but its not dynamic and maybe not the best conditional code to use in this scenario. I am thinking For each would be ideal? Any suggestions?
Col A | Col B | Col C
123 | Manual |
232 | Automated | filename
334 | Manual |
If Range("B2").Value = "Manual" Then
ActiveCell.Range("C2").Value = Range("A2").Value
End If
Bookmarks