i am trying to update records from excel to ms project and running a macro for that, but the problem si that if i have three records to one job number the macro only updates the first and leaves two untouched .. i am lost and confused .. need some help with this please.

please see below for example:

82 JJR21802 PLU 122.06 F
82 JJR21802 JNR 908.16 W
82 JJR21802 PAD 90.42 W

as you can see the macro has updated the status of first record but has left bottom two untouched.

any help you be much appriciated, and thank you in advance for your help.