find and compare data with few workbooks

M

munkey

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding and Replacing Data in a Header Row 0
Need Help with a VBA subroutine 0
Problem with hyperlink macro 0
Internal Data Integrity (Type 4) Details Needed 1
Lookup data from another excel files 1
slow code with many loopings 6
Merging from an Excel file with graphics 1
finding duplicates and deleting based on another column 5

Top