LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing data from a DataCom file into an Excel workbook Stefaans Excel Discussion (Misc queries) 0 October 3rd 08 12:19 PM
importing text file data into excel GradStudent N need Excel Discussion (Misc queries) 1 September 7th 07 09:44 AM
Importing/querying data from .mdb file into Excel jimmy shaker. Excel Programming 5 January 11th 04 03:38 PM
Help with data importing from txt file to excel programmatically SUDHENDRA Excel Programming 2 December 7th 03 02:14 PM
Importing data from an Excel file on a web server using ADO/VBA Dean Frazier Excel Programming 0 November 13th 03 12:39 AM


All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"