Locate Correct Row in another Workbook

I have two workbooks.

Workbook 1 is used to generate job sheets and there is a macro that generates a job number for each job sheet. There is another macro that updates the 2nd workbook with a summary of the job on one row.

So Workbook 1 has all the details of one specific job whereas Workbook 2 has a summary of every job that Workbook 1 has generated a job sheet for.

What I would like to do is to have a button in the job sheet with a macro assigned to it that when clicked will locate the relevant row in Workbook 2, find the end of that row and enter the word Complete into the next available cell. The cell would always be in Column I.

This is the code I'm currently using to enter the summary data into Workbook 2:

Please Login or Register  to view this content.

The job number is stored in cell D2 in Workbook 1 and this would be inserted into Column A of workbook 2 so it would be the job number that could be used to locate the correct row.

marks job complete if found else msgbox

Please Login or Register  to view this content.

Kind regards
Leo

Wow! That's perfect, thank you so much!!