Here is an example of the two workbooks-I hope the formatting is okay.
workbook A/worksheet active putaway:
Emp ID Dept A. ID Dt in In Time Out Time Ttl Amt Rev Time Xfr Val.
Sally 777 2634 99356 3/2/15 8:11 5:15 8.82 8.32 29 132
Ted 553 2634 82175 3/2/15 8:13 5:16 8.78 8.30 29 175


Workbook B/Worksheet WM putaway:
ID User Ttl Ctns Ttl Units
777 Sally 132 1713
553 Ted 175 2346

I want to update Workbook A with the TTL Ctns from Workbook B.