Combine two Excel files

P

Phil

Hi,
I have two Excel 2000 files that only contain two fields, Last-name and
First-name. I want to combine the two files into one. Isn't there a way to
import one Excel file into another? If so, how?

Your help would be appreciated.
Thanks,
 
J

Jim Cone

Phil,
You can copy one list and paste it below the other list.
Then use Data | Filter | Advanced Filter to have Excel pick out the
unique items.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Phil" <[email protected]>
wrote in message
Hi,
I have two Excel 2000 files that only contain two fields, Last-name and
First-name. I want to combine the two files into one. Isn't there a way to
import one Excel file into another? If so, how?

Your help would be appreciated.
Thanks,
 
Top