Loop through workbook and compare the columns

Hi everyone,

I'm trying to loop through a workbook with multiple sheets, and compare the same columns in the whole workbook and highlight the difference.

What I want to achieve is to check everything in column B and C, Column B is delivery date and C is the id. I want to make sure that similar id hasn't been input a different delivery date.

For example In the workbook if there's a sheet with same id has a delivery date and on another sheet it has a different delivery date then highlight all in the same id in C in the whole workbook.

Originally Posted by JLGWhiz

Your attached file bears no resemblance to your narrative and your narrative is not clear on what you want highlighted. Maybe if you can clearly define what you want, someone can assist.

Apologised, I'd attached a wrong example

Here's a way to accomplish this using a dictionary - note that you will have to enable Microsoft Scripting Runtime (under Tools > References). Also, this loops through all the sheets in the active workbook - if you have some that should not be examined, the sheet reference will need to be changed.

Please Login or Register  to view this content.

Originally Posted by danielexcelvba

Here's a way to accomplish this using a dictionary - note that you will have to enable Microsoft Scripting Runtime (under Tools > References). Also, this loops through all the sheets in the active workbook - if you have some that should not be examined, the sheet reference will need to be changed.

Please Login or Register  to view this content.

Hi danielexcelvba

I try the code on the main workbook there's a run time error. I can't post the main workbook on here but the example workbook for the 2 columns are the same as he main workbook the only differences is that the main workbook has 200+ sheets.

The number of sheets could be an issue. Seeing as you can't post the real workbook, you'll have to edit this slightly.

Please Login or Register  to view this content.

If you change the bolded code to an array of the sheet names you want to search it should work.