Please see the attached Excel sheet. I am trying to do the following:
1) For each value in 'Sheet1' column 'B', search 'Sheet2' column 'A' for an identical value.
2) If an identical value exists in 'Sheet2', place the value from 'Sheet2' column 'B' into 'Sheet1' column 'A'
Is there way to do this using VB?