The scenario is I have 15 sheets named "MAP_COMBINED" , "MAP_COMBINED (2)", "MAP_COMBINED (3)", "MAP_COMBINED (4)"...............to , "MAP_COMBINED (15)".
I am not really good at VBA Coding and I wonder if it is really possible to have a MACRO to simultaneously copy and move them into one worksheet together with a Dialog box/Pop up input box ="NAME" of the new worksheet and rename the (15) sheets based on its cell value on BT3?
Thank you!
Last edited by archvanarl; 04-01-2019 at 12:27 AM.
Bump for the code. Have a nice day!
Hi! Bump for the techies!!:D
Bump.. :D for the last one..
To be beneficial to everyone who might be needing this. This is the code that I have come to work through research.
Please Login or Register to view this content.
Thank you!
Last edited by archvanarl; 04-08-2019 at 11:36 AM.
Administrative Note:
Thank you for posting the solution, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks