•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#auto fill
#drop menu
#N/A
#specific answer
#cells impacted
#C1
#C2
#option selection
#Excel
#conditional display
#automatic filling
#waste of time
#cell values