Output file tabs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No idea if this is possible... but it seems like such a straight forward thing, so i hope there is.
SO, here is the idea:
I need to create an output in excel with multiple tabs. The multiple tabs (and the amount of the tabs) is dependent on something earlier in the workflow, where i grouped by something.
So, lets assume we have a column "country". If i did group by country, then in the summarise tool, i got for example:
France
America
Canada
Sweden
Japan
Can i link that summarise tool somehow to the output file (or reporting, or whatever it may be), to name the tabs accordingly?
IF THAT IS POSSIBLE (then firstly, yay!), then 2nd question, is there a way to link the tab to the *correct* data?
I.e earlier in the workflow i will have to separate all data for the 5 countries above, and i would need the output files tab name match the country data in the tab?
Thanks a million!
Natalia
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @nataliad18 yes it is possible have a look at this article which explains how to do it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @PhilipMannering - simple and clear :)
![](/skins/images/1BCDCA369E03A68F7CCF4EA08E8C29B9/responsive_peak/images/icon_anonymous_message.png)