A worksheet event needs to go in a worksheet module. Right click sheet
tabview codecopy/paste my codeplay with it to see what it is doing and
then add other if's. You didn't give a lot of detail in your original
request. What I said was if you made a change to a cell in col C and the
cell immediately to the left was blank, go back to the the blank cell and
fill in before proceeding. Else, proceed to the cell just to the right for
the next entry. Play with it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
On 27 Nov, 16:33, "Don Guillett" wrote:
One way. Modify to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
If Target.Offset(, -1) = "" Then
Target.Offset(, -1).Select
MsgBox "Pleae fill in"
Else
Target.Offset(, 1).Select
End If
End If
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Steve" wrote in message

...

Hi Don
Can you point me in the direction of maybe a tutorial on how to do
this, It's a bit over my head

TIA
Steve