How Do I Cross Reference 2 Excel Sheets?

Question

I have 2 Excel Sheets that contain information that I need on one sheet.

For example, sheet 1 has names, phone #s, and addresses, but it does not have emails.

Sheet 2 does contain emails.

Is there a way to cross reference all of these items and end up with one sheet that contains all f the information?

Answer 1

You can do this two ways.
Build a macro to do it or, Link the two sheets.
Linking is done by:
Copy a cell or range from one sheet, then paste to another sheet. BUT, Do Not use just the paste command.

When you Right click to paste, Choose Paste Special.
From the popup, choose "Paste Link", at the bottom of the popup.
This will paste a link to the new sheet and will constantly update the information from the original sheet to the new sheet.

You can also use the paste link from one file to another. When the destination file is opened, it will automatically update.


This will use more memory by formulas than a macro, where a macro will do the job only when you run it, although it can be programmed to run on opening the file.

I'm short on knowledge of macros, although I could possibly do it.
This is a group where you may find help by experienced users.
http://groups.google.com/group/microsoft.public.excel.programming/topics

Answer 2

Excel Cross Reference

Answer 3

This Site Might Help You.

RE:
How Do I Cross Reference 2 Excel Sheets?
I have 2 Excel Sheets that contain information that I need on one sheet.

For example, sheet 1 has names, phone #s, and addresses, but it does not have emails.

Sheet 2 does contain emails.

Is there a way to cross reference all of these items and end up with one sheet that contains all f...

Answer 4

how about u just copy from sheet 2 to sheet 1? another way is using microsoft access but i dont recommend it unless u r planning to do a complicated database..

Answer 5

If the names are on both sheets in the same format use vlookup to bring back the missing data.

If names are in column A on both put =VLOOKUP(A1,Sheet2!A:F,2,FALSE) into the cell on sheet one you want the email address in. Change A1 to match the cell with the name in on sheet1, change A:F to match the range of columns with the data in on sheet2 and change 2 to match the column with the emails in on sheet2.