•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I am trying to depending of a value to auto fil some cells or use a drop menu when other values are selected
I am trying to fill automatically some cells is one cell has a specific answer and if not use a drop menu
I can do a drop menu that lead to different drop menu but even even with only one choice, I still have to pick up the answer, so waste of time
if cell c1= No, I want all cells impacted by the NA to display directly N/A and if cell c1 is applicable, I want a drop menu to chose the options
How can I force C2 to display N/A when C1 is no and keep the drop menu option for the other case?
[link] [comments]
Want to read more?
Check out the full article on the original site