•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Drop down list where each item can only be used once
Hello, I've created lists like these before but I haven't done this in close to ten years. I have a drop-down list with employee names and when I assign them to a work center I'd like them to disappear from the list of possible names for each subsequent work center. I know someone here will have an easy solution.
Thanks in advance!
[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
#financial modeling with spreadsheets
#Excel alternatives
#drop-down list
#employee names
#work center
#assign
#disappear
#solution
#possible names
#list
#ten years
#submitted
#easy
#comments
#create