How to combine two different excel files

M

Mike

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.
 
T

trip_to_tokyo

Mike, this can be done but it is not straightforward.

If you really want to take this forward check out:-

Pivot Table Data Crunching for Microsoft Office Excel 2007

ISBN-13: 978-0-7897-3601-7

Chapter 7 pages 167 to 179 inclusive.

If my comments have helped please hit Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top