Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 workbooks - how do I find duplicate entries by comparing the two | Excel Discussion (Misc queries) | |||
comparing workbooks | Excel Discussion (Misc queries) | |||
Comparing data on 2 workbooks | Excel Worksheet Functions | |||
Formula for comparing text in two workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |