Hi,

I would need some help and advice how to compare two excel spreadsheets and
get the output of that comparison in a third excel spreadsheet.

I will give you a short description what kind of problem I have to solve:

-----------------
Spreadsheet 1

CUSTOMER INDUSTRY GEO REV. STEP ODDS IDENT.
Company A Automotive Europe 10000 5 50% ECT-123
Company B Electronic Europe 25000 3 25% QIT-456
Company C Automotive Asia 15000 6 75% APA-789
-----------------

-----------------
Spreadsheet 2

CUSTOMER INDUSTRY GEO REV. STEP ODDS IDENT.
Company B Electronic Europe 25000 3 25% QIT-456
Company M Automotive Asia 50000 6 75% APA-987
Company A Automotive Europe 10000 6 50% ECT-123
-----------------

And the output of the comparison shall look like this:

-----------------
Spreadsheet 3 (generated output)

SOURCE CUSTOMER INDUSTRY GEO REV. STEP ODDS IDENT.
Sheet 1 Company A Automotive Europe 10000 5 50% ECT-123
Sheet 2 Company A Automotive Europe 15000 6 60% ECT-123

Sheet 1 Company B Electronic Europe 25000 3 25% QIT-456
Sheet 2 Company B Electronic Europe 25000 3 25% QIT-456

Sheet 1 Company C Automotive Asia 15000 6 75% APA-789

Sheet 2 Company M Automotive Asia 50000 6 75% APA-987
-----------------

So the macro shall act in following steps:
1. Take first identification number of sheet 1 and search it in sheet 2.
2. List/copy the whole row of data of matches or mismatches in sheet 3 (see
example)
3. After the output of the comparison with the first identification number,
the macro shall get on with the second identification number and so on.

If you have any questions to my problem in order to help me, please contact
me.


Thank you very much for your help!