i'm looking to be able to do something extremely specific. i need to be able to take 2 different excel files (woorkbooks is fine too) and cmopare/copy/save for me. a cool ass macro is what this would be honestly. or a sweet tool that i would love to have.
here is an example to make it alot easier.
i have an Excel file 1 that has 200 rows. each with these columns (in order): Part Number, Desc, Jobber, WD, Our Price, Weight. this is our personal file. now, we have another file for a specific manufacturer. we'll say Ford Racing Parts. they have 5000 rows. thier columns are more indepth. they have #/weight, JB, WD, H, W, L, Weight, blood type.
i need to compare my specific rows with thier rows by the part number (or whatever column that i need to compare by) and find out the differences. but what i need the most is to be able to copy thier information to another workbook or Excel file. so i have another file with thier row/column information with mine.
i know that this macro would be a king of macros so if there is a tool i'd greatly appreciate finding out what it is.
these images should help.
the first is just to show the one that i've got. numbers are made up by the way. now, i have this:

and i have this:

the idea is to get and compare the row information from the first pic (using model number column) and comparing with the information from the second pic. then i store or save that information into another file.
ideas? tell me you people know of a tool or a sick ass macro that does this. it wouldn't save my life but it would make everything soooooooooo much easier.
thanx
-The Taters