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
Bookmarks