Comparing Workbooks

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.

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...417#post955417

Hope this helps,
theDude

Thank you.

"theDude" wrote:

>
> 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...417#post955417
>
> Hope this helps,
> theDude
>
>
> --
> theDude
> ------------------------------------------------------------------------
> theDude's Profile: http://www.excelforum.com/member.php...o&userid=16550
> View this thread: http://www.excelforum.com/showthread...hreadid=478020
>
>