Hello, I am trying to create a column where there is a drop down list in each cell and have the ability to select multiple options.
I know how to get the drop down list with data validation and I found this page that allows me to successfully select multiple (without repetition) with a VBA code.
However - this excel doc needs to live online (on sharepoint/onedrive) where the VBA becomes irrelevant.
Is there a way to set this up where it will work living online?
Thanks!
I know how to get the drop down list with data validation and I found this page that allows me to successfully select multiple (without repetition) with a VBA code.
However - this excel doc needs to live online (on sharepoint/onedrive) where the VBA becomes irrelevant.
Is there a way to set this up where it will work living online?
Thanks!