How can I merge two or more Excel files into one file?  Each file currently 
has a different name and different data.  Thanks.....Chem303

Hi
see your other post

-- 
Regards
Frank Kabel
Frankfurt, Germany
"Chem303" <Chem303@discussions.microsoft.com> schrieb im Newsbeitrag 
news:8D2A1E82-FBF8-456F-9E67-FEEEB1E9D30E@microsoft.com...
> How can I merge two or more Excel files into one file?  Each file 
> currently
> has a different name and different data.  Thanks.....Chem303 

I also need to do this. I have one spreadsheet with a list of names I need 
labels for and another spreadsheet that has those names mixed in with 10,000 
other names but that one has the addresses I need for the first spreadsheet! 
Any ideas? Pivot tables were mentioned to me, but I haven't been able to 
figure that out yet.

Nadyne

"Frank Kabel" wrote:

> Hi
> see your other post
> 
> -- 
> Regards
> Frank Kabel
> Frankfurt, Germany
> "Chem303" <Chem303@discussions.microsoft.com> schrieb im Newsbeitrag 
> news:8D2A1E82-FBF8-456F-9E67-FEEEB1E9D30E@microsoft.com...
> > How can I merge two or more Excel files into one file?  Each file 
> > currently
> > has a different name and different data.  Thanks.....Chem303 
> 
> 
> 

Hi
sounds more like using VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html

-- 
Regards
Frank Kabel
Frankfurt, Germany
"Nadyne" <Nadyne@discussions.microsoft.com> schrieb im Newsbeitrag 
news:F842E72C-D91F-4195-806B-BEE5565DE4C0@microsoft.com...
>I also need to do this. I have one spreadsheet with a list of names I need
> labels for and another spreadsheet that has those names mixed in with 
> 10,000
> other names but that one has the addresses I need for the first 
> spreadsheet!
> Any ideas? Pivot tables were mentioned to me, but I haven't been able to
> figure that out yet.
>
> Nadyne
>
> "Frank Kabel" wrote:
>
>> Hi
>> see your other post
>>
>> -- 
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>> "Chem303" <Chem303@discussions.microsoft.com> schrieb im Newsbeitrag
>> news:8D2A1E82-FBF8-456F-9E67-FEEEB1E9D30E@microsoft.com...
>> > How can I merge two or more Excel files into one file?  Each file
>> > currently
>> > has a different name and different data.  Thanks.....Chem303
>>
>>
>>