LinkBack URL
About LinkBacks
Anyone knows a macro that will copy a specific worksheet and place it into an existing workbook?.
I have the code shown below but it copies all the worksheets.
Any help will be greatly appreciated.
Please Login or Register to view this content.
Anyone knows a macro that will copy a specific worksheet and place it into an existing workbook?.
I have the code shown below but it copies all the worksheets.
Any help will be greatly appreciated.
Please Login or Register to view this content.
Start your macro recorder
Right Click on your sheet name at the bottom of excel and select copy or move
click on copy in the message box
Then use the combo box to select where you want the sheet moved to
select ok
Stop your Macro Recorder.
That is your macro done and dusted.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks