I have the following code that works perfectly except for the fact that when it creates the summary sheet it "duplicates it". Therefore, if I have 3 sheets it copies each of these 3 sheets to the summary sheet 2 times. It is creating the summary sheet and adding itself to the summary sheet. << If that makes any sense. Can someone help by fixing the code to not duplicate. Thanks!
Please Login or Register to view this content.
I'm glad my macro is useful to you. Odd... those blank lines at the top used to have authorship info...strange how they disappeared, heh.
The macro includes code to exclude the Summary from the copying which appears to have been edited so it is no longer correct:
Please Login or Register to view this content.
Original Code
Last edited by JBeaucaire; 04-27-2012 at 01:11 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ha yea i know you did it and i thought i would be the only one seeing it so i got rid of that stuff. I didn't think i would be reposting it. I still have that versionPlease Login or Register to view this content.
so can i do an else if so that sheet1 and the the summary are not copied?
Expand to this:
Please Login or Register to view this content.
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
Thanks Jerry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks