Prev: Lookup data in the list
Next: Is there a function in excel where you can the beginning of the mo
From: Dayle on 21 Jan 2010 12:11
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)
From: Ashish Mathur on 21 Jan 2010 19:19
Hi,

Refer to this article

http://datapigtechnologies.com/blog/index.php/using-access-to-combine-multiple-excel-files-method-2/

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dayle" <Dayle(a)discussions.microsoft.com> wrote in message
news:3C97F8E1-8E44-4206-A855-23ABF45AC3E0(a)microsoft.com...
> 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)

 | 
Pages: 1
Prev: Lookup data in the list
Next: Is there a function in excel where you can the beginning of the mo