• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to refresh data in a template

herclau

Member
Hello,
In the book attached there are two sheets, Data and Sheet1.
My intention is to configure Sheet "Sheet1" as a Template. The "Data" sheet presents the data embedded within the table named: "tblData".
From the template it should be possible to select the column of interest from the "tblData" table using the drop-down list in C1 and update:
1. The "Status.Array" array
2. The table "tblStats.
In order to perform the rest of the calculations found in the template.
Everything I have done, so far, does not update the arrangement and the table !!!!
How to configure the sheet "Sheet1", the tables and the array to obtain the objective?

Gracias
 

Attachments

p45cal

Well-Known Member
On my system, Status.Array and tblStats DO update on changing C1, but it does take a few seconds.
 

herclau

Member
Please,
Could you give me a website or examples, where I can learn how to implement a template like the one mentioned above!
 
Top