How to create mutliple work sheet

Comments

4 comments

  • Muralidharan

    Please let me know further information is required to solve this .

     

    Thanks

    Murali

     

    0
    Comment actions Permalink
  • Gido

    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. 

    0
    Comment actions Permalink
  • Muralidharan

    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

     

    0
    Comment actions Permalink
  • Gido

    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. 

    0
    Comment actions Permalink

Please sign in to leave a comment.