compare worksheets

[shahcu]

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

[arthurbr]

Hi
could you please post a sample of your sheet and what you want to achieve?
Thx

[shahcu]

The macro which is available in sheet1 provided by one of the experts on the same forum... Now what I want is when the next time user enters data in sheet one and runs the macro the entire data get saves in sheet2. which is happening right now also. Once that is done then sheet2 gets compared with Master and only those records are not available in Master sheets get copied from sheet2 and finally once the paste operation is done the entire rows which gets copied from sheet2 gets either colored or selected .. so that at first look anyone can easily find out that the additional data in master sheet...