My macro works completely fine the only problem is I can only get it to copy all sheets on my current workbook. I would like to be able to define which sheets exactly to copy from. Here is the current macro.
Please Login or Register to view this content.
Last edited by arlu1201; 01-16-2013 at 07:15 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
Try this version of your code -
I was not sure how you were able to create a new sheet called "result" when there was already one. So i put in a check to see if the sheet exists.Please Login or Register to view this content.
Last edited by arlu1201; 01-17-2013 at 10:40 AM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The code you placed is still copying every sheet in the entire workbook. I only need it to copy result1, resutl2, result3, result4, result5, result6. I also have sheets titled, dashboard, Status, Google Doc, and Print Out that I do not want it to copy. Sorry for not being so clear as to I am not a typical forum user. I am just starting out on VBA with excel so I do not know much. Thanks for your help.
I have edited the code. Please try it and let me know.
Also, i am not sure if having the new sheet named as "result" will pose a problem since the source files also have "result" as the name.
If it does, we can maybe change it to "Summary" or something.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks