Hi everyone,

I have codes which is working perfectly fine for summing the data from multiple workbooks to a master workbook and according to its worksheet.

The problem I have now is some workbooks have only 1 worksheet and some 2 worksheets. While some have all the worksheets.

What codes should I add to my codes below for VBA to ignore/skip summing the worksheets that does not exists in the workbooks and skip to other worksheets?


Thanks


Please Login or Register  to view this content.