Compare multiple worksheets

Thanks in advanced for your 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 (Compared to last worksheet)
Sheet2 95% Match (Compared to last worksheet)
Etc.

Thanks again!

Hi
Pl upload a sample workbook with Option numbers and expected output
Ravi

Attached is the file that you requested.

Please keep in mind that I will be adding Sheets

The latest Sheet will be compared to the stored ones.

The result will show a message with a matching percentage of option numbers.

In the example, Sheet3, compared to Sheet1, will show a 90% match.

Sheet3, compared to Sheet 2, will show a 80% match.

This results will be shown in a message box.

Thank you

has anyone seen my post? Please, this is very urgent to solve this challenge.

Thank you

Help needed for this thread. thank you

Please help with this thread

Hi
Test the macro in the attached file with fresh data and let me know if you are getting what you want.
Ravi