hello

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.