View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pasha Pasha is offline
external usenet poster
 
Posts: 3
Default 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