I have two workbooks: "Copy of ROSS MIS 040913 (2).xlsm" and "Copy of InspectionPlanByContract_Excel_041813A2 (2).xlsm"

I need to look in "Copy of InspectionPlanByContract_Excel_041813A2 (2).xlsm" sheet "InspectionPlanByContract_Excel" in column K1:K5000. If the cells in this column are populated, I need to copy and paste this info (a date: ##/##/##) to "Copy of ROSS MIS 040913 (2).xlsm" on "Sheet1" in column O.

I need the information (date) that is being transfered to coincide with it's corresponding work item number (in a differnt columns; but are the same in the two workbooks).


I think a macros will do that, I just dont know how to write it! I would greatly appreciate any help!