I have three workbooks one we will call, Clients and the other two Visits pertaining to visits to clients for the second half of 2017 and the first half of 2018. Each visit also has a corresponding job number.
Within the Clients workbook I wish to:
populate Column O in Clients...