Mar 23 2022 03:54 AM
I have the next scenario:
I want to automatically have updated this Excel tab "B" (users just want to consume it, not entering data here):
Columns: Tests (static)
Rows: Instruments (static)
Body: "Values" (from Excel tab"A") [What I want to trigger automatically!]
Users interact with the tab "A" where they select in a dropdown the "Test" (rows) and mark with "X" when it relates with an "Instrument" on the columns:
They can select the same "Test" multiple times to place a new "Value to show" for other kind of Instruments.
For the "Instruments" and the "Test" when "X" selected we want to show the "Value to show" in red on the tab "B".
Considering the "CMR Drawer" Test as an example that represents the most complex case, I want to have on the Excel tab "B" the next:
I want to take, for the same "Test" (these are added temporary descending), the last values marked with "X" for an Instrument but considering the previous ones if them are not marked with an "X".
Thank you!
Eric
Mar 23 2022 04:01 AM
Mar 24 2022 01:44 AM