I have a Workbook named reportQue.xls with one sheet named "reportQue". I simply need to copy sheet "reportQue" into a workbook that I have named "As Built Template".
Note: Both the reportQue.xls and As Built Template.xlsm files will be open when this VBA code is ran. No need for code that will open and close them.
Thanks!
Look at the code using your macro recorder. run the macro recorder, right click on the sheet tab and copy the sheet to the other workbook, stop recording the macro, then look at the code.
CC268:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thanks guys!
Happy to help CC268!
Thanks for the rep. If your issue is solved please remember to mark the thread as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks