Help for enhance the code - Excluding Sheet While Consolidation

[ExcelUser2707]

Hi Experts,

I have code which is doing consolidation of all spreadsheet to master sheet.

I want to exclude one sheet say “Project 2”, while consolidation “Project 2” data / or sheet require to excluding.

I am attaching code for your reference.

Illustration fill is attached for your ready reference.

Thanks in advance

Amar K

Please Login or Register  to view this content.

[AB33]

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

[ExcelUser2707]

HI AB33,

Your suggestion work very well..

SIR, What coincidence which code I shared for enhancement, is also suggested by you.

Thanks A LOT Sir, For sharing valuable knowledge & guideline.

God bless you.

Thanks

Amar K