pull column A from one file into another

M

munscher

excel 2000:

File (workbook) A has the following:
Column 1: First Name
Column 2: Last Name
Column 3: Telephone #
etc....

File (workbook) B needs to have the following:
Column 1: First Names from workbook A
etc....


File A and File B are two separate files all together (FileA.xls an
FileB.xls)

How do i reference one file from another
 
J

JMay

Open both files,
While in File B go to the cell that you want the First Name in (that is in
File A.xls).
In that cell enter = then switch to the File A and click on the cell
that has the appropriate First Name, then press the return key.
If your layouts are identical then do a CopyDown of the resulting formula
you entered.
HTH.
 
Top