Hello everybody,
Please help. I am trying to copy data from column N (Depot) within the "depot listing" sheet to column G (Depot) of the "jobs listing" sheet but only if the surname matches in column B "depot listing" to that of column D "jobs listing" sheet.
The depot needs to be aligned with the appropriate surname with the ultimate aim of determining the Managers' Depot on the "jobs listing" sheet.
Bookmarks