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)