Macro to consolidated all data from different sheets to summary sheet in the same workbook

[rochakmehta90]

Hi All,

I need macro to copy data from all sheets to one summary sheet already created in the same workbook.

Like I have around 50 different sheets from which I have to copy data in to summary sheet one by one.

I have attached my sample workbook and also wrote some guide points for your understanding....

Thank you in advance...

[oeldere]

Run this macro below in the file.

Sub integratie_Oeldere_revisted_vs2()

See the attached file for the result.

[oeldere]

With the help of AB33 (AB33 thanks for that ) you get the revisted code, in the attached file.

You find the code here:

Please Login or Register  to view this content.

[rochakmehta90]

Thank you oeldere for the help....

[oeldere]

Thanks for the reply.

Glad i could help.

And did it work for you?

[rochakmehta90]

Yes its working...

But I haven' tried on my mega sheet...I will have chance to try it on 20th..and let you know about it...

Thank you once again...