I extracted a file but I want to break that file into individual workbooks . Each workbook with have its own corresponding sheets/Tabs. For example if Fund x has 7 managers -- I would like to see the workbooks for Fund 1 -- With a Tab for Fund 1 and manger 1005 1006 1007 -- a total of 4 tabs
Fund | Manager |
1 | 1005 |
1 | 1006 |
1 | 1007 |
2 | 2154 |
2 | 2155 |
2 | 2166 |
3 | 879 |
3 | 990 |
and than another workbook file for fund 2 and so forth.....
Solved! Go to Solution.
@ll98
Is something like this?
I'll give a try. Thanks
Similar to creating creating multiple workbooks based on Fund -- its possible to create individual Folder based on the Fund name.....
I think it is possible with a Run Command Tool inside a batch macro.