Macro to compare two spreadsheets and output results in another spreadsheet

[mg2743]

Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I am searching for a macro that can do the following, can anyone please help me. Thanks
<o> </o>
I have two spreadsheets, spreadsheetA and spreadsheetB. SpreadsheetA has x columns with data and SpreadsheetB has y columns with data. Now I want to compare both spreadsheets and retrieve the records in spreadsheetA where the data in the columns of spreadsheet B match to their corresponding columns data in spreadsheet A
<o> </o>
For example<o></o>
Spreadsheet A has records under columns A,B,C,D
Student1, course1,adresss,country
Student2, course2,adresss,country
Student3, course3,adresss,country
Student4, course4,adresss,country
<o> </o>
Spreadsheet B has records under columns A,B,
Student1, course1
Student2, course2
<o> </o>
Output spreadsheet when I run the macro should now display
Student1, course1,adresss,country
Student2, course2,adresss,country

 

[villy]

Where do you want your output to be placed?In another spreadsheet C?

 

[mg2743]

Where do you want your output to be placed?In another spreadsheet C?

Yes Villy, you are correct.