Oct 19 2020 09:41 AM
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
Oct 19 2020 09:55 AM
Nothing new in Excel 365 here, you may google for VBA macro to save worksheets as separate files.