Saving An Individual Sheet To A Specific Folder With VBA

Saving An Individual Sheet To A Specific Folder With VBA

This video is taken from my Excel tutorial course, Excel Essentials Level 3, which will teach you everything you will ever need to know about coding in VBA.

If you like this video, please hit the subscribe button!

This is another student questions answered lecture...here's the scenario: We have a single workbook, with scores of different sheets, each one belonging to a specific territory manager (though it could be anything). The challenge is, if we make a change to anything in any of the individual sheets, a copy of THAT SPECIFIC sheet (and ONLY that sheet) is automatically saved to the SPECIFIC FOLDER that belongs to THAT SPECIFIC territory manager!
Really useful if you pull data from a system (sales data, for example), and you want to get specific portions of that data to specific people who have access to their own specific folders on the system.


This is a sample lecture from my course, Microsoft Excel Essentials: Level 3 - VBA Programming.
If you like this video, please hit the subscribe button!

This course is for suitable Excel 2007, Excel 2010, Excel 2013 and Excel 2016, Excel 2019 & 365

Check out the latest offers at:


Or get these courses now:
Level 1: Microsoft Excel Essentials: Level 1 Basics - Excel Made Easy
The complete 4 hour course is yours to buy with lifetime access for just $13.99 (normally $80) here, or for a low cost monthly subscription (first 2 months free!):


Level 2: Microsoft Excel Essentials: Level 2 - Intermediate/Advanced
The complete 7.5 hour course is yours to buy with lifetime access for just $14.99 (normally $100), or for a low cost monthly subscription (first 2 months free!):


Level 3: Microsoft Excel Essentials: Level 3 - VBA Programming + Macros
The complete 13.5 hour course is yours to buy with lifetime access for just $15.99 (normally $150), or for a low cost monthly subscription (first 2 months free!):

Alternatively, you can get the complete set in...
Excel Essentials: The Complete Excel Series - Level 1, 2 & 3

The WHOLE 24.5 Hour Excel Mastery Series In One! From Excel Novice To VBA Programmer...
Available to buy with lifetime access for just $16.99 (normally $200) here:


This is a sample lecture from my course, Microsoft Excel Essentials: Level 3 - VBA Programming.

This course is for suitable Excel 2007, Excel 2010, Excel 2013, 2016 & 365

Videos in the Level 1 series:










Videos in the Level 2 series:
















Videos in the Level 3 series:

Excel,Excel 2010,Excel 2013,Excel 2016,Office 365,Microsoft Excel,Microsoft Excel 2010,Microsoft Excel 2013,Microsoft Excel 2016,Microsoft Office 365,Excel for beginners,Microsoft Excel for beginners,Excel Essentials,Alan Jarvis,VBA,Visual Basic For Applications,save a single sheet,save a specific sheet,save a specific sheet to a specific folder,vba excel save a single sheet,excel vba save a sheet to a folder,