How do you import data from one spreadsheet to another in Excel?

**Jay Sarfati** · 05-17-2018, 06:55 PM

I have an Excel file (a directory) containing a complete list of employees, their ID numbers, and other personal info like addresses and phone numbers.
I have another Excel file (an attendance sheet) containing the names of employees who attended a conference.

Is there a way to automatically retrieve employee ID numbers from one spreadsheet (directory) and incorporate into another (attendance sheet) without using a database? Is it possible to cut and paste the names in the attendance sheet into a new worksheet of the directory and have Excel fill in the corresponding ID numbers? Thanks.

**alansidman** · 05-17-2018, 06:58 PM

If all the employees have unique names, then you could probably use the Vlookup or Index/Match functions to retrieve the data.

**Jay Sarfati** · 05-17-2018, 07:30 PM

Thanks for pointing me in the right direction. That deserves a star.

How do you import data from one spreadsheet to another in Excel?

LinkBack

Thread Tools

Rate This Thread

Display

How do you import data from one spreadsheet to another in Excel?

Re: How do you import data from one spreadsheet to another in Excel?

Re: How do you import data from one spreadsheet to another in Excel?

Thread Information

Users Browsing this Thread

Similar Threads

Import data from Google Spreadsheet to Excel

[SOLVED] How to import data from a spreadsheet to a excel or word form for printing

Sample of Excel Spreadsheet used to import data to Turbo Lister 2 ?

[SOLVED] How do I import data from a closed Excel Spreadsheet?

[SOLVED] How do I import data from RightFax into an Excel spreadsheet?

Can you import data into specific cells of an Excel spreadsheet?

Can you import data from a scanner into an excel spreadsheet?

Bookmarks

Bookmarks

Posting Permissions