If "yes" then move to next cell, "no" then move to cell in next row

[CWelfley01]

IF "YES" THEN MOVE TO NEXT CELL, "NO" THEN MOVE TO CELL IN NEXT ROW

Title says it all. I want to have a cell in the middle of my row that will decide if i move to the next cell in the same row or go back to the start of the next row. Any help is appreciated!! I have never even accessed VBA so please keep me in the function area.
Thanks in advance!!!

 

[CWelfley01]

yes sir you are correct. i have the columns i don't want to use locked and the ones i'm using unlocked, no password.

 

[mumps]

Did the last macro I suggested work for you? You placed the macro in the Worksheet code module?

 

[CWelfley01]

It did not. I followed the best i could, but no go.

 

[mumps]

I tried it on a dummy sheet and it worked properly. Can you upload a copy of your file to a free site such as www.dropbox.com, mark it for sharing and post a link to the file here?

 

[CWelfley01]

let me see what i can do.

 

[CWelfley01]

https://www.dropbox.com/s/kvhl2i7167ussf7/test.xlsm?dl=0

 

[mumps]

The problem was that you were typing the Yes/No all in capital letters and macro has them as Yes/No. Try this version of the macro. I've added a line at the top to make your entry case insensitive.

Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("L:L")) Is Nothing Then Exit Sub
    ActiveSheet.Unprotect
    If Target = "Yes" Then
        Target.Offset(0, 1).Select
    ElseIf Target = "No" Then
        Cells(Target.Row + 1, 4).Select
    End If
    ActiveSheet.Protect
End Sub

 

[CWelfley01]

That's perfect!! Thank you very much!

 

[mumps]

You are very welcome.