I'm trying to copy data from column B to column AO if column C meets a condition. My problem is I don't know how to set the result value. (non-programmer)
Thank you in advance.![]()
Sub MoveSubDescToAtt() For Each Cell In Range("C:C") If Cell.Value = "[No Product Description]" Then Cell.Offset(0, 38) = "I need this cell to equal the contents of what's in column B, same row) End If Next End Sub
Bookmarks