How to create mutliple work sheet
Hi
I want to create multiple worksheets using the filter option in the main sheet.
For example in the main sheet I have the customer information with the city name.
I want to create a worksheet for each City with the list of customers automatically.
Please let me know how to achieve this.
-
During Apply Filter you can select Create filter in new sheet. This will create a new single Worksheet containing the city with the list of customers. You would need to do this for every city.
In such case it might be easier to group the cities by using the GROUPBY function in 1st column, then simply copy the customer column to the 2nd column from the original sheet.
-
Hi
Thanks for your input and the interest , Appreciate it
Already I have used the Group by function and sorted the list by City. The requirement is to automatically create a new worksheet for each city , without manual intervention and create a job to export these worksheets in a file separated by city. Please let me know
-
Since your requirement is to automatically create a new Worksheets for each city, without manual intervention and later to create another job to export the data of these Worksheets into files separated by city, it comes more to customization.
You can leverage our REST API to achieve this goal. There are several calls for Workbook and Export Jobs available. With them it would possible update, create and execute artifacts.
Please sign in to leave a comment.
Comments
4 comments