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
