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

Importing Data from another Excel File
 

Bump...



"Pasha" wrote in message
...
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