*Watch this video next* Learn Excel VBA to Save Hours at Work → ruclips.net/video/1uaqSQffi6k/видео.html *Click here for the article with full VBA code:* www.launchexcel.com/split-excel-table-to-many-sheets-with-vba *Learn how to set up and use your Personal Macro Workbook:* www.launchexcel.com/excel-personal-macro-workbook *Download the sample workbooks with full VBA code in a ZIP file:* d1yei2z3i6k35z.cloudfront.net/2762499/66fe76d0c5ac4_ExcelTableSplitterVBA.zip *Chapters:* 00:00 Excel magic... 00:49 Is this how you do it? 02:27 The Secret 04:37 Watch this 06:22 Step-by-step walkthrough 06:53 Get Your Own Personal Macro Workbook 08:16 Copy the VBA 09:31 Add custom button 10:49 Now for Part 2... The ONE Excel Feature I Wish I Knew Sooner ruclips.net/video/Rdqxwq_zRbQ/видео.html
Yes, thanks for mentioning Pivot Tables. I've seen two different ways to split data with PTs. But one thing I like about VBA is that we have greater control to automatically customize the formatting, like I applied column auto fit in this example, which the PT methods don't do. Also the PT methods I saw both left extra rows at the top of each sheet, for the report filter. With this VBA code, there are no extra rows.
Well it's not dynamic in that sense, if you add or update the main table then it won't automatically update on the separate sheet. To do that with VBA would need event handler code to check for changes, and it would make the code more complicated.
Hi Carlos, good spot! You’ve got a sharp eye, many people might miss those buttons up on top (for reference they appear at 3:00). The ones you’re referring to (Filter, Export, Delete, Lock, Unlock, etc.) aren’t part of Excel 365 or any other version out of the box. They’re custom controls I added myself in the same way I added the custom button at 9:31 in the video. Since you asked, here’s a list of videos showing the macros behind the custom buttons: ➡Filter Table to Sheets: This video (ruclips.net/video/dNJWpdDWWA4/видео.html) ➡Export Worksheets: ruclips.net/video/Rdqxwq_zRbQ/видео.html ➡Delete Sheets Except Active: (no YT video, can learn how to do this in my VBA course) ➡Lock Sheets 123: ruclips.net/video/Cx2t4BD3Juo/видео.html ➡Unlock Sheets 123: ruclips.net/video/Cx2t4BD3Juo/видео.html (same as above) ➡Remove Excel Protection: ruclips.net/video/Cx2t4BD3Juo/видео.html (same as above) Hope that helps you get those custom controls sorted. If you’re up for learning more VBA, the course goes into detail. go.launchexcel.com/macros-vba-school-youtube
If you want to do this from Excel, you would need to enable the Word Object Library in Excel VBA. • In the VBA editor, go to Tools > References. • Scroll down and check Microsoft Word xx.x Object Library (where xx.x is the version number). • Click OK. Then you would need to have the exact path to the Word document you want to process. After that, it's a matter of figuring out the specifics of doing the export. So it's possible with a certain amount of effort.
*Watch this video next*
Learn Excel VBA to Save Hours at Work → ruclips.net/video/1uaqSQffi6k/видео.html
*Click here for the article with full VBA code:*
www.launchexcel.com/split-excel-table-to-many-sheets-with-vba
*Learn how to set up and use your Personal Macro Workbook:*
www.launchexcel.com/excel-personal-macro-workbook
*Download the sample workbooks with full VBA code in a ZIP file:*
d1yei2z3i6k35z.cloudfront.net/2762499/66fe76d0c5ac4_ExcelTableSplitterVBA.zip
*Chapters:*
00:00 Excel magic...
00:49 Is this how you do it?
02:27 The Secret
04:37 Watch this
06:22 Step-by-step walkthrough
06:53 Get Your Own Personal Macro Workbook
08:16 Copy the VBA
09:31 Add custom button
10:49 Now for Part 2...
The ONE Excel Feature I Wish I Knew Sooner ruclips.net/video/Rdqxwq_zRbQ/видео.html
Thanks my friend. You can do the same thing in two clicks. First use pivot table/ use report then eache table will show up in different sheet.
Yes, thanks for mentioning Pivot Tables. I've seen two different ways to split data with PTs.
But one thing I like about VBA is that we have greater control to automatically customize the formatting, like I applied column auto fit in this example, which the PT methods don't do.
Also the PT methods I saw both left extra rows at the top of each sheet, for the report filter. With this VBA code, there are no extra rows.
Excellent solution. Thank you!!!
Fantastic solution 👌
Thanks man
Great video! Is this dynamic? If I add to the main table sheet will it automatically update on the correct separate sheet?
Well it's not dynamic in that sense, if you add or update the main table then it won't automatically update on the separate sheet. To do that with VBA would need event handler code to check for changes, and it would make the code more complicated.
@@launchexcel thanks for the reply!
Really cool. Thanks Chan. How do I add those controls on the top right? Filter, export, delete...lock, unlock? Don't have nothing of that on my 365
Hi Carlos, good spot! You’ve got a sharp eye, many people might miss those buttons up on top (for reference they appear at 3:00).
The ones you’re referring to (Filter, Export, Delete, Lock, Unlock, etc.) aren’t part of Excel 365 or any other version out of the box.
They’re custom controls I added myself in the same way I added the custom button at 9:31 in the video.
Since you asked, here’s a list of videos showing the macros behind the custom buttons:
➡Filter Table to Sheets: This video (ruclips.net/video/dNJWpdDWWA4/видео.html)
➡Export Worksheets: ruclips.net/video/Rdqxwq_zRbQ/видео.html
➡Delete Sheets Except Active: (no YT video, can learn how to do this in my VBA course)
➡Lock Sheets 123: ruclips.net/video/Cx2t4BD3Juo/видео.html
➡Unlock Sheets 123: ruclips.net/video/Cx2t4BD3Juo/видео.html (same as above)
➡Remove Excel Protection: ruclips.net/video/Cx2t4BD3Juo/видео.html (same as above)
Hope that helps you get those custom controls sorted. If you’re up for learning more VBA, the course goes into detail. go.launchexcel.com/macros-vba-school-youtube
Sir, I would like to use VBA in Excel to separate pages 1 and 2 of a Word document into individual PDF files.
If you want to do this from Excel, you would need to enable the Word Object Library in Excel VBA.
• In the VBA editor, go to Tools > References.
• Scroll down and check Microsoft Word xx.x Object Library (where xx.x is the version number).
• Click OK.
Then you would need to have the exact path to the Word document you want to process.
After that, it's a matter of figuring out the specifics of doing the export.
So it's possible with a certain amount of effort.