2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Having issues with drop downs and grouping

I made a workbook about 3 years ago, and don't remember some of what I did here. Pretty sure I did receive help here though, when I first made it, so I'm trying again.

On a second tab where all my 'info' is, I have a table with headers. On that tab, the headers on columns D-I are grouped as 'Shop'. On the main tab, I can select a shop by name in a drop down that's in cell D1, and via the INDIRECT function, a second drop down in B3 shows only the staff names that are in the same column within the same table on the 'info tab' as whichever shop I selected. My issue now, is we have new shops, and I have added 3 more columns to the table, but the second drop down (B3) on the main tab won't let me click on the arrow for the drop down, when any of the new headers are selected in D1. The originals still work as intended. I can't change the group 'Shop', as any time I try to ungroup it, I get an error saying I cannot ungroup it, and Shop was the source for data in D1. So, I just selected all 9 table headers for source in the data validation window instead. I don't know if the group is what's making the drop down un-selectable or not.

Any help or suggestions would be greatly appreciated!

submitted by /u/Healthy-Guard1060
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#real-time collaboration
#Excel alternatives
#drop down
#Shop
#data validation