Hi all,
I have a workbook with 2 separate sheets, Sheet 1 is a list of 1000 staff names, sheet 2 is a list of 5000 staff names some of whom may have left the business. I need to be able to marry up the duplicate names between the 2 sheets then copy the leave date across from sheet 2 to the correct staff name in sheet 1.
thanks in advance
I have a workbook with 2 separate sheets, Sheet 1 is a list of 1000 staff names, sheet 2 is a list of 5000 staff names some of whom may have left the business. I need to be able to marry up the duplicate names between the 2 sheets then copy the leave date across from sheet 2 to the correct staff name in sheet 1.
thanks in advance