SOLVED
Data Extraction from DB -- to create multiple Worksheets along with respecting Tabs
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ll98
9 - Comet
‎02-05-2021
07:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Common Use Cases
4 REPLIES 4
21 - Polaris
‎02-05-2021
09:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ll98
Is something like this?
‎02-05-2021
11:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'll give a try. Thanks
‎02-08-2021
08:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Similar to creating creating multiple workbooks based on Fund -- its possible to create individual Folder based on the Fund name.....
21 - Polaris
‎02-08-2021
02:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think it is possible with a Run Command Tool inside a batch macro.
