Hi Excel Experts! Anyone here who can help me with file splitting? Basically, the macro is in one workbook which contains the main data. What I want the macro to do is to split the main data into different new workbooks - I need to filter one column which will define how many files I need to create (copy and paste, format into the format required and save the files in a folder.)
I am doing this everyday and it would really help me if I could somehow automate this since the workbooks I need to split usually reaches 15-30 workbooks a day. And I know it could be done easier. Please see the link below for my unfinished workbook. Thank you in advance!
https://www.dropbox.com/s/6ahrmgs1k9u4cyd/testing_1.3.xlsm?dl=0
I am doing this everyday and it would really help me if I could somehow automate this since the workbooks I need to split usually reaches 15-30 workbooks a day. And I know it could be done easier. Please see the link below for my unfinished workbook. Thank you in advance!
https://www.dropbox.com/s/6ahrmgs1k9u4cyd/testing_1.3.xlsm?dl=0