I've been away from Excel for a while and need some assistance to clear my brain freeze.
I have a workbook with a sheet containing employee data and want to copy the Employee details from Column B to F, where the Employee ID matches the Employee Number on Sheet1.
In my example, Sheet 1 Employee Number matches Employee ID on Employees Sheet and therefore Marga Walkinshaw data is pasted in to the relevant columns.... and so on for the remainder.
Obviously this is mock data and I have thousands of rows in Sheet1 to fill in so requires a more efficient solution than just copy and pasting...
Also, FWIW, the original Employee ID / Employee Number comprises of alphanumerical characters and is not a true number.
Any help greatly appreciated.