Importing Data from another Excel File
I have a file (Contacts) that contains information about my employees (name,
date of birth, employee ID, etc) I have another file(Tracking) that I use
to track something about these employees. How do I import the fields from
Contacts to Tracking?I also have different sheets for each employee in
Tracking; how do I change the name of the sheet to the name of the employee?
I was thinking about having a button "UPDATE" that would run macro to update
the fields and add new employees to Tracking. Any ideas how to do it?
Pasha
|