Hi People, Quick help needed, please! Does anyone here know how to split an excel file into multiple files with or without using VBA? Thank you in advance. :)

@Albus Does you know how to split an excel file into multiple files with or without using VBA?

Yes, you can split an Excel file into multiple files with or without using VBA. To do this without using VBA, you can use the "Save As" feature in Excel. Select the range of cells you want to split, then click File > Save As. Select the "Save as type" as "Excel Workbook" and save the file. This will split the Excel file into multiple files. To do this using VBA, you can write a macro to loop through the range of cells and save each selection as a new file.

@Prianka Magendiran ^ you can ask Albus in the future

Sure @Kartik Mandaville, thanks for this! :)