find and compare data with few workbooks
 

hi,

i have 2 raw data excel files and 1 main file.

Example:

Main excel file-
column A-F with different details each column
no.of rows: till end of row

A B C D E F
abc apple 4 32 bbb 2
abc orange 4 20 bbb 2

I would like to match my raw data files with my main file
raw data files same no.of columns but more row than Main.xls.
- search thru raw data file to find the row match
- would like to copy the MAIN.xls 'column E' details if do not match with
'column E' in raw data excel file, in a new column in the raw data file.