Skip to main content

Search

Search

Creating a new page and table when a value in excel changes

Comments

1 comment

  • Avatar
    Raj M

    Hi David, this is is possible.

    Bartender has tables inside labels, you would have to do a database conneciton to your excel file there.

     

    I would suggest adding another sheet into the excel document, and extracting the unique values from the main table. Something like below:

    =UNIQUE('Main Ledger'!B:C,FALSE)

    this will get you the following unique items. This will the sheet connected to the main database conneciton of the bartender file. Here create a named data source for customer.

     

    In the tables database, if you go to filter, here it should allow you to add a filter as such for the named data source. this basically helps with filtering the list to match the columns. 

     

     

    Then finnaly when you print it should look like this! Hopefully this is what you are looking for.

     

    0

Please sign in to leave a comment.