I am comparing data that is in Workbook2 to Workbook1. On Workbook2, sheet1 there is a column named Order ID (column A) What I am trying to do is compare every Order ID to that same exact column Order ID (column A) on Workbook2, sheet 1. And if a matching Order ID is found copy the data from Workbook2, Column F in that corresponding row to Workbook1sheet1 in Column H to the corresponding Order ID.
Ex:
Workbook2,Sheet1:
Column A: _ Column F:
Order ID _ Status Update
1530423947 _ Being sent today
1530425710 _ Being sent today
1530427861 _ working to get revised report in ASAP
1530429263 _ Being sent today
1530429147 _ Report due 4/20
1530429145 _ Being sent today
1530429643 _ Report due 4/20

Workbook1,Sheet1:
Column A: _ Column H:
Order ID _ Status Update
1530429643
1530429145
1530429147

End Result on Workbook1,Sheet1:
Order ID _ Status Update
1530429643 _ Report due 4/20
1530429145 _ Being sent today
1530429147 _ Report due 4/20

I’m still pretty new to all this and I’ve just been having issues lately wrapping my head around some of the newer concepts I need to implement. Thanks is advance for any help or advice.