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
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