I'm trying to write a program that searches for a specific value in a range of cells in a different workbook. If the value exists, I need to update a status in a different column of the found cell's row.

For example, Column A in WB1 contains a small range of data (data in each cell is unique, but are all numbers). Column B contains a status update.

Column A in WB2 contains a larger amount of data & may or may not contain matching values from Column A in workbook 1.

If there are matching values in the two Column A's, Column B in WB2 needs to be updated by the corresponding value of Column B in WB1.

Such as, Workbook1,A2 matches Workbook2,A19; thus, B19 in Workbook2 needs to be replaced what's in B2 in Workbook1.

If the item in WB1 column A doesn't exist in WB2 column A, it should be ignored.

Sure sounds confusing when I try to type it all out.