compare a row with all the rows of anothre sheet

hi,
i have a problem in writing macro for comparing two sheets in a workbook in such a way
if first row of first sheet match with any row of second sheet then copy that row on another sheet and then if second row of first sheet match with any row of second sheet then copy it to third sheet
this process must continue till all the row compared one by one of first sheet with second sheet
means i just need to compare 1st row of first sheet with all the rows of second sheet then 2nd row with all then 3hird row and so on
please help me to slove this problem i have attached the excel file that have three sheets i want to compare rows of sheet 700days with sheet Nifty BB-1 Long 250 days 60min

Hello, Sharad;

Please attach a sample file...!

Scroll down & click Go Advanced then down click Manage Attachments, browse your file click on Upload

hi
i have attached the the sample file in which there are three sheets Nifty BB-1 Long 250 days 60min ,700days and 250 days now i want to compare each row of sheet 700days with sheet Nifty BB-1 Long 250 days 60min in such a way as i defined above in the previous qoute

See the attached,

Col_A contains Array Formula to get the row numbers. If you have huge data this may slow up the calculation.

hi
i have attached the the sample file in which there are two sheets Nifty BB-1 Long 250 days 60min ,700days and now i want to compare each row of sheet 700days with sheet Nifty BB-1 Long 250 days 60min in such a way as i defined above in the previous qoute

--------------------------------------------------------------------------------

hi,
i have a problem in writing macro for comparing two sheets in a workbook in such a way
if first row of first sheet match with any row of second sheet then copy that row on another sheet and then if second row of first sheet match with any row of second sheet then copy it to third sheet
this process must continue till all the row compared one by one of first sheet with second sheet
means i just need to compare 1st row of first sheet with all the rows of second sheet then 2nd row with all then 3hird row and so on
please help me to slove this problem i have attached the excel file that have two sheets i want to compare rows of sheet 700days with sheet Nifty BB-1 Long 250 days 60min
please help me