software

Hi Danny, (navigation after a change event via macro)
Thanks for sending the worksheet. (reply posted to misc)

Basically you have a table A14:K37 column A contains the time,
columns B, C, E, F, H, and K get filled in if the time is 7:00 (row 20)
or the time is 19:00 (row 33) then additional cells are filled in
after changing entry in Column K (see description at bottom); otherwise,
cell in column B of next row will be selected after entry in column K.

Cells that are to be entered into have a blue font and are unlocked,
which is good shows what people have to enter.

Install Change Event macro by right click on the sheet tab, View code, ...

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address(0, 0)
Case quot;K20quot; 'time 07:00
Range(quot;N27quot;).Select
Case quot;K32quot; 'time 19:00
Range(quot;N28quot;).Select
Case quot;P27quot;
Range(quot;M34quot;).Select
Case quot;P28quot;
Range(quot;N34quot;).Select
Case quot;M34quot;
Range(quot;B21quot;).Select '08:00 next
Case quot;N34quot;
Range(quot;B33quot;).Select '20:00 next
Case Else
Select Case Target.Column
Case 3, 6
Target.Offset(0, 2).Select
Case 8
Target.Offset(0, 3).Select
Case 11
Cells(Target.Row 1, 2).Select
Case Else
Target.Offset(0, 1).Select
End Select
End Select
End Sub

You will not need to use the TAB key, navigation will be
provided after you change value. Tested using F2 then Enter
to effect a change events.

gt; gt; On our sheet, at 07:00, we input information in cells, 20B,20C,20E,20F amp;
gt; gt; 20H. We tab to each cell and all locked cells are skipped. What we would like
gt; gt; to do is, after we put information in cell 20H, we would like to be able to
gt; gt; tab to cells, 27N, 27O, 27P, and 34M and then back to 21B. Is this possible?

similar but different instructions for 19:00 (row 32)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm