Forum Discussion
Automatically select drop down list option based on value of other cell
Hi all I have a column with cells that are populated from a drop down list. I would like one of the list options to be populated auotmatically based on the value of another cell but I am not sure...
That would require VBA code, so it would work only in the desktop version of Excel for Mac and Windows, and users would have to allow macros.
Is that OK with you? If so, please provide more specific information.
