Curser not staying in same row when entering data, as it updates other sheets

[Surething]

When I enter Data on the main sheet it auto copies to the proper matching sheet for each city. When I enter data and tab to the next cell, the curser go to the end of the sheet. I need to be able to enter data across the rows without moving the cursor every time. Everything else seems to work fine but this.

Here is a look at the file....

https://app.box.com/s/6dhbx49qlhof8pbdzmrt

 

[tyger0951]

Hmm odd I tried a few things but no luck. To start though instead of page always updating on every field try this :

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Column = 5 Then




    Call CopyToCities
    
    End If


End Sub