Regarding a real time problem I am facing while working.

[Sumee]

Hi, I hope you are doing well.
Click here to go to sheet

The file that I have uploaded contains two tabs, one is "OLD" which consists of 96 entries and the other is "NEW" which consists of 189 entries.

"NEW" is the updated sheet that includes all of the entries that are present in "OLD" along with some new entries.

Now there are Two tasks that need to be performed:

Task 1: the newly added entries in the "NEW" tab that are not present in the "OLD" tab must be extracted to a different sheet and the comparison should be done on the behalf of 2 columns, Name of the 1st column is " Measurand or Reference Material/Type of instrument or material to be calibrated or measured / Quantity Measured /Instrument" and Name of the 2nd is "Range".

Task 2: In the "NEW sheet" we must apply conditional formatting to the newly added entries and the comparison should be done on the behalf of 2 columns, Name of the 1st column is " Measurand or Reference Material/Type of instrument or material to be calibrated or measured / Quantity Measured /Instrument" and Name of the 2nd is "Range".

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Regarding a real time problem I am facing while working
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.