*Watch this video next* This ONE Excel Hack Will Save You Hours ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rsVxqxoMSDg.html *Click here for the article with full VBA code:* www.launchexcel.com/export-excel-worksheets-to-separate-files-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/66ed4c5fdaf87_Export-Excel-Worksheets-with-VBAv2.zip *Chapters:* 00:00 Export 30 Sheets Fast! 00:30 Do you use Excel like it's an old car? 01:07 Benefits of VBA 01:33 Unlock VBA secret menu 01:58 DEMO 03:05 Export one worksheet 09:56 Export ALL worksheets 13:01 Personal Macro Workbook 15:45 Don't stop here... This ONE Excel Hack Will Save You Hours ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rsVxqxoMSDg.html
Good question! I'm actually preparing a video to show how to split an Excel Table into separate worksheets based on category value. Keep an eye out for it, either next week or the week after. It could be what you need.