Move that tab to a new workbook
Closed
eaja2
Posts
1
Registration date
Saturday May 5, 2018
Status
Member
Last seen
May 5, 2018
-
Updated on May 6, 2018 at 06:19 AM
Blocked Profile - May 6, 2018 at 09:53 AM
Blocked Profile - May 6, 2018 at 09:53 AM
Im relatively new to excel macros and have done half of what i need to do. I created a macro that takes data from one tab (which contains a pivot table), and i have been able to successfully copy that tab, and paste it with values and formatting onto another new tab that is created by the macro. I would like to next move that tab to a new workbook. That is where the macro would stop. I would then manually save that new workbook to a specific drive.
How can i have the macro move the new tab automatically to a new workbook. I run into a problem because i need to do this about 100 times and the worksheet that i create has a different name...any thoughts?
How can i have the macro move the new tab automatically to a new workbook. I run into a problem because i need to do this about 100 times and the worksheet that i create has a different name...any thoughts?
Related:
- Move that tab to a new workbook
- Edge open new tab as popup - Guide
- Java update tab missing - Guide
- Samsung galaxy tab lock screen while watching video - Guide
- How to delete icloud tabs - Guide
- Opera incognito tab - Guide