Excel Challenge: Compare multiple worksheets macro
Victor,
2 things,
1) You need to pass a column into the function that analyzes the sheets, so
I changed that to 1 instead of 3.
2) I was expecting dupilcates to be in the sheets, and didn't code for what
would happen if there were no duplicates. I test for that case now. I sent
you a new workbook with the code and your data set.
Bob
|