Hi,

I want to write a macro which compares two sheets (say sheet 1 and sheet 2) as following :

Sheet1
A B C D E F G H I J K L M
2 4 5 Y F D 3 1 G S 2 4 5
1 3 7 U F G 2 6 J K L 3 5
2 6 5 N G S 3 1 G R 9 0 1

Sheet2
A B C D E F G H I J K L M
2 4 4 Y F D 3 3 G S 8 4 5
1 3 7 U F G 2 6 J K L 3 5
2 6 1 N G S 3 1 P Q 9 0 1

It checks from sheet 1, one by one each row if in any row of sheet 2 has matching entry in column A, B, F and G (same as that of sheet 1), it copies the whole row of sheet 1 into sheet 3 and of sheet 2 into sheet 4.

i am a researcher and need it badly for data analysis...lottttttttt many thanks in advance....

Does this help to start and maybe modify to fit your particular needs