Update row if ID exists

[ExelTime]

I have a code that goes through multiple workbooks and copies over any rows to a master file that do not exist. I would like to add to this by updating a row if the value does exist in column A on the master (copying A - K from File to MasWB). Below is a copy of one of the loops. Can you please help me add so that I can update rows that already exist? I feel like it should be straight forward.

Please Login or Register  to view this content.

[Norie]

Try add in an Else to the If statement in the code for it copy the data from 'Sheet1' to the row the ID was found in rather than a new row.

Please Login or Register  to view this content.