Merging two excel files

[JF]

I was wondering if anyone knows how to merge two files of
information that have at least one common field.

One of the files recieves a feed from an Oracle Database
so the one file will still need to be able to recieve that
feed.

Anyone...Anyone

 

[David McRitchie]

Are you familiar with the VLOOKUP Worksheet Function.
Don't know if that will solve your problem but you've not
indicated how the files which I presume you mean
worksheets are to be combined.

VLOOKUP
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[rfi234]

If you have multiple excel files and need to merge the data (vertically append them), you can use Excel File Merger program (windows version is called Bulk File Merger).