I have two worksheets A and B.
I would like to compare a PO Col A on worksheet A, Row A2:A40 against Col A RowA2:A40 on worksheet B and if the PO's are on both worksheets, I would like to copy the status col , Col K K2:K40 from worksheet A onto worksheet B col K, K2:K40.
I would like to compare a PO Col A on worksheet A, Row A2:A40 against Col A RowA2:A40 on worksheet B and if the PO's are on both worksheets, I would like to copy the status col , Col K K2:K40 from worksheet A onto worksheet B col K, K2:K40.