Macro to combine selected sheets

[Exl_in_Training]

Hi everyone

I have an Excel document with a number of sheets, of which I would like to combine SOME of these sheets into a consolidated sheet. I have picked up a few examples that combines all sheets in the document, but cannot seem to find anything that isolates say only some for the consolidation process (say 5 sheets out of the 10 that is in the work document.

Is what I am asking possible?

Any assistance will be highly appreciated.

Thank you

 

[duggie33]

The link below demonstrates how to loop through selected sheets.

VBA for figuring out which sheets are selected when multiple sheets are selected

I have a workbook in which 1 sheet called "AverageEffect" I want to print differently, because I want to have it print out with 4 different print commands. So I want to use the BeforePrint macro to print all selected worksheets normally, but print this was one in a special way if it is...

www.mrexcel.com

Hope that helps,

Doug

 

[Exl_in_Training]

The link below demonstrates how to loop through selected sheets.

VBA for figuring out which sheets are selected when multiple sheets are selected

I have a workbook in which 1 sheet called "AverageEffect" I want to print differently, because I want to have it print out with 4 different print commands. So I want to use the BeforePrint macro to print all selected worksheets normally, but print this was one in a special way if it is...

www.mrexcel.com

Hope that helps,

Doug

The link below demonstrates how to loop through selected sheets.

VBA for figuring out which sheets are selected when multiple sheets are selected

I have a workbook in which 1 sheet called "AverageEffect" I want to print differently, because I want to have it print out with 4 different print commands. So I want to use the BeforePrint macro to print all selected worksheets normally, but print this was one in a special way if it is...

www.mrexcel.com

Hope that helps,

Doug

Thank you. It does explain a few things that I kept getting wrong.