dhouston1000
New Member
Can one dynamic workbook, containing multiple worksheets, behave as more than one using a KEY?
I am developing an event bar tracking workbook. It works as intended. I am looking to allow it to support multiple bars per singular event without copying the event worksheet. The issue is in selecting the inventory. It accesses an inventory tab that toggles X on or off based on the event's required criteria. This is then filtered onto the bartender worksheet. Sometimes, one of the 2 bars may be slightly different from the other in what it presents for sale at the same event. I am limited in using the workbook, as it is intended for use in Excel on Teams on a tablet. (no VBSCRIPT, and I develop at home and can not use scripts linked to buttons.)
The only method I've found is an Office Script that copies and pastes values into certain ranges. (ranges do not delete formulas.) After this script runs, the dynamic construction is removed, and values are locked in. It is the storing of the values. BAR_ID=1, BAR_ID=2, and so on. Can these values be stored in a master table or helper table, and then retrieved when the user or supervisor wants to see whichever bar they choose?
I asked Copilot about creating a giant LET(). As in, LET(this sheet, KEYED to BAR_ID=1, etc.). Then I asked if I could build a worksheet full of formulas, and another worksheet filled with indirect (pointing back to the formulas). Now I wonder if LAMDA could help.
The only method I've found is an Office Script that copies and pastes values.
I am developing an event bar tracking workbook. It works as intended. I am looking to allow it to support multiple bars per singular event without copying the event worksheet. The issue is in selecting the inventory. It accesses an inventory tab that toggles X on or off based on the event's required criteria. This is then filtered onto the bartender worksheet. Sometimes, one of the 2 bars may be slightly different from the other in what it presents for sale at the same event. I am limited in using the workbook, as it is intended for use in Excel on Teams on a tablet. (no VBSCRIPT, and I develop at home and can not use scripts linked to buttons.)
The only method I've found is an Office Script that copies and pastes values into certain ranges. (ranges do not delete formulas.) After this script runs, the dynamic construction is removed, and values are locked in. It is the storing of the values. BAR_ID=1, BAR_ID=2, and so on. Can these values be stored in a master table or helper table, and then retrieved when the user or supervisor wants to see whichever bar they choose?
I asked Copilot about creating a giant LET(). As in, LET(this sheet, KEYED to BAR_ID=1, etc.). Then I asked if I could build a worksheet full of formulas, and another worksheet filled with indirect (pointing back to the formulas). Now I wonder if LAMDA could help.
The only method I've found is an Office Script that copies and pastes values.
