Merge specific sheets in a workbook into one summary sheet (by 'Author:Jerry Beaucaire)

**marreco** · 10-02-2013, 08:20 AM

Hi.
I'm trying to adapt co code below.
how to get it just the tabs that desire and not all that are in the spreadsheet?

Erro in this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Izandol** · 10-02-2013, 08:26 AM

You may not do that because cs is a Worksheet variable. You may use:

Please Login or Register  to view this content.

**marreco** · 10-02-2013, 08:32 AM

Sorry.
your code returned the names of the tabs, should return the data

**Izandol** · 10-02-2013, 08:55 AM

My code did not return anything - it only changed the loop.

**AB33** · 10-02-2013, 09:08 AM

If you want to loop through select sheets

Change the following lines
Remove this line and replace it with

Please Login or Register  to view this content.

And this line

Please Login or Register  to view this content.

with

'Process each data sheet

Please Login or Register  to view this content.

Please Login or Register  to view this content.

'No need for this line and end if

**AB33** · 10-02-2013, 09:10 AM

Please Login or Register  to view this content.

**marreco** · 10-02-2013, 09:22 AM

After the code runs, which has data in column A (Name Guide), column B (data in column B) etc..

this is not happening

**AB33** · 10-02-2013, 09:33 AM

Please run the code by steeping over using F8 and see which line is not working, or better attach a sample.

**marreco** · 10-02-2013, 09:38 AM

Hi, i make tests and it work!

Thank you!!

Re: Merge specific sheets in a workbook into one summary sheet (by 'Author:Jerry Beaucaire