Compare data in two spreadsheets 2

[kernal]

I'm using excel 2003.

I have 2 spreadsheets.

example:

Spreadsheet 2:

col1 col2 col3
test 1 5.00
test 2 7.50
test 3 8.00

Spreadsheet 1:

col1 col2 col3
test 1 5.00
test 2 10.50
test 4 10.00

I want to compare spreadsheet 1 to spreadsheet 2 to find the differences:

test 1 - is ok because the same data is in both spreadsheets
test 2 - is not ok because col3 is different
test 3 - is not ok because it is not in spreadsheet 2
test 4 - is not ok because it is not in spreadsheet 1

Any ideas would be very helpful.

Thank you

 

[SkipVought]

Hi,

Check out this thread.

My reply about 2/3 down using MS Query.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[Stella740pl]

This thread68-1447263 probably is the thread SkipVought referred to (right?).

 

[SkipVought]

Thanx, Stella.

duh!

Actually it is this one thread707-1446120.



Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[xlbo]

or just a vlookup would probably do the trick...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[kernal]

Thanks everyone. I didn't have time until today to post a message. I'm going to try the suggestions now and will post again.

 

[kernal]

thanks for the information concerning msquery. I haven't completely tested it but it looks like it will work.