I need some help…
I have a table that has a large amount of data on it. The third column of workbook A has job numbers (ex. 1234, 5567, 8897) in it. Also, the fourth column of workbook A has the amount of hours required to complete the specific job. Another workbook, workbook B, is also in table format. The first column of workbook B has some job numbers in it while the second column has the amount of hours required to complete the specific job.

I need a macro that does the following:
When the button is pressed (on workbook A), it selects a job number from workbook A and searches workbook B for that particular job number. If it finds the job number on the workbook B, I want the value from the “number of hours” column to be inserted in the corresponding column on workbook A. If it doesn’t find the job number, I want it to do nothing (as in move on to the next job number). The macro should loop through the workbook until it has done a search on each job number.

For simplicity, assume generic cell names as I can easily change those later.

Thanks in advance.