Combine all sheets into one new sheet

[aarona]

Hi All,

Will be needing your help again in combining all of the sheets of the current workbook into one sheet.

Note:

• Headers are identical so no need to repeat headers, only the contents needs to be combined

• Number of sheets is not fixed - im assuming we can use for each sheets in activeworkbook?

Attached is the sample file and the desired output.

Thanks!

[AliGW]

On hand-held devices, space is at a premium, so I have removed the unnecessary "Help" from your thread title which might prevent mobile device users fromn being able to see the important part of your thread title.

[Trebor76]

Hi aarona,

As this is virtually the same query I just answered here, it was no time to come up with this which should do the job:

Please Login or Register  to view this content.

Regards,

Robert

[aarona]

Hi aarona,

As this is virtually the same query I just answered here, it was no time to come up with this which should do the job:

Please Login or Register  to view this content.

Regards,

Robert

Thanks Robert. Your code works fine, however there is one downside, if the "header" is not yet present in the sheet it will return an error.

[jindon]

Try,
This one will only copy if the sheet name begins with "Month".

Please Login or Register  to view this content.

[ImranBhatti]

Try this

Please Login or Register  to view this content.

[aarona]

@All Thanks! all your codes are working.

[ImranBhatti]

You are welcome and thanks for the rep+