Forum Discussion
Help with process to separate data from one excel file in multiple files in bulk
Hi All,
I have a process which is very volume intensive, however the system uploading the data is only able to extract and upload one row (a days) worth of data per an excel file. Given the large volume of data which needs to be uploaded, I am wondering if there is a way I can split information from one excel into multiple files. The goal is aiming to avoid manually copying and pasting rows of data, then saving as a separate file.
For the required information I have an excel file which contains all of the data which I need to separate into multiple excel files. The files I need to generate as an output require a specific naming convention. All the data is in the same format. For example if I have fund name "Fund 1", then the date is 1/11/2022. I need to save the file name as "Fund1.1-Nov-2022.xlxs".
Sample of the data, output file required and construction of the naming convention is attached. I would greatly appreciate any insights or assistance on how to potentially solve this issue.
Many thanks and greatly appreciate any help in advance,
- peiyezhuBronze ContributorI do not know where to attach files in this forum. i can use an online tool to split sheet. I wonder if it is ok for you. https://s1.ax1x.com/2022/12/04/zsVbD0.jpg