Hello Friends
How can I compare two workbooks for the worksheet names?
I have two workbooks.
Workbook "A" has about 120 worksheets and workbook "B" has about 50-60 worksheets. Worksheets in "B" are also there in workbook "A". I need to find out which worksheets in "A" are not in "B". Worksheets in "A" and "B" have same names.
Note: I don't need to comare the data. Only the worksheet names.
Thanks
How can I compare two workbooks for the worksheet names?
I have two workbooks.
Workbook "A" has about 120 worksheets and workbook "B" has about 50-60 worksheets. Worksheets in "B" are also there in workbook "A". I need to find out which worksheets in "A" are not in "B". Worksheets in "A" and "B" have same names.
Note: I don't need to comare the data. Only the worksheet names.
Thanks