[56K WARN] Excel Question

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
MrPotatoes
Forum Regular
Posts: 617
Joined: Wed May 24, 2006 6:42 am

[56K WARN] Excel Question

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Dump the files into two tables in a database and compare with funky queries? :)
User avatar
MrPotatoes
Forum Regular
Posts: 617
Joined: Wed May 24, 2006 6:42 am

Post 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
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post 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..
Post Reply