Hi,
I am completely new to VBA.
My problem is I want to Map Employee ID's to the workbook that user selects and opens.
I have created a mapping table which contains Local ID and External ID for Employees.
When the user opens a workbook, the macro should automatically match the External ID...