Hi,
I have an excel file which contains multiple excel sheets. I want to split these excel sheets into individual excel files where each file contains each sheet data. I used a workflow to divide it into multiple files. However, it is not reading the data present inside the sheets. I am certainly missing something.
I am attaching my sample data and the desired output which I want. Can you all please help me build the workflow ?
Thanks in advance!
解決済! 解決策の投稿を見る。
@Rahul_Analyst
Or you can use a VBA to do it?
https://trumpexcel.com/split-each-excel-sheet-into-separate-files/
@Rahul_Analyst
Thank you for the update and good to know it gets resolved. 😀
Hi @Rahul_Analyst ,
Could you please share your completed workflow. I am having the same need to split an excel file with multiple sheets into separate files with each sheets data.
Thanks,
Jonathan
@jsilavong Did you find a solution yet?
Hi there,
I need to do the same thing - split a big excel file of sheets into separate files (by sheet). Sometimes it gets more complicated and I need to group *some* of the sheets together (with no obvious rule) - but that's my next problem!
I was wondering if @Rahul_Analyst or @jsilavong had a completed workflow that does the simple splitting that they can share? I'm quite new here - Not sure if I'm just not finding it! Thanks!
Is there a place where this workflow is that I'm missing?