Fund Name | Commitments |
Fund 1 | 50000 |
Fund 2 | 45000 |
Fund 3 | 40000 |
Fund 4 | 100000 |
I'm having creating a separate file based on Fund. Hence, I need to create a file/workbook for each of Fund. I also want to name the tab the Fund Name
Hi @ll98
Try this, you will have to create a formula to specify file name and sheet name as mentioned below.
Use this config to output data into multiple excel files.
Output.
If this works kindly mark this post as solution.
Thanks.
Thanks Sapna .. But the tab name - I want to see the actual Fund Name ... i.,e Fund 1
If you choose the Fund Name column, the tabs will be named by each fund. Are you finding this to not be the case? You will need to choose
Thanks,
Seth