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!!!

 

[mumps]

In what row and column is your Yes/No cell?

 

[CWelfley01]

I need it to be fluid. 8 cells into my row, but always in the row I'm working on.

 

[CWelfley01]

always in column L but goes down as i do

 

[mumps]

I'm not sure what you mean by

I need it to be fluid. 8 cells into my row

I'm basing the macro on the Yes/No always being in any row in column L. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter Yes or No in any cell in column L and press the RETURN key.

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

 

[CWelfley01]

and this will make it so a YES will move the cursor to the M column and a NO to the D column next row?

 

[mumps]

IN your original post you said

go back to the start of the next row

The next row starts in Column A so that is the way I wrote the macro. If you want to go to the next row in column D then use this version:

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

 

[CWelfley01]

I did say that, my apologies. I have the page locked with only a few columns unlocked.

 

[CWelfley01]

I can't seem to get it too work.

 

[mumps]

First make sure that you placed the macro in the worksheet code module as I described in Post #5 . Secondly, column L must be unlocked. I assume that you mean that the sheet is protected when you say

I have the page locked

This version will unprotect the sheet, perform its task and then protect the sheet again.

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

I'm assuming you didn't use a password to protect the sheet.