Hi,
I have a file which has 5 sheets and I am creating a macro which should copy 3 sheets (GP_Approval, Country; Summary) into a new workbook.
It seems like my code is not the appropriate one. Thank you.
Please Login or Register to view this content.
maybe try this?
(untested)Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
you have omitted the paste portion of the copy/paste routine
Here are a couple of scenarios to learn this:
http://stackoverflow.com/questions/6...book-using-vba
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks but unfortunately, it gives me also error.
Simarui, Thanks but unfortunately, it gives me also error.
Could you please upload the workbook....?
Last edited by LokeshKumar; 04-17-2015 at 09:01 AM.
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
this seems to be working:
Please Login or Register to view this content.
Thank you Simarui.
That works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks