Page 1 of 1

[56K WARN] Excel Question

Posted: Mon Dec 18, 2006 10:38 am
by MrPotatoes
if there is a tool for this then awesome. please tell me. otherwise i'm going to just ask right here.

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:
Image

and i have this:
Image

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

Posted: Mon Dec 18, 2006 10:42 am
by feyd
Dump the files into two tables in a database and compare with funky queries? :)

Posted: Mon Dec 18, 2006 10:46 am
by MrPotatoes
i would and i could possibly make it work in a few min but the simple matter of the fact is that i'm getting this tool for 2 completely computer illerate old men to use the tool when i leave in a month or two. they don't know how to start my local server, nor would they know how to format the data or whatever.

shoot, sometimes, they ask me how to type a letter in Word. haha

Posted: Mon Dec 18, 2006 11:38 am
by Jenk
VB can access Excel sheets as data objects. You can possibly do this in VBA, too.

Otherwise.. copy and paste the sheets into the same workbook and use the trusty ol' =(SUB(sheet1.a1, sheet2.a1)) formulae..