Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
join imported Excel 2007 files
I have two Excel 2007 files that I need to join to form one spreedsheet of
data. I have the unique identifier column in both files. There will be some records (rows) that are in one file but not in the other that need to be kept as well. How can I pull all of this data together using the unique identifier column in both files? (82,000 records) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
join imported Excel 2007 files
Hi,
Refer to this article http://datapigtechnologies.com/blog/...iles-method-2/ -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Dayle" wrote in message ... I have two Excel 2007 files that I need to join to form one spreedsheet of data. I have the unique identifier column in both files. There will be some records (rows) that are in one file but not in the other that need to be kept as well. How can I pull all of this data together using the unique identifier column in both files? (82,000 records) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 not showing imported numbers in pivot table | Excel Discussion (Misc queries) | |||
Accessing imported Excel files after Office 2003 SP3 upgrade | Excel Discussion (Misc queries) | |||
imported images in Excel 2007 | Excel Discussion (Misc queries) | |||
sorting on imported Data Excel 2007 | Excel Discussion (Misc queries) | |||
how do I join multiple excel files into 1 file? | Excel Discussion (Misc queries) |