Report

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

Ask a question Ixon - Last answered on Apr 11, 2016 04:45PM
Hello,

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 
Helpful
+0
moins plus
Greetings,

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.)

http://ccm.net/contents/ccmguide/ccmcharte-respect-autrui.php3#politesse

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

We trust that you understand.

Moderator

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!