Forum Discussion
Drop down list "moving" selection when selected in another cell
Does the VBA code in the attached file work as intended? If you select a name from a dropdown in a cell in range F5:F24 the code checks if this name is found in range E5:E24. If it is found in E5:E24 then it gets cleared. The corresponding result is returned for a name selected from a dropdown in a cell in range E5:E24. The ranges in the VBA code can be changed according to the actual size of the "zones".
You gave a lot of context, which was helpful.
What I didn't see was any reference to the solution I gave you, which does work, work simply, and (unless I'm missing something) would work in the context of what you describe. Did you even open it?
Does the VBA code in the attached file work as intended? If you select a name from a dropdown in a cell in range F5:F24 the code checks if this name is found in range E5:E24. If it is found in E5:E24 then it gets cleared. The corresponding result is returned for a name selected from a dropdown in a cell in range E5:E24. The ranges in the VBA code can be changed according to the actual size of the "zones".
- This is exactly what I was looking for thank you so much!
I just don’t want the actual work flow of moving someone being in a table to the side like that. I prefer the cleaner look of just the “zones” being visible and hiding the table with the names to make it easier for them to glance at and print off.
I copied your layout images in what I did. Your original layout didn't do (or even hint at) what you're now saying you want.
It's easy to separate the input from the output, with only the latter visible to "them"
See the attached.
- Respectfully sir, I’ve been saying I wanted the exact same thing since the very first post. A method to automatically clear the old cell when I select them somewhere else. I don’t want the workflow of “moving someone” to happen in the table of names because I prefer to keep that table hidden. The only reason I included it in the example was to show you. My leads wouldn’t know how to hide/un-hide the table used to move people in the method you proposed.
