View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default How to combine two different excel files

I would like to combine two different Excel files into a new 3rd file. It's
important that each row is in sync with a reference cell. Each of the
original files have a common column reference such as cell A1=234 in both
files.
Example:
File 1 and the following row: user, fname, lname
File 2 has the following row: user, street, city, etc.

where as "user" is a number and the same in both.