Importing specific fields from one excel spreadsheet to another

[jaypoole]

I have two spreadsheets with useful information in both, some of which I need to merge together. They have been built with excel 2003.

Spreadsheet A is the one I want to use as my building base. I want to import specific fields of information from spreadsheet B. The common key to both spreadsheets is the persons name or their mobile phone number.

I have tried using Data -> Import External Data -> Import Data but then after specifying a source (being spreadsheet B) it seems to want to import everything in one go...? - not sure how I specify individual fields and mappings.

Can someone tell me the easiest way to go about doing it?

Thanks..




I want to import some of the information from the older spreadsheet into another that has been revamped.

 

[sawedoff]

You porobably want to use either vlookups, ifs, or other functions to look at the other sheet and bring in the results of specific cells form the other sheet. You are effectively linking cells to the other sheet. For example, if you want the address of Bob Smith from sheet 1, the cell in sheet 2 may be a vlookup that pulls from the address column if the name column is the same as the name column on sheet 1. The formula might be something like this:

=VLOOKUP(A3,[Addresses.xls]Sheet1!$B$2:$C$6,2,FALSE) where Addresses.xls is the original data.

Sawedoff