Forum Discussion
Macro to split excel into separate workbooks
Please help. I am not new to excel but new to macros and VBAs, I have a large spreadsheet that I would like the data to pull out specific date based on a column and then create a separate workbook f...
I am looking to save the separate files in particular folder. What line would the file location replace?
Line 51 now says
MyPath = ThisWorkbook.Path
Change this to
MyPath = "..."
where ... is the path of the target folder.