I am trying to dynamically change a drop down list based on values in a column in another table… For example, if in columns A I have the names Alex, John and Michael, I want to be able to
create a drop down list in another form that is being completed with the names Alex, John and Michael… However if another name is added to that column A e.g. George, I want the drop down list in the other form to automatically also include George now. Is this possible?
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |