issue macro copying not required data for summarizing information

[JEAN1972]

I have a workbook with several sheets .

The code below copy all sheets to a summary sheets by inserting the sheetname and its data per sheet.

But the issue is that it recopies on itself ,the summary data which is wrong in the summary sheet.

The green tab is the summary sheet is the correct results

Please Login or Register  to view this content.

[BadlySpelledBuoy]

It's case sensitive. Your summary sheet is called "Summary" and your code is looking for "SUMMARY".

So either change this line:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

BSB

[JEAN1972]

Thank you working now

[BadlySpelledBuoy]

Happy to help

BSB