Hi All,

I have here a file.

i need a macro that will extract the values from the columns based on the employee number on column a.

Column A - Employee number

Column C - Employee Number
Column D - Address

Column F- Employee Number
Column G- House number


So based on column A, it will look up it its existing in the data column C and Column D and will extract the value on the next sheet.


Please see the attached file.TRY.xlsx