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.

Comparing Workbooks
 

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

Comparing Workbooks
 

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