Check if there is a match to a cell in the rest of the workbook [Solved/Closed]

Ask a question Ixon - Latest answer on Apr 11, 2016 04:45PM
I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list that was used is a bit out of date. I need to find out which of the values in the up-to-date list are missing from the rest of the workbook. Is there a formula or macro that will allow me to do this?
See more 
moins plus

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from CCM forum users to correspond showing mutual respect. Therefore, when requesting assistance, it is suggested to be courteous, as for elsewhere in similar circumstances. (i.e. please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.


Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!