Hello! You describe how to create pulldown menus in cells. In my use case I'd like to create a table with a single row where the available choices in a pulldown of cell B1 depend on the actual selection in a pulldown in cell A1. Intention is to replace multiple selectize-items with a single ecxelr item.
More concrete:
- assume pulldown in cell A1 contains choices c("A001", "A002", "A003")
- while nothing is selected from cell A1, the pulldown in cell B1 is empty
- upon selection of "A001" in cell A1, pulldown in cell B1 is dynamically populated with choices c("B001", "B002", "B003")
- upon selection of "A002" in cell A1, pulldown in cell B1 is dynamically populated with choices c("B004", "B005")
- upon selection of "A003" in cell A1, pulldown in cell B1 is dynamically populated with choices c("B006", "B007", "B008", "B009")
I made some attempts with excelr but my outcome so far looks quite complicated. Do you happen to have some advice for this?
Hello! You describe how to create pulldown menus in cells. In my use case I'd like to create a table with a single row where the available choices in a pulldown of cell B1 depend on the actual selection in a pulldown in cell A1. Intention is to replace multiple selectize-items with a single ecxelr item.
More concrete:
I made some attempts with excelr but my outcome so far looks quite complicated. Do you happen to have some advice for this?