Does each worksheet have the same number of entries, or are they going to
have different amounts of information?

"FireVic" wrote:

Thanks in advanced for time:

I am going to be adding a list of option numbers with their description per
order to worksheets. The worksheets will be named sequentialy as Sheet1
Sheet2 etc.

The option number will be in column A and option description (useless so
far) will be in column b

Every time I add a worksheet, I want to be able to compare this worksheet
with all of the worksheets stored comparing common and uncommon option
between them.


When the comparison macro stops running comparing all of the available
worksheets, I should be able to see a percentage of matches (same value
options) per worksheet that exist in a message box. Like:

Sheet1 90% Match
Sheet2 95% Match
Etc.

Thanks again!