Comparing 2 worksheets

Dear all,

I have 2 worksheets from 2 different companies with several columns of data. To demonstrate, i've attached a sample file. Sheet 1 and sheet 2 are the worksheets from both companies. From the 2 worksheets, only 1 column contains figures that are common to both, column D on sheet 1 and column A on sheet 2. What I wanted to accomplish was something as shown on sheet 3.

If the "amount" column were all unique, I would be able to do this, but since there are multiple entries with the same value, I don't know what to do anymore :D My failed try is on sheet 4 :D

Hope someone could help me, don't even know if what I need is possible at all

TIA!

You are right, having just the amount field as the common field between the sheets wont help. This is going to make it tough to actually compare the sheets.

Yes its possible. Why dont you attach a sample file with this field?

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

You are welcome. Not a lot of work if you have the logic straight

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save