Comparing Workbooks

[Guest]

I have a workbook that has one worksheet in it with the following 5 columns:

A B C D E
ID# Inpatient Charges InNetwork Price Amount
1 500 Y $156 Y $55
2 500 Y $450 Y $225
3 500 Y $398 Y $125
4 502 Y $499 Y $250
5 502 Y $219 Y $99

It has duplicated ID#'s with different info in columns B,C,D,E. This file
has 4000 records.
The workbook is sent to a vendor and when the file is returned some of the
records are altered, some records remain the same or additional records are
added. Column E is basically changed to give me a re-priced amount.

A B C D E
ID# Inpatient Charges InNetwork Re-Priced Amount
1 500 Y $156 Y $100
2 500 Y $450 Y $235
3 500 Y $398 Y $125
4 502 Y $499 Y $189
5 502 Y $219 Y $99

How can I compare the two files to see what has changed? I am basically
checking manually. Please help! There has to be a better way especially
since I have other files to compare to from various vendors. I do not have
VB background nor understand it to its fullest potential.

 

[theDude]

Hi JS,

Here's a link to a previous post that I provided a solution which
should meet your needs:
http://www.excelforum.com/showthread.php?p=955417#post955417

Hope this helps,
theDude

 

[Guest]

Thank you.