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

Copper Contributor

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.