I'm trying to create a workflow which dynamically creates sheets in excel with data from FIELD NAME1 as the excel sheet names, and also would like to output FIELD NAME2 in the sheets based on their FIELD NAME1 data, starting from a specific row and column in excel. I have done successfully the part which dynamically outputs an excel file containing sheets named after FIELD NAME1 rows, but I don't know if I can also set a range in as to where it should start printing the FIELD NAME2 data.
Input:
FIELD NAME1 | FIELD NAME2 |
AA | 1234 |
BB | 4321 |
CC | 2341 |
... | ... |
Output: If I set the range from C5:C7, the output should be:
On Sheet AA Column C Row 5: 1234
On Sheet BB Column C Row 5: 4321
On Sheet CC Column C Row 5: 2341
...
Solved! Go to Solution.
@amfu
What would be value for C6 and C7?
There's one value on FIELD NAME2 for each FIELD NAME1 so there's only one value for now, but if there are more data (like this below), then values will also fill up until C7
FIELD NAME1 | FIELD NAME2 |
AA | 1234 |
BB | 4321 |
CC | 2341 |
AA | 1342 |
AA | 1243 |
... | ... |
Output:
On Sheet AA Column C Row 5: 1234
On Sheet AA Column C Row 6: 1342
On Sheet AA Column C Row 7: 1243
On Sheet BB Column C Row 5: 4321
On Sheet CC Column C Row 5: 2341
Thanks for the clarification.
We can create the full path then output the data with option "Preserve Formatting on Overwrite".
Thank you so much! I applied your solution and it worked!
@amfu
Good to know it helps.