Press Alt + F11 to open the Visual Basic Editor and double click the
worksheet that has cell L30 that is to act as the trigger.
In the module window there are 2 combo boxes at the top of the
window,directly below the toolbars.
Set the combobox on the right to Worksheet and the one one the left to Change
and enter the following code or copy and paste out of this reply. You will
need to change the entry that says Sheet2 to the worksheet that has the cell
you want selected when L30 is updated:
If Target = Range("L30") Then
With ThisWorkbook.Worksheets("Sheet2")
.Activate
.Range("B5").Select
End With
End If
When finished it should look like this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("L30") Then
With ThisWorkbook.Worksheets("YourSheetName")
.Activate
.Range("B5").Select
End With
End If
End Sub
Now, when you update L30 it will automatically move you to cell B5 in the
stated worksheet.