Create multiple workbooks; 1 for each sheet within my current workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1796231%22%20slang%3D%22en-US%22%3ECreate%20multiple%20workbooks%3B%201%20for%20each%20sheet%20within%20my%20current%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796231%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20received%20an%20Excel%20workbook%20with%20each%20employees%20info%20listed%20on%20their%20own%20%22Sheet%22.%20I%20am%20currently%20going%20sheet%20by%20sheet%20and%20%22saving%20as%22%20for%20each%20sheet.%20New%20to%20365%2C%20wondered%20if%20there%20is%20a%20way%20to%20extract%20all%20sheets%20to%20their%20own%20independent%20files%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20searched%20a%20few%20ways%20and%20don't%20know%20if%20it's%20not%20possible%20or%20if%20I'm%20not%20describing%20it%20correctly%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1796231%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796302%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20multiple%20workbooks%3B%201%20for%20each%20sheet%20within%20my%20current%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796302%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F838020%22%20target%3D%22_blank%22%3E%40Patricknwa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENothing%20new%20in%20Excel%20365%20here%2C%20you%20may%20google%20for%20VBA%20macro%20to%20save%20worksheets%20as%20separate%20files.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a received an Excel workbook with each employees info listed on their own "Sheet". I am currently going sheet by sheet and "saving as" for each sheet. New to 365, wondered if there is a way to extract all sheets to their own independent files? 

I've searched a few ways and don't know if it's not possible or if I'm not describing it correctly?

 

Thank you

1 Reply

@Patricknwa 

Nothing new in Excel 365 here, you may google for VBA macro to save worksheets as separate files.