I have three worksheets on same workbook. Sheet1 contains some data on which i have created a macro and I am getting result in sheet2. There is one anotherworksheet called Master that which is later used to store the copy of result which we are getting in sheet2. Now every time i run the macro it starts from the very first record and give the result in sheet2. User kept on updating sheet1 four - fives times a day.

WHat I need is once the user get the output in sheet2 it compare the data of sheet2 from master sheet in case if the record exist in master sheet nothing happens and in case record is not there in Master sheet then that very record get copied and pasted into master sheet as a next record.

We need to compare Sheet2 and master sheet on basis of values in Column B , E and M , if all the values of these 3 columns matches with each sheet same columns then only record needs to be copied in Master sheet.

Please assist