Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare data in two different workbooks | Excel Discussion (Misc queries) | |||
Macro to compare, find match and copy between workbooks | Excel Programming | |||
How do I compare data in 2 workbooks | Excel Programming | |||
How can I compare data on 2 workbooks | Excel Discussion (Misc queries) | |||
Is there a way to compare data on 2 different workbooks to find m. | Excel Worksheet Functions |