Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to combine two different excel files
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. "Mike" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I combine several excel files into one? | Excel Worksheet Functions | |||
How to combine data from 100 similar Excel files | Excel Discussion (Misc queries) | |||
Combine two Excel Files | Excel Discussion (Misc queries) | |||
how to combine multiple files in ms excel | Excel Discussion (Misc queries) | |||
Combine multiple Excel files into one master | Excel Discussion (Misc queries) |