Creating a macro that will create a new sheet and copy data from
Closed
Susan
-
Mar 18, 2016 at 05:04 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 19, 2016 at 10:42 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 19, 2016 at 10:42 PM
Related:
- Macro to create new sheet and copy data
- Create skype account with gmail - Guide
- To create a network bridge you must ✓ - Network Forum
- Google sheet right to left - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Create new instagram account without phone number - Guide
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Mar 19, 2016 at 01:46 AM
Mar 19, 2016 at 01:46 AM
Hello Susan,
Have a look at the following thread:-
https://ccm.net/forum/affich-859527-vba-copying-data-to-new-sheets
My post#2 gave the OP a solution but he did not have the courtesy to reply so we don't know if it worked for him.
I believe that your situation is similar. Following is the link to my test work book for the thread mentioned above. Have a look and see what you think:-
https://www.dropbox.com/s/2qopzyktfjjoj94/Rayz221%28Create%20Sheets%20%26%20Copy%20Data%29.xlsm?dl=0
Let us know what you think so we can help further if need be.
To run the code, press Alt+F8, make sure that the macro name is high-lighted then click on Run.
Cheerio,
vcoolio.
Have a look at the following thread:-
https://ccm.net/forum/affich-859527-vba-copying-data-to-new-sheets
My post#2 gave the OP a solution but he did not have the courtesy to reply so we don't know if it worked for him.
I believe that your situation is similar. Following is the link to my test work book for the thread mentioned above. Have a look and see what you think:-
https://www.dropbox.com/s/2qopzyktfjjoj94/Rayz221%28Create%20Sheets%20%26%20Copy%20Data%29.xlsm?dl=0
Let us know what you think so we can help further if need be.
To run the code, press Alt+F8, make sure that the macro name is high-lighted then click on Run.
Cheerio,
vcoolio.
Mar 19, 2016 at 06:53 PM