Macro to consolidated all data from different sheets to summary sheet in the same workbook
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...
Run this macro below in the file.
Sub integratie_Oeldere_revisted_vs2()
See the attached file for the result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
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.
Thank you oeldere for the help....
Thanks for the reply.
Glad i could help.
And did it work for you?
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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks